Get the code and more details in the blog post. www.powerapps911.com/patch
@ethioone7136
Жыл бұрын
Your continuous support in the Power Platform is greatly appreciated. Thank you.
@ShanesCows
Жыл бұрын
You are very welcome
@noodle4noggin
Жыл бұрын
Shane you are so generous and kind for sharing this content. Thank you for all the help!
@ShanesCows
Жыл бұрын
You are welcome 🤩🤩
@luket3432
11 ай бұрын
Just …thanks. Your ability to empathise (empathize in your neck of the woods 😄) is just phenomenal…so great for any level user.
@MichaelDeBlasis1369
2 ай бұрын
This video is pure gold. One of your best IMO
@ShanesCows
2 ай бұрын
Thank you, that means a lot to me. 🐶
@oluwatobipaul6171
Жыл бұрын
Thank you Shane Young. The multi select is a take home for me
@ShanesCows
Жыл бұрын
Awesomeness 😎
@MichaelDeBlasis1369
2 ай бұрын
Shane ALWAYS has the answer.
@ShanesCows
2 ай бұрын
Happy to help
@andre090598
8 ай бұрын
Bro, you deserve an award
@ShanesCows
8 ай бұрын
Thanks 🏆
@MrsLaubie
Жыл бұрын
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. kzitem.info/news/bejne/uo-f4JWOb5mJimU 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.
@MultiSweetc1
3 ай бұрын
This was incredibly helpful thank you
@ShanesCows
3 ай бұрын
Awesome, I appreciate the comment.
@jamesambrose2834
Жыл бұрын
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. 🐶
@robertorodriguez8186
8 ай бұрын
The max! Shane! Thank You!!!!
@ShanesCows
8 ай бұрын
Happy to help
@paolovr1970
Жыл бұрын
Thanks Shane 🙏🙏🙏
@ShanesCows
Жыл бұрын
Happy to help. Have a great day. 🐶
@TheRhoadesFamily
Жыл бұрын
Excellent sir!
@ShanesCows
Жыл бұрын
Thank you kindly!
@sundrapillay6668
Жыл бұрын
Thanks Shane
@ShanesCows
Жыл бұрын
Happy to help Sundra!
@carolerlston3876
Жыл бұрын
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?
@kwamebuanyinaohemeng919
Жыл бұрын
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?
@MultiSweetc1
2 ай бұрын
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 .
@Rob_K0
Ай бұрын
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?
@marcy4227
Ай бұрын
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.
@jatinsaini7773
Жыл бұрын
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.
@avocadoarmadillo7031
2 ай бұрын
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
@jekyllhyde05
5 ай бұрын
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.
@FineTuningAnalysis
4 ай бұрын
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? 😅
@ArkysisGaming
8 ай бұрын
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?
@shathike4079
Жыл бұрын
Hi, very good explanation and i am looking to add values manually dropdown list in PowerApps using SP List
@ShanesCows
Жыл бұрын
Something like this? kzitem.info/news/bejne/qJyPnGeAiZaclqg
@shreyasonawane8119
Жыл бұрын
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 ,
@manjunathak4822
Жыл бұрын
Good Content.Thanks Shane..and asked one question in last short comments can you provide answer for it.
@ShanesCows
Жыл бұрын
DOne
@manjunathak4822
Жыл бұрын
♥️Thanks
@erenuyank4153
Жыл бұрын
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?
@usernameksrk
Жыл бұрын
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
@nico4im466
Жыл бұрын
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!
@NimaRamharand
Жыл бұрын
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. kzitem.info/news/bejne/1qeuxZxqkp9poZw
@masiemil2584
Жыл бұрын
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"})
@kimsalas8197
Жыл бұрын
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. 🤩
@user-mj3xe6hy7q
Жыл бұрын
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.
@geralddahl9159
Жыл бұрын
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. 😎😎
@Justinline
Жыл бұрын
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.
@thewanderingcouple8378
11 ай бұрын
Why we would use static data? I mean what is static data?
@ShanesCows
11 ай бұрын
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
11 ай бұрын
@@ShanesCows yeah that means default value.. Thanks Shane 😊
@zzerozero2722
Жыл бұрын
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...
@prempasanha3
Жыл бұрын
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?
Пікірлер: 83