How to Select MULTIPLE Items in Power Apps Gallery & PATCH

[@sankhlayashraj]

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

[@RezaDorrani]

I spend hours deciding which video topic to select. There is some madness to it :)

[@piusokoh4267]

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..

[@RezaDorrani]

Thanks so much for your kind words. So happy to hear the feedback.

[@btoz6237]

Another great simple video by Reza the PowerApps Master lol .. thanks for making life easy Reza

[@RezaDorrani]

Glad you found it helpful!

[@turisabela]

Reza, your videos are always on spot!

[@RezaDorrani]

Thanks so much

[@edtt1760]

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!!!

[@RezaDorrani]

Thanks for all the ❤️

[@titoleto]

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.

[@martinsteiger7857]

That's exactly what I thought when I saw the PATCH call. But apart from that still a great video (I learnt again something new). Thank you, Reza. ❤

[@RezaDorrani]

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 😉

[@wallshider]

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!

[@RezaDorrani]

@@wallshider Yes, it knows because of ID column. If worried, best to test it out first.

[@pathimohanadurgasai7816]

Superb 🎉🎉🎉.. Worked perfectly for me. Thank you.

[@shankgurew2370]

The Best By far; what do we do without you ma men

[@RezaDorrani]

It goes both ways. My motivation is my audience.

[@nishitanathani1052]

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!

[@RezaDorrani]

I have not come across this issue hence not sure. Some folks did report it but later mentioned it worked fine on its own.

[@Test-yh6ke]

You are the best Reza! Learnt a lot from your videos. Thank you ❤

[@RezaDorrani]

Thanks so much

[@imran002ali]

Hi Reza, I am totally speechless, I ran out the words, this is just MARVELOUS!! Thank you!! 🌟🌟🌟🌟🌟

[@RezaDorrani]

Wow, thank you!

[@imran002ali]

@@RezaDorrani You are welcome!!

[@michaelcollett7284]

Very useful video. Thank you! This is amazing!

[@RezaDorrani]

You're very welcome!

[@pisitboonsong]

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]

I have done another video on bulk updates. I would recommend checking that one.

[@pisitboonsong]

@@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

[@RezaDorrani]

@@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

[@kiruthikas3275]

Thank you so much Reza. It is very very very helpful for me.

[@RezaDorrani]

You are most welcome

[@alvarolang]

Great video Reza. Congrats once more! 👏👏 Thanks for the lessons!

[@RezaDorrani]

Thank you!

[@danetto431]

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?

[@RezaDorrani]

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

[@kimwickens4367]

I'm having the same issue!

[@danetto431]

@@kimwickens4367 Tell me if you find a fix please

[@Bieglin_Switzerland]

Hi Reza. This video solved a lot of my "problems". Great work and thank you.

[@RezaDorrani]

You’re most welcome

[@TheKermit2110]

this is sooooooooooooooo good! Thanks Reza!

[@RezaDorrani]

Most welcome

[@j.wedmore7034]

This video is so helpful! How would you also have the "Reviewer" (People Picker Column) update to the current user when the submit button is selected?

[@RezaDorrani]

I have done several patch based videos. You can try checking those to see how person type columns are patched. Similar format would have to be set for this.

[@krishnankuppaswamy7553]

Learnt how to view the variable value. Thanks ❤

[@RezaDorrani]

You are welcome!

[@nico_ruge]

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?

[@jq1683]

Yes . Clearcollect(filter(data source,month field = January)) Just need to add a filter instead of clear collecting entire list

[@RezaDorrani]

Most welcome!

[@nico_ruge]

@@jq1683 thanks!

[@prabhakardhere5316]

Hi @Reza. Thanks for this video. But while adding check all check box updateif function is not updating collection values. Any reason.

[@RezaDorrani]

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

[@rarun0080]

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.

[@RezaDorrani]

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.

[@fredfarrell]

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.

[@rohansharma1828]

Reza was there a reason behind you choosing the classic checkbox over the modern one?

[@RezaDorrani]

Yes, to mix things up. Modern checkboz was in preview at time of making the video.

[@TylerMeverden]

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!

[@RezaDorrani]

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

[@TylerMeverden]

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.

[@RezaDorrani]

@@TylerMeverden Sounds weird. Something would surely not be right. Try put a new post.

[@scottthompson4513]

You are my hero...thank you.. I understand ALL of these programming ideas, but knowing where and how to do it within PA is my pain point

[@moeking5601]

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?

[@RezaDorrani]

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

[@Letstry17]

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.

[@RezaDorrani]

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

[@Letstry17]

@@RezaDorranithank you so much it’s working without any delegation warning..

[@aliasadi8058]

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!

[@RezaDorrani]

Welcome! I do not have a video on that scenario.

[@marceloescobar1921]

Smart solution ! thanks!

[@RezaDorrani]

You're welcome!

[@MyTravelFlashBack]

Thank you for this video❤. Waiting for a video on PAD new features.

[@RezaDorrani]

I have no plans for PAD videos as I do not work on that.

[@oluwatobiyusuf]

Very useful video. Thank you Reza

[@RezaDorrani]

Glad to hear that

[@danielferrari5764]

Thank you again for your knowledgment Reza! Could you please make a video teaching how to delete multiples selected items, i'm struggling with that for a while.

[@RezaDorrani]

kzbin.info/www/bejne/poHYg2CNrrVrjpIsi=Jk_0Bd7KcMLQGKFE

[@bernardoemerick5362]

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?

[@RezaDorrani]

Emails would be sent using a loop. You can do that directly from PApps.

[@sibasankar8587]

Thanks for the informative video

[@RezaDorrani]

Most welcome

[@eragonrank5303]

Hi Rezza, how do you make the Box on the right appear after checking the box in the gallery? I’m trying to make different checkboxes in a gallery affect the Visibility of different forms, but I can’t make that happen.

[@RezaDorrani]

Its been a while since I did this video and hence do not remember the specifics. The video is the best reference I have. I will recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com

[@AshishYadav-yr6xh]

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 ?

[@RezaDorrani]

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

[@meshmut]

Hello Buddy, got a solution on this? is so please share I'm as well stuck and will much appreciate @Ashish

[@ramitkishoresaha9437]

Updating 500 items were very fast. I did not expect that! ❤

[@RezaDorrani]

🚀

[@SmartLearningAI]

Can you show how to overcome the delegation limit beyond 2000? ie do batches of 2000 until end of file or something?@@RezaDorrani

[@john1537]

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?

[@RezaDorrani]

Remove that column from collection that you do not want to patch prior to making the patch call

[@john1537]

so will be a case of IF and isempty or isblank of the fields that you make available to determine which ones to patch @RezaDorrani ?

[@RezaDorrani]

@@john1537 yes

[@mojpage]

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?

[@RezaDorrani]

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.

[@zerocool200380]

Reza, Thank you for such a powerful tutorial.

[@sundararamanarikrishnan3672]

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.

[@RezaDorrani]

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

[@arwaalgabas8641]

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]

Not sure about it. I will recommend posting your issue on forums in case someone has experienced something similar powerusers.microsoft.com

[@arwaalgabas8641]

@@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.

[@ion669]

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.

[@RezaDorrani]

Thanks! Your scenario is more like a grid style of gallery. I have done 4-5 videos on that. Check playlist on grids on my channel.

[@ion669]

Thank you! I solved it watching the guide one about editable grid using modern controls.

[@noobaimgamer7376]

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. 😊

[@RezaDorrani]

As shown in video, it works on filtered items as well. Link to download sample app is available for channel members (check description for details)

[@noobaimgamer7376]

Thank you Reza, you are a legend 😊

[@АртемБатьков-м6ю]

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

[@RezaDorrani]

I don’t think there is any out of the box feature for that. It is a known limitation.

[@АртемБатьков-м6ю]

@@RezaDorrani oh, thank you

[@atehaa]

Thank Reza, another great content!

[@spen2431]

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? 🤔

[@RezaDorrani]

Probably possible but not something I have tried or plan to do so.

[@Sam-pi3fx]

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?

[@RezaDorrani]

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

[@cristinaR2]

Great content! Learned a lot from you :)

[@RezaDorrani]

Awesome, thank you!

[@edtt1760]

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!

[@RezaDorrani]

ForAll Patch is slower compared to Patch collection.

[@edtt1760]

@@RezaDorrani Thanks a lot Reza I really appreciate your guidance!

[@kamranpatel2998]

thanks raza for bringing awesome content very helpful

[@RezaDorrani]

My pleasure!

[@SmartLearningAI]

How about also doing some stuff for model-driven apps?

[@RezaDorrani]

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.

[@kennethgottfredsen767]

Hello. Can this work with the powerBI integration? I want to do this inside a powerBI report.

[@RezaDorrani]

Possible. Technique will be similar not same.

[@kennethgottfredsen767]

@@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.

[@RezaDorrani]

@@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.

[@kennethgottfredsen767]

@@RezaDorrani Ok i will keep that in mind. Do you now a forum where I can post my problem?

[@RezaDorrani]

@@kennethgottfredsen767 powerusers.microsoft.com

[@EMiller500]

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?

[@RezaDorrani]

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

[@simranbudhwani4887]

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?

[@RezaDorrani]

I have not tried with sql views, so not sure about the options.

[@mauroquinteros8783]

I tried but could not do it, any news? would help!

[@RezaDorrani]

@@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/

[@komalahmeds6740]

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]

I don’t remember doing one on this scenario

[@komalahmeds6740]

@@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?

[@RezaDorrani]

@@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.

[@zerocool200380]

Hi Reza, how we can bulk delete in the same app you showcase?

[@RezaDorrani]

Check function removeif

[@zerocool200380]

Hi Reza, if we want to copy items are we forced to use For All?

[@RezaDorrani]

I have done 3-4 videos on bulk updates including copying like feature.

[@meng-shanwu4475]

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]

Add if condition and check if value is left blank then don’t include that in the update record

[@meng-shanwu4475]

@@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....🥲

[@meng-shanwu4475]

@@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...

[@RezaDorrani]

@@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

[@Letstry17]

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

[@RezaDorrani]

Most welcome! I have not experienced the mentioned issue, hence not sure. I will recommend posting your issue on forums at powerusers.microsoft.com/

[@Letstry17]

@@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

[@RezaDorrani]

@@Letstry17 I would have to reproduce your issue to know what can be done. Forums will be your best bet.

[@zerocool200380]

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?

[@RezaDorrani]

I have not run into any issues with gallery refreshing so Im not sure how I can help.

[@ryannolarte1788]

how about multiple selection on a data table data source is excel to update one update?

[@RezaDorrani]

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

[@arunv1909]

as always- great video , thanks . Hoping for videos on Power automate too please in future

[@RezaDorrani]

74 videos and growing on Power Automate ➡️ kzbin.info/aero/PLTyFh-qDKAiEs0rhQuR7fwSv5_63FHr_0

[@arunv1909]

@@RezaDorrani New ones i meant , great content always though

[@RezaDorrani]

@@arunv1909 New ones are being added each month.

[@pjcruz7635]

Thanks! Veryhelpfull!!

[@RezaDorrani]

Most welcome

[@praveeng3921]

Always as Interesting video, Thank you for this.

[@RezaDorrani]

Glad you enjoyed it

[@ealexander2488]

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.

[@RezaDorrani]

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.

[@ealexander2488]

@@RezaDorrani I will, but just so you know, you are the best. Thank you!

[@tandoan6222]

I use auto number for ID each row in dataverse but sometimes my formula error it announce my column ID cannot change while i don’t change anything in this column . Could you give me advise ?

[@RezaDorrani]

You should not be including that column in collection when patching the collection

[@tandoan6222]

@@RezaDorrani thanks you for give me advise . I have a confuse about removeif if i don’t collect ID on collection, how i sure only 1 item i select it , because I have a double item when i select more than 1.

[@tandoan6222]

@@RezaDorranisometimes It’s normal don’t have error. When it error it announce “Net work error when using Patch funtion: Column “crbbd_ID” is read only and can’t be modified”

[@RezaDorrani]

@tandoan6222 I cannot guess the error reason without reproducing it. I will recommend posting your issue with screenshots on forums in case someone has experienced something similar community.powerplatform.com/

[@Jaraiya89]

patch not working with dataverse? says guid record doesnt match table. any videos or links or workarounds?

[@RezaDorrani]

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.

[@tylerkolota]

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]

Good luck!

[@tylerkolota]

@@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

[@vengkateshr7290]

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

[@RezaDorrani]

Depends on how schema of your data. Idea would be to filter data. I have done many videos on filtering that you can check.

[@aysanhaghani5271]

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" :(

[@RezaDorrani]

Check recent comments on video. Its some issue with latest version of power app that I am unaware of.

[@JohnstonWang]

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

[@RezaDorrani]

I do not provide 1:1 consultation

[@jaredt.4048]

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.

[@RezaDorrani]

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."

[@DSEC_PSAIKIRAN]

how to save the coldata into a seperate sharepoint list when clicked with a button after selecting all the checkboxes

[@RezaDorrani]

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

[@DonD-h3d]

Hi Reza, do you know why I would be getting a network error that the column is read-only when it worked initially?

[@RezaDorrani]

No clue about that

[@TylerMeverden]

@@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.

[@RezaDorrani]

@@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

[@SantosChimal-r5m]

@@RezaDorrani Same error, this is not working

[@TylerMeverden]

@@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.

[@swathimgb7295]

I have created gallery with checkbox and i want to add a new row to gallery. How can i do this.

[@RezaDorrani]

Please check my playlist on grids

[@ShwethaPM-r1k]

Hi Raza When using Updateif() im getting error in patch() i., e update function : the specified column is ready-only and cant be modified "

[@RezaDorrani]

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

[@meshmut]

Hello Buddy, got a solution on this? is so please share I'm as well stuck will appreciate @user-y

[@NatashaGondiProfessional]

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.

[@RezaDorrani]

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.

[@mizbhakhanum3974]

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?

[@RezaDorrani]

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

[@mizbhakhanum3974]

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?

[@RezaDorrani]

@@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.

[@joywindsouza817]

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]

I’ve not experienced this so not sure

[@joywindsouza817]

@@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

[@RezaDorrani]

@@joywindsouza817 I have not tried with flexible height gallery so not sure

[@kellyliu4225]

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…

[@RezaDorrani]

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.

[@kellyliu4225]

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…

[@RezaDorrani]

@@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.

[@kellyliu4225]

@@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!

[@RezaDorrani]

@@kellyliu4225 I know but my rule for making videos is set. Best to post this idea and let the community decide by votes.

[@adityadeshmukh3150]

It's just awesome!! ❤🎉

[@aravindricky2706]

Speechless ❤

[@ZeyaulHoda]

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.

[@RezaDorrani]

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.

[@grungewess]

it would be great to use items from on list to patch another in one go like this

[@RezaDorrani]

Possible

[@swathimgb7295]

How to add a new row to gallery

[@RezaDorrani]

I will recommend watching my playlist on grid controls

[@swathimgb7295]

@@RezaDorrani Thank you

[@SafdarAli-qx2sm]

Bravo

[@RezaDorrani]

Thanks

[@gabrielako3164]

Awesome! 👏👏👏👏. I was just searching for this exact tutorial earlier today. Thank you Reza

[@RezaDorrani]

Great!

[@quachkhoaduy7565]

Tks

[@RezaDorrani]

Wc

[@SantosChimal-r5m]

I love you reza 😂

[@RezaDorrani]

Thanks

[@petsworld000]

❤

[@silumkomagwa389]

@RezaDorrani always showing us the SMART & CLEAN way to code. HIGH LEVEL, Thank you🤌

[@RezaDorrani]

I try my level best and so happy to hear the feedback.

[@silumkomagwa389]

@@RezaDorrani 5 years from now when Power Platform is older lol you will be the reason for its growth and stability in the market.