Get the code and more details in the blog post. www.powerapps911.com/patch

Your continuous support in the Power Platform is greatly appreciated. Thank you.

@ShanesCows

Жыл бұрын

You are very welcome

Shane you are so generous and kind for sharing this content. Thank you for all the help!

@ShanesCows

Жыл бұрын

You are welcome 🤩🤩

Just …thanks. Your ability to empathise (empathize in your neck of the woods 😄) is just phenomenal…so great for any level user.

This video is pure gold. One of your best IMO

@ShanesCows

2 ай бұрын

Thank you, that means a lot to me. 🐶

Shane ALWAYS has the answer.

@ShanesCows

2 ай бұрын

Happy to help

Thank you Shane Young. The multi select is a take home for me

@ShanesCows

Жыл бұрын

Awesomeness 😎

This was incredibly helpful thank you

@ShanesCows

3 ай бұрын

Awesome, I appreciate the comment.

Bro, you deserve an award

@ShanesCows

8 ай бұрын

Thanks 🏆

The max! Shane! Thank You!!!!

@ShanesCows

8 ай бұрын

Happy to help

Brilliant video - thank you so much! For next steps I'd love to learn how I can filter galleries by multi-choice columns or send emails to multi-person in Flow.

@ShanesCows

Жыл бұрын

Sarah the filtering answer is in this video. kzread.info/dash/bejne/i42d3MORZsq-h5M.html The concept taught is exactly what you need to do even though the video is slightly different. 🙂 The flow one I haven't done. Good idea. 🤩 I will add it to my list.

Thanks Shane 🙏🙏🙏

@ShanesCows

Жыл бұрын

Happy to help. Have a great day. 🐶

Shane, I was pulling out my hair for two hours trying to get powerapps to accept my record was actually a record before finding your video! Thank you! (I love the inclusion of Buddy in your videos btw 😋😋)

@ShanesCows

Жыл бұрын

Thanks James. 🐶

Thanks Shane

@ShanesCows

Жыл бұрын

Happy to help Sundra!

Excellent sir!

@ShanesCows

Жыл бұрын

Thank you kindly!

Great video. Thanks for putting this together. In 21:06 for the multiperson input, is there a way to enter all the people without listing them one at a time?

Thank you so much for your very helpful video. How would one patch multiple records in a gallery to their respective lookup columns in a SharePoint list?

Hi Shane - great videos and all explained very well. How would you use the data from a complex column say multi select column in a combo box to filter a gallery?

Hi Shane, Great amazing outstanding video. I just have a quick question: I have a multi select person column, and I want to add a new person to that column ensuring that the existing persons does not get removed. GREAT THANKS.

Thanks for your explanation. Does a person column have to be a combo box? I used a dropdown to auto complete text input fields that pulls in job title in one field and dept in another. Populates as expected but when patching i did multiple {odata...} for each of those fields updating the dept: and job title: separately. No code errors but it doesnt pull data back to the SP list.

Hi Shane , I have a task which has been giving me the hardest time. I have two lists One has Student ID Name of student and the rest of the columns have a class and then a score and so on it could be up to 15 columns with corresponding grade. but I must use a look up list which has the class title , the description of the class and the respective points for each class. Even though the classes are the same they have different scores based on if is a freshman or senior. I just so lost have no idea where to go from here .

Hi, very good explanation and i am looking to add values manually dropdown list in PowerApps using SP List

@ShanesCows

Жыл бұрын

Something like this? kzread.info/dash/bejne/eZqNmJWDgMfRk9Y.html

Hi, Shane. How about patching combo box values with multiple selected items that is using a lookup field from another SP list? Been cracking my head over this for the past weeks. Hope you can help and thank you in advance.

Hi Shane, first of all, I find your Power Apps tutorials very helpful! 😎 I have one quick question, I have an app that I am building that tracks the tasks completed on a construction project for each unit. I have all of the tasks in a gallery and one of the controls in the gallery is the 'add picture' control one, so when populating the Patch Function, I am trying to the '.Image' string at the end of the name of the control but it isn't populating as an option and is saying an error when I still put it in. Any ideas what might be happening? 😅

Good Content.Thanks Shane..and asked one question in last short comments can you provide answer for it.

@ShanesCows

Жыл бұрын

DOne

@manjunathak4822

Жыл бұрын

♥️Thanks

Hi Shane, Thanks for the video. In my case, i have 70-80 managed meta data terms and when i choose combo box field in the front end, app displays the top 20 items only. Though user can search as you type but it’s not like end user will be aware of all the ‘startwith’ keywords of these terms. Any workaround for this issue? Thanks!

@ShanesCows

Жыл бұрын

Use a gallery instead of a combo box. It will take up more space but if you do a little work you can make it look nice and not too big. 🤩

@usernameksrk

Жыл бұрын

Thanks for the response. Will try that and see if i can patch the gallery selections to the SP list

Hi Shane, I believe the image column has changed in SharePoint. I tried to take the uploadedimage.image property and use it to patch an image column, but it told me that it expects a record, not text. I did some further digging and found that SharePoint image columns now have 4 properties and are therefore stored as a record: Full, Large, Medium, Small. I would assume these are meant for resolution differences and better performance based on image size. I still cannot figure out how to patch directly to the column. It shows up blank even when I patch the column using a record like: {Full: uploadedimage.image, Large: uploadedimage.image,... (and so on). I'm able to patch to a multiple lines of text column, but the image column will not save successfully. Any ideas?

Thanks for this. I was getting stressed chasing my tail trying to patch a 'request submitter' to a multi-person choice column. I thought what I had made sense, but it simply was not working.

@ShanesCows

2 ай бұрын

Happy to help

Hello, thank you! I'd like to ask a question related to same topic.. I have a person column in SP list and I show this person name in the ComboBox (as DefaultSelectedItems). I need use this info (from ComboBox) in the "Patch" function. I tried as you explain in the video for person columns. But I couldn't use ComboBox output in the script, you use already as string (like email) in your code. How can I solve this?

@ShanesCows

Жыл бұрын

Leave a new comment with your Patch formula and I will look at it. What is the Items property of your Combo Box also?

hey I simply want to patch the combobox data to my sharepoint document library is it possible ? coz u have used list and i am using document library ,

Hi, thank you for helpful content. Shane I'm new here and I'm looking for a way for using power app in SharePoint On-Perm. Have you any content in this subject?

@ShanesCows

Жыл бұрын

Nima Power Apps is only in the cloud. You can connect to on-prem via the gateway though. kzread.info/dash/bejne/p6WswcptidCenso.html

So what would be the best way to patch attachment links to a column? with a HyperLink? Solutions appreciated!

@ShanesCows

Жыл бұрын

This works for me 😎 Patch(Law, Defaults(Law), {Title: "Test", HyperLinkColumn: "training.powerapps911.com"})

Hey Shane, great Video I loved it! I have a question about the PowerApps Calendar you made a year ago. Today is the 7th february and my Calendar is still showing me the days from January. If I press the Button "Start here" which should refresh the Calendar it always gets me back to January.. do u know how I can fix that ? Thank you so much and greetings from the beautiful germany!

@ShanesCows

Жыл бұрын

Hi Nico. I am not sure why your calendar would be doing that. I just opened mine up and it jump to Feb like it should. 😐 HEre is my OnStart code if it helps. Set(varFirstDayMonth, DateValue(Month(Today())& "/1/"& Year(Today()))); Set(varFirstDayViewMinus1, varFirstDayMonth - Weekday(varFirstDayMonth) ); Set(varFirstDayViewNextMonth, DateAdd(DateAdd(varFirstDayMonth, 1, Months) , 7- Weekday(DateAdd(varFirstDayMonth, 1, Months)),Days) ); ClearCollect(colSharePointEvents, Filter('Test Events', (StartDate > varFirstDayViewMinus1 And StartDate varFirstDayViewMinus1 And EndDate

@nico4im466

Жыл бұрын

​@@ShanesCows Its not working and I really dont know why. Here´s my code, maybe you can detect why it´s not working. Set(varVideoMonth; DateValue(Month(Today()) & "/1/" & Year(Today())));; Set(varVideoFirstDayView; DateAdd(varVideoMonth; - Weekday(varVideoMonth; Monday); Days));; Set(varVideoFirstDayNextMonth; DateAdd(DateAdd(varVideoMonth; 1; Months); 7 - Weekday(DateAdd(varVideoMonth; 1; Months)); Days));;

@ShanesCows

Жыл бұрын

@@nico4im466 Try taking out the Monday and see if you get the right answer? I am wondering if you need to add Monday into the logic for varVideoFirstDayNextMOnth? Sorry, hard to troubleshoot without me recreating it all. 😔

@nico4im466

Жыл бұрын

@@ShanesCows Hey Shane, nothing is working and my brain is exploding cause I can´t fix it. I tried to add and delete monday as you told me but its still not working. Everything works, only the automatic switch to the next month is giving me problems over problems. But thank you for trying to help, I appeciate it! 😒

@nico4im466

Жыл бұрын

@@ShanesCows Nevermind, I was looking for some answers via ChatGPG and it worked. This App is genius and helped me instantly. Have a great day Shane!

Thanks for the video. The link to the blog post doesn't work, however.

@ShanesCows

Жыл бұрын

www.powerapps911.com/patch Hmmm. I will go double check it. Sorry about that Kim. Hope you are doing well. 🤩

Hello Shane, how can we patch sharepoint location column

@ShanesCows

Жыл бұрын

I have never tried that one. Not sure, I will have to add that to my list to try.

I think you tweeted that you slaved 9 hours of video editing on this, over and above generating the SharePoint site and app in Power Apps, so thanks! Would you care to produce a Dataverse version of this, perhaps for columns that require slightly different Patch syntax? (I’m working from memory, but I seem to recall a terrible time I had trying to patch a multi choice Dataverse field, particularly when updating the record as opposed to patching default etc.) Enjoy the Super Bowl?

@ShanesCows

Жыл бұрын

Gerald I was thinking a DV version of this was a natural next step. :) It is on the list for sure. 😍

@renedoucet2849

Жыл бұрын

@@ShanesCows that's great.. I definitely second the request for DV version. Thanks for the video!

@AmyCustomer

10 ай бұрын

@@ShanesCows I wish you included a version where all the column types are patched from a nested GroupBy gallery. I'm finding it quite impossible.

@ShanesCows

10 ай бұрын

@@AmyCustomer that is too specific. You can submit your question/details in the free help contact form over at www.powerapps911.com and maybe someone on the team can nudge you along. 😎😎

Great video, but I am getting an error for "Missing column. Your formula is missing a column 'Id' with a type of 'Number'. I don't have a column with that besides the default ID column. Not sure what I'm doing wrong when it looks exactly like what you're doing. Any help is appreciated.

@Justinline

Жыл бұрын

I realized there's an issue with the Lookup column I'm using that's populated by another SP List.

@ShanesCows

Жыл бұрын

Glad you got it Justin.

Why we would use static data? I mean what is static data?

@ShanesCows

10 ай бұрын

For example maybe you want to automatically set the Manager to the logged in User or the Hire Date to Today's date. The idea is it is "static" because the user isn't entering it, the formula has the value "hard coded". Hope that helps

@thewanderingcouple8378

10 ай бұрын

@@ShanesCows yeah that means default value.. Thanks Shane 😊

how can i resolve this im getting this error during the first patch no problem on the next patch 👉The requested operation is invalid. Server Response: my_table failed: Save Conflict. Your changes conflict with those made concurrently by another user. If you want your changes to be applied, click Back in your Web browser, refresh the page, and resubmit your changes. clientRequestId: 4defca3f-a93a-4fb3-8454-ab00364b35c1 serviceRequestId: 4defca3f-a93a-4fb3-8454-ab00364b35c1...

I am trying to patch multiple values from combo box and used similar code as in video but i get error that "Expecting a Table but different schema" .Here is my code: Patch(A360Forms,{EmployeeName:NameInput.Text,Email:Email_text.Text, Jobtitle:Jobtitletext.Text,RequestedMarkets:ComboBoxMarkets.SelectedItems,BusinessJustification:BusinessJustificationText.Text}) Any Idea?