How to use PATCH Function in Power Apps | Insert and Update data

Подписаться 128 тыс.

Просмотров 175 тыс.

50% 1

In this video, you will learn all about the Patch Function in Power Apps. Patch allows us to insert or update one or more records in a data source, or merge records outside of a data source. Use the Patch function to modify records in complex situations, such as when you do updates that require no user interaction or use forms that span multiple screens.
You will learn how to use the Patch function to Add and Modify items in a SharePoint List, perform error handling with Patch (Formula level error management), set columns to empty value, set complex type columns (Choice, Person) in SharePoint, modify multiple records (bulk operations) in SharePoint by using Collections and Patch, Patch Form Control updates and more.
Patch syntax:
Patch( DataSource, BaseRecord, ChangeRecord1 [, ChangeRecord2, … ])
Helpful Links 🔗:
Power Apps SharePoint Column Syntax (Lookup, Choice, Person)
rezadorrani.com/index.php/202...
PowerApps Patch Function
• Power Apps Patch funct...
Patch function in Power Apps (documentation)
docs.microsoft.com/en-us/powe...
Multiple Screen Form Control & Patch in Power Apps
• Multiple Screen Form C...
#PowerApps #Patch #SharePoint #PowerPlatform
Table of Contents:
00:00 - Introduction to Patch function in Power Apps
00:33 - Patch with SharePoint List
01:26 - Create item in SharePoint using PowerApps Patch command
04:50 - Patch complex type columns in Power Apps
07:02 - Update SharePoint item column values with Patch
12:25 - Set Blank Value & Error Handling using Patch function
15:02 - Using Patch in Gallery (Power Apps Example)
19:14 - Patch Person, Date & Text columns in SharePoint
23:37 - Bulk operations using Patch
27:56 - Multi Screen Forms using Patch
29:21 - Subscribe to Reza Dorrani channel
🤝 Let’s connect on social:
🔗 Reza Dorrani LinkedIn: / rezadorrani
🐦 Reza Dorrani Twitter: / rezadorrani

Наука

Опубликовано:

8 июл 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 441

@paulskelton8799 Год назад

Brilliant! So many fabulous tips and great information, along with an excellent 'ideas' use case thrown in, within such a short timeframe

@RezaDorrani Год назад

Thank You Paul

@shondataliaferro285 8 месяцев назад

Rezza! You be teachin'! Patching, as described by others who shall remain nameless, left me so totally confused and thinking I need to avoid using this functionality altogether. This video as well as your resources have really opened up the concept for me. Thank YOU!

@RezaDorrani 8 месяцев назад

Im happy to hear this video is simple and effective. I try very hard in each video to make sure I make it simple for everyone. Thanks for the feedback.

@waynewei3380 Год назад

Thank you so much for this demo. This is one of the best videos for patch function. This varIdea and blank() really take the functionality to the next level.

@RezaDorrani Год назад

Great to hear!

@dougydoe Год назад

Great video with extremely useful content. I've been using Patch but still learnt a great deal watching this video. The various aspects and ways we could use it is really amazing. Thank you for stretching our creative skills.

@RezaDorrani Год назад

Glad you enjoyed it!

@TheFunkBros Год назад

You did it again... once again, I'm trying to figure out how to use another feature and I was stumped until this video and you covered the topics I needed which was the choice column, Thank you for doing more than the basics but covering other topics like different column types. It worked... now my form can update the field with the click of a button which triggers my powerautomate flow which completes the automation of my business service task. Thank you and Please keep doing what you're doing!

@RezaDorrani Год назад

Wow! Thanks Barney for the amazing feedback. I will keep trying my best.

@UB-qc8yk Год назад

Awesome as usual, you never cease to amaze me. I've been using Patch for some Years now, I still learnt new tips from your video.

@RezaDorrani Год назад

Glad to hear that! Thanks for watching

@jamesclark2020 Год назад

When I used forall to bulk patch it took almost two hours to do 200 records- almost unusable This method reduces that time by orders of magnitude I did have to modify the patch formula to get it to work correctly For some reason when I ran Patch(SPList,collection) it would create new items instead of changing existing items. I don’t know why So I found a blog post by Matthew Devaney that provides this formula: Patch(SPList,ShowColumns(collection,”ID”),collection) and it worked exactly as I described and very quickly updated almost 200 SP list items. I appreciate your videos and all of those extra user experience and performance tips that you always provide with them. Again I am very happy that this works so well. 😊

@RezaDorrani Год назад

Thanks James! If collection contains the unique key of the data source (lets say ID in SharePoint), then it will update the item. If it does not find or ID is blank in collection, it will create a new item. You can also check ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-VzrarcM9W5k.html

@jesterc Год назад

Took me ages to work this out - should have known to come straight here - your examples and real-life solutions are epic!

@RezaDorrani Год назад

@TheFunkBros Год назад

me too... this is the 2nd time for me.... from now on I'm coming to this guy first!

@RezaDorrani Год назад

@@TheFunkBros Thank You both

@Cordycep1 Год назад

thank you very much, that column CHOICE for combobox gave me a big headache for more than a week. Also, you help me undestand why I was creating 1 extra blank record whenever I patch.

@RezaDorrani Год назад

You're most welcome!

@kireetiyakkali Год назад

Thanks a lot Reza! Probably this is the great video on Patch() function that I have ever seen.

@RezaDorrani Год назад

Wow, thanks!

@MrAbumuhammad123 4 месяца назад

This is life-saving indeed! I got a breadth of relief after learning this video. Thank you so much.

@RezaDorrani 4 месяца назад

You're most welcome!

@SHAli1474 Год назад

Another great, clear and to the point video. Thanks Reza

@RezaDorrani Год назад

My pleasure!

@user-yt6jl2qk4v 5 месяцев назад

You are amazing, Reza! THANK YOU! I was able to figure out how to make my app work by applying some of these formulas!

@RezaDorrani 5 месяцев назад

Fantastic!

@marieraymond6512 Год назад

This is one of most useful videos for me. You're amazing!

@RezaDorrani Год назад

Glad it was helpful!

@oluwatobiyusuf Год назад

Thanks for the great refresher on Patch function.

@RezaDorrani Год назад

Glad to hear that. Thanks for watching.

@poteaugs 2 месяца назад

Such an amazing video... very helpful and love the examples. There are so many hassle things that are summed up by watching your content. Keep up the great work and thank you for helping us out!

@RezaDorrani 2 месяца назад

Most welcome!

@tmccann887 3 месяца назад

Reza to the rescue (again)! I was confused about how to update an existing record in a Sharepoint list as opposed to adding a new record. LookUp was the key and Reza explained it beautifully.

@RezaDorrani 3 месяца назад

Reza says Thank You

@kayodeojo8572 Год назад

Thanks a lot Reza, I really needed this you are the best!!

@RezaDorrani Год назад

My pleasure!

@luciozanarotto1974 Год назад

This video and others are wonderful. You are great Reza, congratulations!

@RezaDorrani Год назад

Thanks Lucio

@barunroyghatak4380 Год назад

Thanks Reza this video is really worthful for beginners.

@RezaDorrani Год назад

Glad to hear that

@gauravdhingra713 Год назад

Rezaaaaaaaa Man - You are just amazing!! Earlier I was wondering why people are writing so many appreciative comment. Now I can relate. Hence joining the boat.. Awesome work Man :)

@RezaDorrani Год назад

Thank You so much Gaurav

@andrewghose4788 Год назад

Very Helpful! Great video!

@RezaDorrani Год назад

Thanks

@manjeetsinghutube 7 месяцев назад

This is Fantastic example... Thanks

@RezaDorrani 7 месяцев назад

Glad you liked it!

@scottmatson3313 Год назад

Excellent video!

@RezaDorrani Год назад

Thanks Scott

@subhamagrahari9193 11 месяцев назад

Honestly Speaking- My manager asked me to creat a form on power apps and just because of your video i was able to impress him Thank you for such a wonderful knowledge sharing One request as patch does not support attachment plz do something as alternative

@RezaDorrani 11 месяцев назад

Glad to hear the video was useful. Patch does not support attachments. Alternatives are form control or call flow from power app. I have done many videos related to form control and ones for attachments. You can check those.

@mauricioetienne3379 Год назад

Amazing video Reza, firstly I would really like to thank you for all I have learned from you! 🙌🏻 This has really made me set new ambitious goals for my next couple of years… I just have trouble with the Patching & Updating of the data don’t know why. Followed exactly as your video, maybe there were some updates on coding etc Either way thanks a lot!

@RezaDorrani Год назад

Thanks for watching and learning from the videos. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

@enitesh Год назад

Great video. Lots of little thinks that can help us to develop apps in better ways

@RezaDorrani Год назад

Glad to hear that! Thanks for watching.

@daniellizarraga8726 Год назад

Hi Reza, very useful and valuable information in the video. Thank you very much for sharing.

@RezaDorrani Год назад

Most welcome

@akilabenjamin8268 Год назад

Reza Dorrani Always brings us something New

@RezaDorrani Год назад

Thanks

@shaikhfirdos2723 Год назад

Very useful information explained..Thanks Reza.

@RezaDorrani Год назад

Most welcome

@MrGaztab Год назад

Great video, thank you for the content.

@RezaDorrani Год назад

Your most welcome

@ajayv304 Год назад

Thanks Reza. I have replicated the steps explained by you and I created an App for Idea Generation which I would refine as per my use cases. Thanks a lot.

@RezaDorrani Год назад

Glad it helped!

@ajayv304 Год назад

@@RezaDorrani I have a query regarding the Sort Function. I tried to Sort the Gallery with Sort('Work Tracker Test',Status.Value,SortOrder.Ascending). But the issue is that, it has thrown me delegation error. Can u please suggest how to get rid of this delegation error. From your other videos, I understood what exactly Delegation is all about and how it is useful. Thanks for clear explanation. U have displayed Delegation concept in FILTERING Gallery items (ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-zxZGaXQlZqo.html). Can u please help in the case of SORT too.

@RezaDorrani Год назад

You cannot sort directly on complex type columns (delegation challenge). Check ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-6KlI1iZ_KD0.html

@RanjitSingh-xk9sb Год назад

Very helpful. Thanks

@RezaDorrani Год назад

Thanks for watching

@jray1429 Год назад

Great Job!

@RezaDorrani Год назад

Thank You

@douyincutest Год назад

Really nice, thanks Rezza so much

@RezaDorrani Год назад

My pleasure!

@dododad4997 11 месяцев назад

Really interesting knowledge .. will come here a lot fot sure

@RezaDorrani 11 месяцев назад

Thanks and welcome

@90daner Год назад

you save my life sir!

@RezaDorrani Год назад

Wow! Happy to have helped

@vaibhavwarkar9629 Год назад

Great Video sir thanks

@RezaDorrani Год назад

Welcome

@zanguinetti8612 Год назад

genius! thanks a lot, greetings from Peru!

@RezaDorrani Год назад

You're most welcome! ❤️ Peru

@zanguinetti8612 Год назад

@@RezaDorrani Thanks, please, Would you mind giving me a clarification? I was trying to get the information from a dropdown with Status: {Value."field_name".Selected.Value} but appear the next message: The argument type 'crf47_usuario' doesn´t match with the expected type 'OptionSetValue'. Type found 'Record'. Please, help me.

@RezaDorrani Год назад

@@zanguinetti8612 I will recommend posting your issue with screenshots on forums at powerusers.microsoft.com/

@zanguinetti8612 Год назад

great information, Reza, it not only is going to help me with this question but another questions in the future.

@abbasthegreat5 Год назад

Thank you Sir.

@RezaDorrani Год назад

Most welcome

@DroneEyes Год назад

great video Reza

@RezaDorrani Год назад

Thanks

@zerokhan858 2 месяца назад

thank you so much

@RezaDorrani 2 месяца назад

You're welcome!

@baldeepsinghnagi8943 4 месяца назад

Hello Reza, I saw your video named "How to use Patch function in Power apps" and there you mentioned that if we want to do Bulk update then we need to use Updateif and Patch function and i was trying to accomplish the same in my Power apps. I created a Simple sharepoint list named "Test" and it consist of 4 columns, Title, Requestor (Person type), Approval Status (Choice), Description (Multi line text) and i added some of the records. Now i created a Power app and added a Gallery control that display the records from the SharePoint list and then added a Checkbox control to the Gallery for each record. For the Checkbox control I defined some of the properties: OnCheck: Collect(varstatus,ThisItem) OnUncheck: Remove(varstatus,ThisItem) Default: ThisItem in varstatus Then i added a Combobox control and for the Datasource property i set it to Choices('Test List'.'Approval Status') I also added a Button control and for the button control OnSelect property i set it to: UpdateIf(varstatus,true,{'Approval Status':{Value:ComboBox1.Selected.Value}}); Patch('Test List',varstatus); Clear(varstatus) Now when i am playing the app and selecting two records from the gallery and selecting a Approval status from Combobox control and pressing the Button i am getting the error. What am i doing wrong and why it shows me that Network error when using Patch function: the specified column is read-only and can't be modified

@RezaDorrani 4 месяца назад

I have not come across this issue and hence not sure what the cause could be. I recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

@warimontadanukulwattana9343 Год назад

Thanks!!

@RezaDorrani Год назад

Welcome!

@edgarleonj 10 месяцев назад

Excelent Video thanks a lot.

@RezaDorrani 10 месяцев назад

Glad you enjoyed it!

@znemzzz Год назад

haha i was looking into patching stuff lately and how to improve my calls..then you posted a vid..nice

@RezaDorrani Год назад

Hope you enjoyed it!

@sundrapillay6668 Год назад

Thanks Reza

@RezaDorrani Год назад

👍

@basehumax Год назад

Thanks useful content

@RezaDorrani Год назад

👍

@kusumamuralik625 Год назад

Tq so much sir

@RezaDorrani Год назад

Welcome

@ankushjain4128 Год назад

I like your way how to describe..never missed any video eventhrough it is beginner level .. there must be something new that i haven't heard. Can you make a vedio ForAll concept with patch statement. Eagerly waiting for that. Thanks in advance

@RezaDorrani Год назад

Im not a fan of forall and patch. I use collections and bulk update. I have done multiple videos on it.

@AMindGame Год назад

Absolutely love your content, can you please make a guide about document management with library and list!?

@RezaDorrani Год назад

I make videos when I get multiple requests on a particular topic. Every quarter I ask subscribers for topic suggestions on the Community Tab of my RU-vid channel. Subscribers vote for topics and the highest voted topics get added to my backlog. Make sure you post this in the next topic suggestion post. If it gets a lot of votes, I will add it to my backlog.

@mrarbaz8767 Год назад

Thanks sir👍

@RezaDorrani Год назад

👍

@sultanSurya 6 месяцев назад

Thanks for the video. It solved my business problem.

@RezaDorrani 6 месяцев назад

Most welcome

@omidmehdi 6 месяцев назад

that was an epic video

@RezaDorrani 6 месяцев назад

Thanks

@krzysztofbuczek5594 Год назад

You are awsome!!!!!!!!!!!

@RezaDorrani Год назад

Thank You

@jamief3592 4 месяца назад

You’re my boy, Reza

@RezaDorrani 4 месяца назад

Thanks

@nazuu Год назад

Thanks again. I was so stupid using default(data source) when updating a record.

@RezaDorrani Год назад

Everyone is learning! Keep going.

@nazuu Год назад

@@RezaDorrani yes ! :)

@Liam-fb4tu Год назад

Hi Reza, excellent video as always and by far the best patch walkthrough on youtube. If you create a manual form and then patch the results is there a way to then clear the manual form like you would with the form control element itself by using the built in form reset function?

@RezaDorrani Год назад

You can set all the controls reset property to a boolean variable. Then when you want to reset the controls, set(varReset,false);Set(varReset,true); and you should be good to go.

@marieraymond6512 Год назад

@RezaDorrani a great video

@jakeerhussain1011 Год назад

Hi Reza, You are giving us awesome content. could show us how you implemented the count of each record based on Status selected and the Navigation to that particular items.

@RezaDorrani Год назад

I do not have a video reference on this scenario and would have to try it out to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

@monica24k 2 месяца назад

Another great video! I’ve watched a bunch of your videos and I’m still trying to find a particular example that I haven’t found yet. Do you have a video where you explain how to select multiple people and then send them to a SharePoint list in a form, and then also the option to update that entry in a form. I’ve seen examples where there’s just a single person, but I suspect that I need to use a collection for entering multiple people in a single line in a SharePoint list.

@RezaDorrani 2 месяца назад

Most welcome! I do not have a video reference for that. Concept would be to use collections.

@rthoughts7232 Год назад

@rezza If possible, Please make videos on Model driven apps use cases too, there are very less content on this topic.

@RezaDorrani Год назад

Not in my immediate plans.

@Learnpowerplatform Год назад

Thanks Reza for this amazing video to clear most of the doubts. Just one query that can we use patch function to create or update almost 20 to 25 new records in SharePoint list?

@RezaDorrani Год назад

Possible. I have done multiple videos on bulk updating data. Look for these videos in my Power Apps playlist.

@tigere3528 Год назад

Reza - great content. I'm trying to figure out how to set the varIdea variable when I'm using SharePoint integration. I'm trying to patch SharePoint choice field using another list, but submit form is not saving to list

@RezaDorrani Год назад

I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

@lalujithu 11 месяцев назад

Thank you for the video. Bit confused about how we can validate existing record entries in the SharePoint list before we patch the user records. To avoid entry duplication.

@RezaDorrani 11 месяцев назад

There is no inbuilt feature for duplicate detection.

@paolovr1970 Год назад

Thanks Reza, the last submit patch from multiple form I don't understand if any form is connected to the same table or different table. Can I use one patch for multiple form connected to multiple tables?; thanks.

@RezaDorrani Год назад

It must be connected to the same list.

@sharepoint1231 Год назад

Very nice video, thank you! One question, I tried submission with patch function, submitted a blank value to a required field, somehow, the system ignores it, not return any error and let me submit the blank value to the list. Any other setting is needed to stop the submitting? Thanks!

@RezaDorrani Год назад

Not sure about this since I have not come across this issue. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

@kennashriner6993 Год назад

Hi Reza, your videos are always so helpful! I am currently building a PowerApp with multiple galleries and forms with its data source as a SharePoint list, and have run into a problem when trying to submit the data using a patch function. I've been using the form1.updates, form2.updates, etc. functionality, but whenever a user tries submitting responses on other forms, a new list item is created. Is there a way to save the unfinished forms and then come back later, ultimately submitting the completed forms, without creating a new list entry in my sharepoint list? In other words, I was hoping to implement a save button that spans across four forms and three galleries. The user needs to be able to return to the app after having 'saved' the once submitted/unfinished data to a single sharepoint list item, and then submit their remaining responses using the forms - with their responses falling into the same list item. Thank you!

@RezaDorrani Год назад

I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

@kumnegerholdings Год назад

Thank you Reza, learning a lot from you. Do you have the suggestion box app created already? Cant seem to find it

@RezaDorrani Год назад

It is a template app in power apps. learn.microsoft.com/en-us/power-apps/maker/canvas-apps/open-and-run-a-sample-app

@kumnegerholdings Год назад

@@RezaDorrani Thank you for pointing me to it. Appreciate you!

@marie-franceenglish4397 Год назад

Hi Reza, thanks for all your videos! I've learned a lot. For some reason, I am running into a problem when patching back the collection to the sharepoint list. Since the patch function expects 3 arguments and we are only providing Patch(source, collection). It works, but when I close the apps and re-open, there is an error: Invalid argument type (Table). Expecting a Record value instead. If I rename the collection everywhere, then the apps works fine...until I close the app again and rename the collection again. Why is this happening? Thanks

@RezaDorrani Год назад

I will have to look at your App in action to know why. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

@user-kb9pk8bh7j Год назад

Hello Reza, thanks for this awesome video! I've learned a lot and hope to see more videos from you in the future! I have a very specific question and I hope I can get some insight and help from you if possible! Our company has a manual-entry form that was made in Power Apps , and recently we wanted to optimize it and track the time for how long a specific task is completed in. Our app consists of multiple buttons , so I tried putting some patch function into our button that enables a user to enter a new form( its a button that puts out an empty form and also starts a timer on the screen), but I cant get the data from the form itself ( so the data the user needs to fill in) , I just get a new blank record in my sharepoint list with a start time and when I press submit, with the end time and the time spent as the difference between the two. My main goal is to collect the data in the form ,as well as get the time difference between the start and the end time of the task into the sharepoint list (calculating the time spend). Is there a possible and an easy fix for this kind of problem? Looking forward to more videos like this!

@RezaDorrani Год назад

Thanks so much. I do not have any specific video references on your scenario and not sure what the reason for your issue could be. I would recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

@MaehAsmr Год назад

Your video is very helpful, it helped me a lot. I have a problem in btnexit, when you use patch, it gives me an error in all that part, since (updateif) recognizes it as a record and not as a row, any advice?

@RezaDorrani Год назад

I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

@zanguinetti8612 Год назад

Hello, Reza, I hope you are very well!! Please, would you recommend me a video to understand how to make visible and invisible some buttons depending of the user (admin and a common user)?

@RezaDorrani Год назад

Check ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-J-hMMXrKMVE.html and ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-fbDQH0vIsN8.html Best to check my playlists

@rothsimon6570 6 месяцев назад

Hi reza, great video , but how do you use drop-down as a selection for the existing column to update from text box inputs . ? to pull and send data same time . ?

@RezaDorrani 6 месяцев назад

I dont have a video reference on that scene so not sure

@gkakun Год назад

great video. Thanks Raza. Any chance you can upload step by step video of how you built this app? its a great idea!

@RezaDorrani Год назад

@gkakun Год назад

@@RezaDorrani Thanks for the detailed answer. I will follow-up on this.

@pedrooaquim736 Год назад

Reza I'm watching all of your vídeos. The information are unique ! One questions. When I see your gallery, I observed that the gallery is filtered by "status" ( on minute 18:49 it' shows only the "NEW") . Could you share how did you do that ?

@RezaDorrani Год назад

By using filter function. Filter(datasource, columnname.Value = “New”) Assuming column is a choice column. I have done plenty of videos on gallery filter. I will recommend checking them out.

@asbjoern_nielsen Год назад

Hi Reza and thanks for another great video! If you have the time and energy for it... here's a couple of questions related to the video: 1. On the Bulk update; how can I include the Approval log, date and approver? 2. I want to add a checkbox outside the gallery to "select all"... what's the code for this? Br, Asbjørn Nielsen

@RezaDorrani Год назад

1 - Do not remember much of this video but if its a collection performing bulk update. You would need to include the details in that collection. Simply update collection with those details. 2 - I have done a few videos where I have shown the code for select all. You would need to check those (I do not specifically remember which one)

@user-fe9rh1bc6u 8 месяцев назад

Hi Reza, Thanks for the great video, my app goes through multiple approval stages, I have created the approval history column to contain emails of every user who edited it, but the patch function is only keeping the last email, how can I make it show all emails and not replace the existing user emails with last email only?

@RezaDorrani 8 месяцев назад

Append the data. Get last value and concatenate with current value and then patch.

@tgamradt Год назад

Great video, as always. But I was wondering why you initialized varIdea with Blank() instead of Defaults(Ideas). Wouldn't that eliminate the need for your if statement when patching?

@RezaDorrani Год назад

Honestly I do not recollect why I had done that :)

@AndrewTSq Год назад

@@RezaDorrani I thought the Blank() was to remove the selection of the gallery, cause if you use Defaults(Ideas) then varIdea has a value? and then the coalescing would not work.. but I am no expert so I could be wrong :)

@RezaDorrani Год назад

@@AndrewTSq Honestly, I would have to revisit the video to refresh my memory. Your outline sounds right.

@PinguinPat Год назад

Thanks for your clear explanation! Although I'm still struggling with the patch of a ComboBox: I'm having a work around. But how do I get this in a ComboBox patch line? ComboBox1 > Items Fx = Choices(Locaties.Afdeling) Labels1 > Text Fx = ComboBox1.Selected.Value Buton1 = OnSelect Fx = Patch(Locaties, {Name: Label1.Text}) Thank you!!

@PinguinPat Год назад

Life doesn't always have to be difficult! :) Solution: ComboBox2 = Items Fx = Choices(Locaties.Afdeling) Button2 = OnSelect Fx = Patch(Locaties, {Name: ComboBox2.Selected.Value}) Thanks again for your excellent video's!!

@RezaDorrani Год назад

Looks like you got it worked based on your response comment

@PinguinPat Год назад

@@RezaDorrani Respect for all your hard work and follow up on RU-vid!! It's not certainly not common for people with the knowledge that you have to do so!!

@florenceting9824 9 месяцев назад

may i know if I have many information to be patch and submit into my database, may i collect them in a collection first and replace the last part of patch function by the collection name?

@RezaDorrani 9 месяцев назад

Check my video on bulk updating data. I have covered this scenario.

@VikingArhold Год назад

Hi, thank you so much for this tutorial. I’m trying to get this thing to work in an issue log app. I’m using the gallery selector to search for only Open Status issues for the current user. I’m using With({userEmail: User.Email},Sort(Filter(IssueLog,Status.Value=“Open”,’Created By’.Email=userEmail),Modified,Descending)) as an item filter. For some reason it breaks the default property of the status dropdown. Please help!

@RezaDorrani Год назад

I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

@utilisemedia Год назад

Hi Reza, How would you change the color of the hard coded text "Approval Status Updated" (21:54)? Thank you

@RezaDorrani Год назад

I believe that is an html control where value is displayed. You can write simple html code and change color attribute based on the value. I do not have a specific video reference for it though.

@josbar80 Год назад

Great Video Reza. I have followed the video, but in my case I am using a Combobox. I am facing an issue, where I would like to auto populate a Text Input with the Values from a Combobox. I can achieve my result separately, but how can I achieve this based on the selection of the source in the Combobox? Any ideas?

@RezaDorrani Год назад

I will have to look at your App in action to provide guidance & know more about your use case. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

@jeanlouisterranova2042 Год назад

Hi Reza, can I use the patch function in bulk when the number of records to be updated is higher than 5000 ?

@RezaDorrani Год назад

Not sure I would want a user updating data in those high numbers from an App. Performance would be a big concern.

@juancarlosvallecillo4533 3 месяца назад

I noticed that the combo box doesnt work with this technique with the Global Variable in "Default", but works well with dropdown list as Reza is doing. Just in case someone is using combo box for their patch.

@RezaDorrani 3 месяца назад

Thanks for sharing

@mrugeshpatel841 Год назад

Hi, Thank you for detail video. I had issue where more than one user can try to save data at same time but only one user's data is saved in my SQL table. Will you please help to solve this?

@RezaDorrani Год назад

I do not have any video references on this and none with sql. I will recommend posting your issue with screenshots on the forums at powerusers.microsoft.com

@kastenivkimbo5347 11 месяцев назад

Hey , if we have two sql tables as data source for powerapss, would that be an issue?

@RezaDorrani 11 месяцев назад

@kwamebuanyinaohemeng919 Год назад

This is a great video. Thanks. I there a way to patch multiple emails in the person column on share point list?

@RezaDorrani Год назад

Patch emails? I dont think there is any such option. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.

@kwamebuanyinaohemeng919 Год назад

@@RezaDorrani I appreciate the quick response. Thank you. I will check the forum but perhaps I didn't put my question correctly. Looking at how you patched one person to the "Person" column type in share point, I was asking if we can patch multiple persons in the "person" type column on share point using the patch function. Or more specifically, patch an array of multiple approvers from power app to a share point list person type column.

@RezaDorrani Год назад

@@kwamebuanyinaohemeng919 For that you would need to pass a Table of those values similar to multi select columns of type choice or lookup. Video description has link to my blog which shows an example of multi select lookups and choice. Similar pattern is needed for Person. I do not have a specific video reference on it though.

@kwamebuanyinaohemeng919 Год назад

@@RezaDorrani Sounds good. Thank you for the response.

@bobbyw1074 10 месяцев назад

Hi Reza thank you for this video! Would you be able to create a list of column syntax for dataverse?

@RezaDorrani 10 месяцев назад

I did not understand your question

@bobbyw1074 10 месяцев назад

@@RezaDorrani You have the list of syntax for referencing complex columns in sharepoint, do you have syntax for referencing complex columns in dataverse?

@RezaDorrani 10 месяцев назад

@@bobbyw1074 I have a playlist on dataverse. I may have covered Patch in one of the videos.

@bobbyw1074 10 месяцев назад

@@RezaDorrani oh great. I’ll look for that video. Thank you!! I love your videos!

@sistex3729 4 месяца назад

This is a great video. I'm not sure why but my Patch on my Submit button is not working. I receive an network error when using the Patch function: The requested operation is invalid. This is my third attempt at creating multiple forms to submit a new item to a SharePoint list. My Patch syntax is Patch('Change Request',Defaults('Change Request'), BasicForm.Updates, DetailsForm.Updates, CMForm.Updates) If I'm using the form.updates, do I need to add all the fields between { }?

@RezaDorrani 4 месяца назад

I have not come across this issue and hence not sure what is the cause for your issue. I recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

@ItsMeProday83 Год назад

On 11:30 aldough I pressed +, Status doesn't go back to NEW (it stays on last choice from gallery that was selected). I did excatly the same, and all works except this one. Regardless on this, thanks once again for great and usefull video Raza.

@RezaDorrani Год назад

Thanks for liking the video. As for your issue, I will have to look at your App in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com

@belandry1 11 месяцев назад

Reza, thank you as always for your great videos and insight! I'm attempting to use ForAll to patch a variable and a field from a collection to two SQL columns "savings_request_id", and "basin_id", any thoughts on how i need to change my formula for this to work? ForAll(collPABasinSupplier, Patch(savings_request_basin_xref, Defaults(savings_request_basin_xref), {savings_request_id:varSavingsRequestID, basin_id:BasinID})). It just tells me it's invalid. Thanks again! Beau

@RezaDorrani 11 месяцев назад

I do not have a video reference on sql scenario and would have to try it out to provide guidance. I recommend checking or posting your query on the forums at powerusers.microsoft.com/ in case someone has done something similar.

@belandry1 11 месяцев назад

@@RezaDorrani not a problem, thanks for your reply!

@tibobago 2 месяца назад

Hi @RezaDorrani, following the steps outlined in that video but using a dataverse for teams table as source. When I attempt to set the default value of my dropdown it doesn't accept my varName.FieldName.Value. When I look at the variable preview from my formula bar it displays " This data type is unsupported for Ev...", can't see the end of the message but I suspect my issue might come from using the modern dropdown, unfortunately the classic doesn't seem available. Appreciate your help if you know the answer. I'll keep trying and post workaround if I find one here!

@RezaDorrani 2 месяца назад

I have not tried this with Dataverse for team hence not sure. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

@hardridged 9 месяцев назад

Hey Reza, incredible video! Is it possible to "write" in new data in a combo box and patch that new data to your data source (Dataverse in my instance - CB is connected to a lookup column)

@RezaDorrani 9 месяцев назад

Not out of the box. It would need some form of custom logic to check if value entered exists and if not then patch it to related table. Not something I have attempted.

@hardridged 9 месяцев назад

@@RezaDorraniahhh, maybe i'll go another route, lol. Appreciate the quick response and very informative video though!

@srijabandyopadhyay6556 Год назад

Hi Reza, any dedicated video for variables in power apps?

@RezaDorrani Год назад

I have used variables in plenty of my videos but do not have a dedicated video on variables

@toanuk Год назад

It is a clear idea, Raza. I would like to ask you for help. How do you Use a Patch Function a Photo (Camera)from Power App To Sharepoint List(Image), Instance Ideas sharepoint list add a column Image? Look forward to showing me Thanks Toan

@RezaDorrani Год назад

Image column is read only as of today (from Power Apps)

@erin6094 Год назад

Thanks Reza. How can I using Petch update attachments?

@RezaDorrani Год назад

Patch does not support attachments

@utilisemedia Год назад

Thanks Reza, How can we build on the iferrors function to be able to show a success message? Thanks

@RezaDorrani Год назад

IfError(function;success message,failure message)

@utilisemedia Год назад

@@RezaDorrani is it in one of your videos?

@RezaDorrani Год назад

@@utilisemedia No

@utilisemedia Год назад

Hi Reza, on a plain add record, how do you clear the text fields after successful add? thanks

@RezaDorrani Год назад

Why not add it with text field data empty?

@AndrewTSq Год назад

I had the same problem, but I solved it by using the reset-parameter of the textfield. If I remember it correctly I set a variable called "resetText" in the reset-parameter, and then on successfull, I set the resetText to true. And the page "On visible", I set the resetText back to false.