Select multiple records in a gallery and Patch with the PowerApps ForAll function 

Shane. Just wanted to say a big thanks for this video. Your start small and build approach is, as you say awesome. It helps the grey cells absorbed better. As a senior learning PowerApp, it takes just that bit longer for things to sink in, however, your approach is doing the trick. This was just what I needed. Great work.

Just starting to learn Power Apps, and after finding this channel, Shane has become my new mancrush :D Found a lot of valuable help in these videos.

I google a PowerApps issue/question, 9/10 times one of your videos comes up. You've been a huge help. Thank you Shane for making this content free for all. MVP

Hi Shane, I got started with PowerApps by watching your videos. Thank you so much. This one was hard for me but not only was I able to get all of your steps to work, I was able to do a project using these concepts with a twist. You rock! Appreciate everything you do!

Thank you so much for the videos! Not only have I learned so much about PowerApps but you also are entertaining to watch. Getting patch to work with collections has been my biggest challenge. I still can't quite get it to work but I am not giving up.

This video is like a symphony - it starts slow, builds up and culminates into a crescendo. Wow!

Your videos have enabled me to up our powerapps development to a completely different level - Thank you for your efforts !!

Great video. I did a lot of research to try and figure out a way to do this, and for the life of me, I couldn't find a full answer. This gave me exactly what I needed. Thanks!

Hey Just a Quick Note, when there are 500 ways of doing things, all of them complicated, you seem find the easiest and best solutions. I have seen this probably 20 times and I still have to come back to it sometimes. Thanks again Shane!

@Shane Young I love your videos. I am by training and profession a hard-core developer for over 25 years. I am getting close to my retirement age, and decided to take a position that would be "less challenging" for the last five years of my career. Oh boy! I was wrong about the less-challenging part. LOL Especially for a developer, PowerApps is quite challenging because it is a whole different way of thinking, the patterns and approaches to problems are very different that when I am developing (in either low-level or high-level languages). Needless to say, in trying to write apps using PowerApps has been quite challenging...more so than when I need to learn another programming language. This is how I come to find your videos. I am very grateful to you and a handful of others for their PowerApps videos. You've saved me countless hours. It's not just learning the functions and syntax, often its even even knowing that such functions or features are even built in and available. It's also figuring the best approach, design patterns. Anyway. Thankyou for your fantastic videos, and the way in which you present them. Please keep at it.

same here long time viewer but first time commenter, Hats off to you Shane, simple way to learn one of the complicated topics

Thanks a lot, A LOT, Shane! I'm new at PowerApps, and I must say the way you teach and share your knowledge is perfect. I followed all the baby steps to implement this functionality in a project I'm working on, learned a lot on the way, and the functionality is running as I expected! Keep sharing, you got a new subscriber from Brazil \0/

Thank's Shane, it works the trick "ID"="EID"; I can patch a whole list or gallery. saludos desde Panamá

Unbelievable! I recently spent days creating an app exactly like this using checkboxes to patch selections to sharepoint. I spent hours just figuring out the rename columns in the ForAll condition because PowerApps was bugging out about the whole ID=ID thing. This video could've saved me a lot time and stress. Note to self...always check with Shane first.

I must call you, "Shane The Savior". Seriously! I was struggling form the with ForAll because my two CDS entities having the same column name. RenameColumns was an excellent workaround. It really helps me. Thank you thank you!!! 🙏 🙏 🙏

Just 5 min into the video and you solved my query and saved my day. Can't thank you enough.

Very very important and well done teaching. Thank you Shane and 911 team!!

Lots of great stuff in one video! Thanks Shane!

Hi Shane, As most of your other videos - this was a great video to watch. I've learned much of the stuff I know by watching your videos. I do however still have a problem saving these changes back into a on-prem SQL server. Is there any video I haven't seen yet, where you update SQL-data based on changes made in PowerApps?

Hey Shane, great video. Your step by step approach makes learning easier.

Shane, you are awesome! Your vids help tremendously! I used your approach for updating multiple selected records using the ForEach Patch combo and it works... kinda. The list I'm updating has a unique-required field index field (RMT_EID), and some other fields (one left as an example). When I try to update multiple records I get an error for adding a duplicate record, for all of the records EXCEPT the last. The LAST changed record DOES work. It's not related to the data, as it is the same outcome regardless of which record is last. Code is: ForAll( RenameColumns(Filter(collMultiUpdateChanged, IsChanged),"ID","GalleryID"), Patch(listName, LookUp(listName,ID=GalleryID), { 'RMT_EID': Resource_1.Text, 'R1 Tower Lead EID': TowerLead_1.Selected.Value } ) )

Hi, Shane! You make powerapps easier! Thanks for all! I have a question if you could help me.. if I have two tables with the same structure (same columns), what is the best way to patch all my records from Table A to Table B? I'm not talking about galleries, but Excel tables as database.. I got how to make it, but it's taking too much time. RemoveIf(Table B; true);; ForAll( Table A; Patch( Table B; { Column 1 in Table A = Column 1 in Table B Column 2 in Table A = Column 2 in Table B (...) } ) )

For those of you who know Microsoft SQL, this may help with your understanding of what Shane Young is doing @11:29..."RenameColumns". RenameColumns is equivalent to SQL's "as" function, which effectively temporarily assigns an alias name to a column (you can do this for table names as well). Here is a generic example: SELECT column_name_1 AS alias_name_1, FROM table_name;

Hey Shane, love this video. Really useful for the project I'm working on right now. The only difference is that, my gallery has to be pushed to DV, and it contains a combobox on each record, which needs to have a unique value - and to simplify, I've created a Label to store the chosen value from the Combobox - instead of patching the same value to all of the records. Can I apply the same method?

Thank you so much Shane for this informative video, I was totally blocked at the adding of check box in gallery after watching this rocking video its zuuuuuuuuup ..... Thanks once again..

Hi Shane, great video this has really helped me! one thing i need to do is reset the 'is chosen' after patch and clear the check boxes after selecting the patch button, can you advise on how to do this or is there a video for this already? - thank you

Thank you Shane! This truly saved my life.

Hi Shane, loving your videos. These have made my job a lot easier & more enjoyable. I was wondering if you had come across this issue below. I'm using an external button from my gallery to Select All or Deselect All records in a gallery. This works fine (thanks to you). However, when I filter my gallery, the Select All button still pulls all records in the Gallery not just those in the filtered view. Any thoughts?

Amazing video Shane, very practical. Thanks a lot for sharing.

Hi Shane, great tutorial as usual. I have a quick question : how we can patch multiple records by checkbox to a different share point list not the source sharepoint of the initial gallery?

Keep on truckin', Shane! 🤯 I need to take a break, let all this percolate..

Thank you so much for the video, Shane.👏 Your baby step method and using buttons to be able to look at my return value did the trick for my particular problem. 🥰 (It's amazing how often your face pops up when I look for power apps advice 😆👍)

Great video. Love the pace.

Thanks for your video, straightforward and inspired, But can you explain more how can we identify the patched records to the others?

You are such a great teacher!

Thank you Bro, you're so good to teach us!!! You help me a lot

Excellent video .. the checkbox option helped me a lot.

Great Job Shane! Please, do you have a content about How alternate selection between two checkboxes?

Another great video. I have used this exact scenario to add checkboxes to a filtered gallery . Can you make a button visible, based on the check box being selected in all records of the filtered gallery. Eg: I have a gallery (timesheet) that is filtered by a persons name. When each day(record) is approved the checkbox is selected. I then have a button to patch the totals to another sharepoint. I do not want that Patch to happen until all the days for that person (records) have been checked. Therefore do not want the Button available until those gallery records have been checked.

Very Good video! A lot of good stuff. Keep it up!

Hi Shane great video, I have a question, how can apply this for new (insert) records?

Hi Shane, thank you very much for the videos ... see how I can put a CheckBox to select all the items from the BrowseGallery and make the IsChoisen column go true?

Hey Shane! Congrats to your videos! I need some help... How could I do to create a new column at my data source?

This was very helpful thank you

hello Shane, your video helped me a lot i have small question to part starting in 15:50 - is it somehow possible to add filter to this ClearCollect(clolectionDemo, AddColumns(Employees, "IsChoosen",false)) that this collection will be filter eg by status of one column and email from second column (eg email of creator item)

Hi Shane, great video! I was just wondering if it's possible to apply different conditions for each record of the gallery. For example, an if statement, but searching data from different SharePoint lists, if they are true, patch it, if don't, then do anything. Thanks.

Hi Shane, Awesome Video. I have used master checkbox outside gallery to check and uncheck all checkboxes with in a gallery. But when I submit the form data is not feeding into SharePoint column. If I select individual checkboxes in gallery it is working fine. My requirement is when I check all checkboxes (or) check all checkboxes and then uncheck couple of checkboxes (or) select individual checkboxes in gallery it should feed data into sharepoint on submitting the form. Kindly help on this. Thanks.

Hi Shane, congrats for your nice videos, this is very helpful. Do you know if there is a way to copy a record with its attachment(s), with Patch or Collect or whatever ? Many thanks , kind regards

Thanks Shane! I have a collection with multiple entries but when it comes to adding the attachments in the collection to SharePoint List there doesn't seem to be a clean way to do this. Would be great to get some clarity in another video :D

Hi @Shane Young., This video is very handy., Thank you. I have a similar requirement but with added complexity. The selected records (from emp table) should be added as new rows to the Allocation table. Can you provide your suggestions please.

Hi Shane, big fan of your work and have spent most of the past year working from your videos. I'm a little confused as to when to use the column like you do when you rename the column in the for all at 14:01 or when to use a ThisRecord.Id for example. When using this record it seems to patch to a collection fine but not to an SQL database. Thanks from Scotland, Angus

Hi Shane, thank you for this wonderful tutorial. I tried to use it but ran into a problem: Say if i have now selected multiple items with your method, is there a way to check if one of the selected items have, let's say an ID which is bigger / smaller than a certain value? i want to change the displaymode of the patch button to "disabled" if one of the selected items has an ID > 99.

Before this i was using Power automate to append data source, now with patch and collect, we can display data from the data source as well!!

Hi! Thank you so much for all your video! A little question: I would like to patch 1 info into several line with the same name: For exemple: I would like to patch for all the line with the name Hugo in my collection the number 5 . How can i do that? Thanks!

Great as usual. What I could not do is to patch a Lookup column with a value from another single line text column from the same List. It ould be great if this could be shown. Thanks.

Hi Shane, great videos, question, I need to pass values to a table to filter, as a single variable they work great, however there are some instances where i need to pass a list of values, how can i accomplish the filtering passing this list? I havent found anything referring this so wondering if you have any guidance on this. cheers

Nice job Shane. Your videos are always inspiring but i would want to ask this: If i have a checkbox that is not inside the gallery and i want when it is checked, every other checkboxes inside the gallery to be checked, how much you handle that?

Hi Shane, Can the checkbox be checked if a dropdown value is greater than zero? And, when the checkbox is checked, this acts as the selected item. If I am understanding the video correctly, the drawback is the user needs to click on the actual checkbox for it to be selected.

Thank Shane for this. Instead of selecting one by one, how can one implement select all then patch?

Hi Shane, Thanks a lot for this video. I have learned much of the stuff by watching your videos. I have a query here...... How to patch all gallery items as a single row in SharePoint list?

Shane, I am filtering a gallery to update multiple records in that gallery. Is there a way to set the default for the gallery items to "Selected". And thank you for all of the knowledge that you pass on

Hi Shane, thanks for your amazing contribution to powerapps community. Can you please tell me if i want to use lookup based on not one but multiple conditions, how can I. I tried using && and "And" but I keep getting error as possible invalied query. Can you please guide me.

Hi Shane, Has there been an update on the LookUp-function? I tried to patch all the records with forall, but it only patches the first record

Nice nice!! How would you put the save button outside of the gallery and achieve the same forall patch? Seems repetitive clicking save on every item in gallery. Is it doable? Thanks

Big Thank you!

Hi Shane, Thanks for such a useful example, it is exactly the kind of operation that I've been trying to achieve. I've come here after failing to patch multiple list entries with only using Patch. I know this is a ForAll tutorial, but could you outline how someone might achieve the same thing using this kind of formula: Patch( DataSource, BaseRecordsTable, ChangeRecordTable1 [, ChangeRecordTable2, … ] )?

Hi! thank you for all your video. It seems that I cannot do a RenameColumns with CDS... would you be able to help on that? :)

Hi Shane and thank you for your video :) I've followed your tutorial, however my button only updates one of the items selected by the checkbox (either the first one or the last one) but it says "Update 3 bookings" Do you know what the problem might be?

Hi Shane, thanks a lot for your Videos! Is it possible to sort the gallery so the selected Items are placed on top ?

Ahhhh I have watched them all regarding Patch and For all and complex columns, and for soe reason my collection gets patched except one field and it is a lookup field, but another lookup field works ok, so not really sure why one does and the other not. No error pointed here. I made a post in the PowerApps community and mentioned you, would mean a lot if you had a look! :)

Could you also provide downloadable sample data as well. So that we can practice along with you. Thank you

Hey Shane, I want to patch multiple entities/columns one w/a drop down and the other with text. I.e. Change the title and the team responsible. Can I do this with one button and expression or do I need multiple?

Hi Shane, thanks for this, i followed and it works except that its too slow because i have 7000 old records on top of my sharepoint list. to improve the app performance, how do you add sort in your syntax so that your lookup start its lookup from the recent record.

Good Morning - Great Video. Is it possible to list the selected items into a text field in a list format, which can be used as an output on a report?

Shane, why toggles drive crazy in a gallery when I scroll up and down. They turn on and off affecting the Patch associate to it.

Hi @Shane Young, i have three diffferent checkbox in gallery (one on the left side, another one in the middle and the other one in right position) and i want to save value in SHAREPOINT list once i checked one of the checkboxs, for example we have employees in gallery and each employee can choose either PC or DESKTOP or PHONE using checkbox and update the choice in sharepoint list, how looks the code? am i going to use Patch? thanks.

Hello shane, it is an awesome presentation... i have a query as usual... i have a collection, colUpdate with column Title and Salary. Now i want to update to my Sharepoint list based on the unique Title column. I am not getting the syntax right... kindly help me on that

Great vid, all working until I tried getting the email addresses in each record of the gallery (only for the checked records) to define the "To" part of the email. Same with the subject, I need information in each record. Is this possible? thank you.

Hi Shane, Please suggest a solution for fetching a multi person column values and patch them to another list's multi person column. It would really help

Shane this was an excellent video, but I've looking for select only one checkbox into the gallery, have you some idea how could I do that?

Hi Shane! This video has been super helpful as always. I'm trying to get the ForAll to edit certain rows/columns that meet an ID criteria, however how I currently have it set up [ForAll(RenameColumns(Filter(PadDetails,PadID=GalleryCurrentPadDisplay_2.Selected.PadID), "PadID", "bPadID"),Patch(PadDetails, LookUp(PadDetails, PadID=bPadID),{PadName: TextInputPadName_1.Text}))] only applies the change to the first row that meets the PadID match, not all rows. Any idea where I'm going wrong?

hi Shane, instead of lookup ,cant we use ThisRecord?

Hi Shane, Thanks for the video. When I try to apply the trick you got for multi select in gallery with check box, I got an wired issue (or a bug). The case is I applied exactly same trick you got. When I select and unselect the same check box, it patched the value while the check box still show as unchecked. Do you have an idea what caused that or it just a bug?

Could you please confirm if this code will work with CDS entity as well? Because i am facing issues with CDS.

Hello Shane, I'm using the code below to try to pass all rows in my gallery that are checked into my list but it also passes rows that are empty/ not checked. how do i only patch rows that are checked in my gallery? ForAll(colcheck, If(!IsBlank(Desktop), Patch(ChecklistAnswers, Defaults(ChecklistAnswers), {Title: Comment, 'Desktop check':Desktop, 'Physical Check': Physical, ReqID: ID, TruckCheckID: varRecord.ID})));

Hi Shane, how do i select multiple items from my gallery with the data coming from source A and based on the selected items from my gallery, create a new record in source B(which is a sharepoint list)

Hello Shane, Thanks for the great video, I was trying something on similar line but getting error. Below is my scenario - I am looping through list of accounts and I wanted to create 'Customer" entity records and I used below code for that ForAll(collAccountsSelected, Patch( 'Customer', Defaults('Customer'), { Name: ThisRecord.Name } ); However I am getting error in it saying " Patch function contains invalid arguments. Is it possible to loop through one entity(Accounts) and create records for some other entity(Customers)? Please advise

So can i use this and send powerapp gallery pic to share point with out a flow? It will be Forall() and patch function alone right

Very weard. A simple ClearCollect() to retrieve some data from a PowerApps Dataverse table. Some columns remain blank in the collection, but the data definitely exists in the table. Any hint? (Thanks for video)

Great video, but, how one add a "select all" to this solution, haven't been able to figure it out, thanks in advance.

Hi Shane,you are awesome , also can you please explain how to update sharepoint list from collection values.

Hey! i got a question, i have 3 lists, One has names,one has desks and the last one contains all the details inserted from the 1st two lists. How can i patch, from a dropdown value? So to better explain it instead of having the dropdown be a general value of true or false for all selected items, i would like to have true for Powerapps Guru and False for Nap Taker, any ideas?

With the addcolumns or renamecolumns functions, are those permanent or temporary for the individual user?

Hi, Shane. Appreciate the video so much. One question here, I built a repeat table using Gallery, collect the records in a collection then Patch to SharePoint list. All works great until I tried to include an Attachment control in it. I now know that Patch doesn't actually work with attachments, but I really need the Attachment control. Any thoughts on this situation? Really appreciate if you got any idea for me. Thanks.

Hi Shane, these videos are great! I have a quick question regarding this process though. I am trying to patch a field in multiple records, but I want to use all items visible in a gallery, not necessarily all items in the entire data source. I've tried making collections, I've tried using BrowseGallery.AllItems, and for some reason it will only work when I use the full data source. Any suggestions?

Hi, great video! I need some help. I am developing an app which is like a shopping cart. Everything is based in Sharepoint. Table 1 shows all the products, Table 2 are the products that were added to the shopping cart. If there are 5 for example bottles of water in Table 1 and two are being ordered (in Table 2), I need a formula that updates Table 1 with the new number of products - in this case 3 bottles. Could you please give me some guidance?

thank you!

If you have the for all out of the patch it might slow down?

Hi Shane. I was wondering If there is way to edit and update a person field inside a gallery

Hi Shane, I have a question about having a gallery with questions/answers input options within the gallery and have "tabs" that filter the gallery based on the question category. Is there an alternative way as I face two problems: 1- when switching categories and the gallery filter changes, the inputted data disappears, and 2- When submitting the list, the gallery uploaded is uploaded based on the current filtered part of the gallery, and not the entire list of questions. I hope this makes sense. Thanks