You are a mind reader. The app that I just made… I had a request where if we can do bulk updates and now you have come up with this. I think your copilot is doing a lot of mind reading. Respect @Reza
Hi Reza..I am blown away by the simplicity of your approach to something that took me months scrubbing the internet to get a hang of. I greatly appreciate this video and also commend you for dedicating your time and effort to do this.. Thank you so much..
Forgive me for what I'm about to say but I love you, you really solved a question a was trying to find the answer for a long while, normally your videos sound kind of complex for me but This time I got everything from the beginning till the end, thanks so much you are a master!!!
Hi @RezaDorrani, First of all, forgive me for making this comment. I follow you regularly and I love your videos but there is something I would like to correct, with the code you have put in the Update. The most optimal way would be with this code: Patch( 'Issue Tracking List', ShowColumns( colData, "ID", "Status", "Priority" ) ); because the way you are doing it, it is updating all the columns in the list and the most effective way is to update only the two columns you are updating.
Thats a great point and Im very happy to see it being made. In another video I did show showcolumns while Patching and a lot of viewers got confused (using different data sources + importance of having primary key in there) Hence to make it simple, I decided not to do that here 😉
Hi! This works like a gem! But im worried, will this work on large dataset without hidden issues? Like how the patch function knows what record to update? Because of the “ID” column? Thanks!
Hi Reza Dorrani, Everyday at work I am so grateful for your videos to be able to learn a lot of Microsoft Power Platform concepts with so much ease. You are the best! Have a great day!
Love this video Reza. Wil this work if my gallery is using a Startswith filter for the items property? It's a large data set, so we use drop downs to filter it to return all the data from 2000+. Will the update still work?
Do you want user bulk updating 2000+ records in one go? It will work but user will have to scroll in gallery so gallery loads all that data assuming the query is delegable.
YES, I am about to launch a power app in our production facility and needed THIS special functionality, Thanks!! Is there a way to check all items that has a special value in a Column? For example, select all items that have "January" in the "Month" Column?
Just in time great video 👍👍, the only issue I'm having with this method is when I change the same drop-down twice it gives a network patch error this is because my collect is set on the drop-down Onchange property is there a workaround?
It depends on how you have configured it. I have not come across the mentioned 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
I saw your video once again and I was wondering why you did not user for all patch? Is there any situation where udpateif is more convenient than forall patch? Thanks again man, you are a lifesaver!
Hi Reza! thanks for the great videos. Do you have a video for patching nested galleries with check boxes in each item to patch selected items? For instance say I have a parent gallery that Items are 1, 2, 3, 4, ... and each Item has its own items that I have created using group by function. I want to patch all the selected items and repeat parent gallery items in the first column for all the selected items in the child gallery. Thank you!
Great Video Reza! very useful. I am looking to complish similar one using Comb box multiselect and trying to update the values at backend(dataverse). The columns I am trying to update are lookup columns. If you have done similar work around this requirement can you share the link to your video. Thank you so much.
Thanks! I dont think I have a specific video reference on this. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi, did you have any success patching lookup column data? I put the lookupcolumn values into a collection and then tried using showcolumns in the patch to specify those, it doesn't like non record values though.
Hello @RezaDorrani! I used your method here and it works perfectly fine. But, when I checked the select all check box on a filtered gallery, it still selects all items. For example, I have 30 total items in the gallery and when I filtered it, gallery will show 15 items. When I ticked the select all check box on a filtered gallery, it will still select all 30 items. Is there a work around on this? Thank you for making this content as it really helps the beginners like me in creating apps. 😊
Thank you so much, for this, Reza! So just to confirm: If I have a filter on my gallery ITEMS, and I click "Select all," it will select only those gallery items that are filtered, is that correct?
Yes, as long as check all has the same filter condition when collecting data in collection. Note collection max limit* is max delegation limit which is 2000
Hi Reza, First of all I would like to thank you for the quality content you are providing..in this video I have a question at 6:37 while selecting all items..I have a gallery with filter I only want to select all items after filtering which in my case I don’t know how to do..is it even possible ..as in your video it is selecting all the available items from gallery…please help in this topic.
You're most welcome! If gallery is being filtered, then we adding all items to collection, you should be applying that same filter logic. Possible - Yes. Something I have tried - No
You are simply a magician! thank you for the great guide. I was wondering if is possible to have a dropdown for each item in a gallery with different values and be able to patch the different values from that dropdown for each item respectively. I tried it with a ForAll since my gallery would get just a few cases at once each time but it doesnt work, it patches the same value as the selected item on the gallery for all the items no matter what. I thought maybe I could clearcollect at each ForAll iteration but that is also not possible. Anyway, thanks again for the video.
I like your videos about power apps , in relation with this one I have a question , how to approach the scenario when from those two columns I want to update only one , let's say status and priority to leave as it is already for each individual record?
Hi @reza first of all thank you so much for providing videos on exact requirements I used this video to and applied same functionality to my canvas power app it worked for few days and now all of a sudden i am starting getting error-Network error when using patch function: conflict exist with changes on server, please reload. Requesting you to help me overcome this issue
@@RezaDorranithanks for your swift response I even posted this on community but couldn’t find a solution described as easy as you shown.. now I am in a tough situation ..by your expertise what could be a possible reason for this error…by the way I am using dataverse table as my data source
Thanks so much for your tutorials, Reza! I am applying the Patch function described at the 14:45 minute mark to a SharePoint List. However, I am applying it to a gallery populated by a GroupBy variable. It would seem that items cannot be updated within a GroupBy context. So, I must use ClearCollect to take the selected items and place them in another table..? Does that sound correct? Thanks so much for you time!
Welcome! Group By has a different schema for gallery. I don’t have a specific video on this so not sure what the code would look like. I recommend posting your query on forums in case someone has experienced something similar powerusers.microsoft.com
Thanks for your reply! @@RezaDorrani Yes, there is a post on the forum similar to my issue, but I am having trouble formatting. I may just create a new post. Interestingly, my app will allow the Patch formula as it is described in the video to make a SharePoint List update, but only once. After that submission an error message is produced.
Hello, Your this video is help full. I have question if I don't used check box but I used some colunm that duplicate word example your colunm is "Prioirty" when I update data that I selected row "High" want to change colunm "Status" to be "open" all row "High" in the gallery May you advice? How to do that? Thank you.
@@RezaDorrani thank you for recomment and I saw video on bulk update but not my intension , I mean I have data for example delivery data have Part Number , PO the part number is same but the PO is difference (1 Part number have average 5 PO in data table) and I need to inspection part 1 part number when I record data 1 part number the result record pass all 5 PO without checking box. ---> example 1 day I have around 100 Part Number 500 PO My data base in Excel table. For this video I try to follow your method but I have struck update button that show error "colunm in the data source you're updating expect a 'text' type and you're using a 'Record' type Sorry to bother you. I have a new creator please give me more advice. Thank you
@@pisitboonsong I would have to try it out to know the options. The videos are the best references I have. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
Hi Reza, I searched in all your videos and also checked PowerApps Platform community, There is not proper video on Combobox with multiselect functionality connected to SharePoint Choice column inside the Gallery. to retrieve it's stored values in the Gallery etc. Plssss make one, Plss because your videos are so simple to follow. It will help many! Thanks a ton! If you already made, pls send here, I couldn't find.
I have not made one on that scenario. I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
Hi, this was really helpful. Do you have a video available showing how to update People column when applying changes to multiple records? I want to show the requestor name/e-mail next to each record.
@@RezaDorrani Hello Reza, thank you for responding. Is this something you might be interested in creating a video on, or have a workaround you could propose?
@@komalahmeds6740 I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
Hi Sir..Thank you for the video i found it more interesting so that i can use it in my work…I have one question as i am building a car booking application where users select the date and time using date time picker Power apps has to list down the list of available cars on the specific mentioned time..I couldn’t achieve this any suggestions please
Reza, thank you a lot for your videos and contribution in the Microsoft forum! I would like to ask a question if you don't mind. When I released my app, I noticed there is no multiple photo selection through the attachment control. That means I can't select some photos once at time when upload them. The issue is only on Android and iOS platforms through the PowerApp mobile app. But, It works fine on the web browser for any platform. Researched and found nothing. Any solutions so far? Thank you
Hi Reza Thanks for this video... I used the Patch function as shared in this video and the App was working fine from last 2 weeks, but today i get the error "Network error when using the Patch function: The specified column is read-only and can't be modified." now I am unable to resolve this error. Could you provide a hint to resolve this ?
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
Hi Reza, thanks for uploading this video. My gallery has collection as datasource which I'm creating at onstart property as we've more than 2000 rows. Added the same code as yours in OnSelect property of my button, but the value is not getting updated in my sharepoint list. Could you please help?
I have not tried with collection logic. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
I literally just had to build this last week while developing an app. But I for some reason did it a little different using an IsSelected column in the separate collection instead of just adding & removing from it. But if I go back & better match this set up, I can link to this video & avoid doing documentation for that part of the app.
@@RezaDorrani Already got it set up. Better to gather around standardized methods so things seem more familiar to anyone going into our apps later. Thanks Reza
Just come back to this... Question. Can you do something similar with a combo box but using submit form? ie if you select 3 items from a combo box, you get 3 items added to your SharePoint list? 🤔
Video description has link to download entire solution (members only - check description for details) I would suggest giving that a try. As for the issue mentioned, I have not experienced it and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hi Reza, I implemented the solution you outlined in this video. I also used one of your techniques to copy items in bulk. I have one issue, though. Once the gallery refreshes its items, then I can't clear the collection, and the checkboxes are all checked. I can't figure out how to stop the loop as I quite like the concept of informing the user that a change requires saving and, therefore, triggering the patch on selection of the controls inside the gallery. Any suggestion?
Hi, @RezaDorrani! I'm at a very begginer level on 365. I wonder if I could use this same reasoning to execute some other actions, besides altering the list. Specifically, I want an email do be sent to each of the selected items. Can it be done in the same way or do I need to execute some loop using Automate?
Reza, have you considered making a video on how to select favorites in a gallery and then filter the gallery by favorites only (Sharepoint list)? This would be very helpful for my facilities directly app! Thank you for the consideration.
I have not. My rule for video requests is set - "I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out."
Thank you so much, I have faced a problem because my gallery uses filter dropdown. and when i change the value of the filter the checkboxes are reseting again. how to stop the checkboxes from reseting? thank you again
@@RezaDorrani Thank you, I figured out the problem, because the check boxes has no reference in my collection or list. so their values are not stored anywhere.
Hi Reza, do you do 1 to 1 consultation to build a site inspection mobile app. they will be around 100 questions and each qns will have a Yes, No field, a comments box and a camera upload.. thank you
Very helpful video, thanks very much! I wonder if you can make a video about patch function returns value especially returning table value. I use Dataverse table as data sources, in one situation that I want to copy from records from the same table. That means inserting new records with new unique identifier and few columns value changed from existing records. And I need each patch returned value (new record) that will be used to create new records for sub tables…
I do not have a video reference on this scenario and would have to try it out to provide guidance. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
Hi Reza, that would be great if you can make a video or guide for the scenario! It similar to your this video but add another complexity, instead of updating it is inserting or create new records. I don’t see it can be done with bulk patch? I have to use ForAll then Patch which is working fine. The difficulty things are that I need the returned records from Patch one by one…ex: I have two galleries GalleryFrom and GalleryTo their Items are same collection, the collection is ClearCollect from a Dataverse table. A ComboBox for dropdown (custom page) bind to one field of collection (categories) to control the GalleryFrom display list. User can choose items from GalleryFrom move to GalleryTo. I want to save GalleryTo items with a fixed Category (means GalleryTo bind only one known Category) without Sources Categories items change. Its copy from other Categories items to current Category. I remove/delete all records from Dataverse table for this Category Before I save/patch ForAll items in GalleryTo because user can move between the two galleries freely. I made it work at this point. I also need the created record inside loop to patch related tables/sub tables information (SubTasks or Stages). That’s what I need returned records of Patch function…
@@kellyliu4225 I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
@@RezaDorraniI’m sure this video if you make will have a big impact in the community. It is beyond basic and very little information about the topic out there. Thanks!
Do you have a video that will show how you can update, then have it send an individual email for each record that you updated? For instance, I have "Approved" as a status, once it is approved, an email goes to the next approver to review. Can I do that all on the same button? I tried using the patch but it will only send the email for the record that is selected and not the others.
I do not have a video reference on this scenario. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
When I try to Patch the Collection to my Dataverse table it says it cannot patch Read-Only columns such as "createdby". How can I get it to Patch each record then?
I have not come experienced this 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
Hi Reza, thank you for the video, can I ask what if this time I just want to update only status but not the priority? I tried to leave the priority as blank, but it will just patch it as blank.
@@RezaDorrani UpdateIf( colData, true, { TaskresultStatus: If( !IsBlank(ComboBox2_1.Selected), ComboBox2_1.Selected, ThisItem.TaskresultStatus ), 'Assigned to': If( !IsBlank(ComboBox2.Selected), ComboBox2.Selected, ThisItem.'Assigned to' ) } ); Patch(Ticket, colData); Clear(colData) is this formula wrong? it doesn't work for me... but I can't see what is incorrect....🥲
@@RezaDorrani sorry can I ask what is wrong with this formula below? UpdateIf( colData, true, { TaskresultStatus: If( !IsBlank(ComboBox2_1.Selected), ComboBox2_1.Selected.Value, colData.TaskresultStatus ), 'Assigned to': If( !IsBlank(ComboBox2.Selected), ComboBox2.Selected, colData.'Assigned to' ) } ); Patch(Ticket, colData); Clear(colData) I can't get it work, sorry I am new to power apps, so please pardon me if this question is too silly...
@@meng-shanwu4475 I cant guess the issue here on chat. I recommend posting your issue on forums (best place to post issues as there are many experts who assist) powerusers.microsoft.com
I did not get many requests on it. I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
Hi Reza, This was working fine for me till last few days the suddenly I am getting the error when I am patching "Network error when using Patch function The specified column is read only and can't be modified" :(
Dear Reza, When I try to use "Patch(SharePoint List Name, Collection name), i am getting error, but in your video it is working, why I am getting error, when try to patch all record from collection into SP list, the collection I created as clearcollect(SPList name, defaults(sp listname)). Please tell me what could be the reason.
Video description has link to download entire solution (members only - check description for details) I have not experienced the mentioned issue and hence not sure what the cause for it could be. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com
Hello Reza I am using a SQL view as my data source. So in the Patch function I would need to first map the primary key of my source table to the unique column of my view. So how can I modify the patch function to suit the view data source?
@@mauroquinteros8783 I dont plan to try it out. I would recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com/
Please make a video on this I have a job application form which is built by using patch Functions. In this I want to add Multiple Company experience (i.e. If anyone has 10 years' experience with 5 companies) with Role, Location, From date, To date, Organization Name and Job Type. This fields may add for 5 or 10 times also depends on consultants as Naukri or LinkedIn Portal. They select on(+) or add then the same repeating required details should be visible How can I make this??? As I have prepared other information in form.
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
@@RezaDorrani Hello again Reza. Will you make video where you make a gallery with a choice column with the PowerBI integration? I'm trying to select multiple rows and change their category, but it wont work. I just want to be able to change multiple rows and change their category on a status choice column. The code i have has no error, but it does not make and change and updates to the SharePoint list. Should i make a collection as a pre step? I dont know lol. Good videos as always. / Kenneth.
@@kennethgottfredsen767 I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post. Better to post your query on forums.
Hi Reza, I'm trying to create a multi select combo box in a gallery and patch those values (comma separated) back into sharepoint as text. Is this possible?
I dont have a video reference on this. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
I'm having issue here that when I create a variable it duplicates in all items of gallery. I saw in one of your posts that we should use collection instead of variable. Can you please help me with an example?
@@mizbhakhanum3974 debugging issues here on chat is not an option. Your best bet would be to post your issue on forums. There are various users who assist in their free time on forums.
Dataverse unique identifier is a guid type column not ID as in SharePoint. I don't think I have a specific video reference on it. I recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@@RezaDorrani I am having a similar issue. I wonder if it is a versioning update problem. It is because there are columns in the row of data that can not be modified; "filenamewithextension", "fullpath", etc. I was able to stop this by adding ".columnname" that I am modifying after the collection name in the patch formula. However, I am now creating new items every attempt, and can not get the original item to update.
@@TylerMeverden Might be related. I have no plans to investigate on this issue as Im working on next set of video ideas. If you dont find a solution, please post it here so others can benefit from it
@@RezaDorrani Okay, so I haven't fixed the issue but I did get some additional info. I have an app published using this technique and it still works. The app uses version 3.24041.27. The app versions that I have made updates to and have not published use 3.24042.28, and they are now erroring. I have tried restoring the previous version, but power apps then removes it as an option once I attempt to restore. So, I need to learn a little about version histories. For now, don't update your currently published apps and they may still work until a better resolution is found.
I do not have a video reference on that scenario. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
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
Not something I have tried or have a video reference for. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
In my gallery i have to click two times to check the checkbox. Why does this happen? The first click selects the item and second click checks the checkboz
@@RezaDorrani it happens on flexible height gallery with modern checkbox. It works with normal gallery and modern checkbox. Not sure what the reason is though