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

[@HeyTezza]

5 years later and this is still soooo helpful, thank you!

[@ShanesCows]

You are welcome. If it helps I revisited the concept of selecting multiple items here kzbin.info/www/bejne/raG9k4yGq7WCbJo a little different take if you are curious.

[@HeyTezza]

@ thank you so much! I’ve been consuming as much as I can of your videos in the last 3 weeks, I’ve been watching intermittently for a few years knowing I wanted to upgrade the crappy app we had someone build. They built a SharePoint backend, I kid you not we have a SharePoint field called “Can this asset be operated safely?” (Yep they included the question mark). The dates are text fields, the numbers are text fields. I’ve looked at the back end of this thing for years and refused to touch it unless I could rebuild it. I think I’ve built a bloody beautiful app (it’s my first) in 8 days and it’s all thanks to you! Thank you soooo much for all these awesome videos, you have no idea how much everyone appreciates you! 🇦🇺

[@kearley8792]

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

[@ShanesCows]

Glad to help. I agree that sometime you talented developers this low code stuff is harder because we have so many rules and gates to get through. Best of luck! I love the learning mentality.

[@berggrog1]

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!

[@ShanesCows]

Appreciate that. I really try to focus on breaking things down so glad it shows. Have a great day!

[@npschre]

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

[@ShanesCows]

Happy to help Nick! Thanks for the support.

[@philipmarno4989]

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.

[@GSMonkey]

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.

[@ShanesCows]

Thanks 😊

[@mangeshmehendale4139]

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

[@ShanesCows]

Thanks that is very kind of you. Starting slow is boring I’d you know it but a lot of people need it so I do it.

[@delax1974]

Starting slow is the reason I come to your channel for everything PowerApps. I particularly enjoy how astute you are to point out stuff which can be so easily missed when you try it yourself without the benefit of a video instruction playing alongside. That cements my understanding of the concepts - thus teaching me to fish rather than just eating it. 🙏🏻

[@joannaanderson8669]

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!

[@ShanesCows]

Awesome and congrats on getting your project done! 🤩

[@sinceregerald4003]

sorry to be off topic but does anyone know of a way to get back into an instagram account? I stupidly forgot my account password. I would love any assistance you can give me!

[@hi_vishy]

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

[@ShanesCows]

Awesome :)

[@naderhayek3310]

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

[@ShanesCows]

Awesome. Good job to you for digging in and learning 😻

[@Bekesam]

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

[@ShanesCows]

Thanks :)

[@akshat8899]

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

[@ShanesCows]

Hth

[@johelsantos5636]

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

[@ShanesCows]

Awesome 😎

[@dnickgt16]

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!

[@ShanesCows]

Awesome 😎

[@shyamksukumaran]

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

[@ShanesCows]

Awesome!

[@christineserin8470]

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.

[@ShanesCows]

Awesome, thank you!

[@ashrafjavali2841]

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

[@ShanesCows]

Glad it helped!

[@hudsonquay]

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.

[@ShanesCows]

Next time Dean, next time. 😀

[@kearley8792]

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;

[@ShanesCows]

Nice explanation. :) I like it. :)

[@kearley8792]

@@ShanesCows Thanks Shane. I have found that I learn best when I can relate it to my developer tools or languages.

[@ashishchakole5432]

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

[@chanokponyongyat7239]

Thank you Shane! This truly saved my life.

[@ShanesCows]

Awesome!

[@pteixeira1089]

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/

[@ShanesCows]

Welcome aboard!

[@educacaofisica-tiakarina285]

Oi Pedro... Boa tarde! Não sei se consegue me ajudar, mas tô tentando fazer uma lista de chamada e pra isso queria usar checkbox pra definir os presentes e ausentes. E ainda pra isso, teria que criar uma nova coluna onde setaria essa informação. Vc sabe como poderia fazer isso? Desde já obrigada!

[@susanpierce2354]

You are such a great teacher!

[@ShanesCows]

Thank you! 😃

[@AnnikaSchulz-t2o]

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 😆👍)

[@ShanesCows]

Glad it helped! Hope you have a happy holiday and my face doesn’t show up too much for you. 😎

[@AnnikaSchulz-t2o]

@@ShanesCows😂I'm glad, when it does, because then I will probably find what I was looking for 😉 Have a happy holiday, too!

[@patrickteless]

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

[@ShanesCows]

Happy to help!

[@emilioroqueta4445]

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

[@ShanesCows]

Thanks 😊

[@JohnDoe-pe6yl]

I have been trying setup my gallery everything works great until I add the form that goes with item selected. Any clues of why this could be happening? Is it due to the gallery being set as a collection?

[@haggismacl]

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

[@ShanesCows]

This video is older. For the most part we use ThisRecord these days. 😎

[@NKBobcat]

Lots of great stuff in one video! Thanks Shane!

[@ShanesCows]

Glad to help. 😀

[@khargos7602]

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

[@bexjuice]

This was very helpful thank you

[@ShanesCows]

Glad it was helpful!

[@AssassinUK]

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

[@ShanesCows]

Glad to help. 😀

[@ship4brainz]

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 } ) )

[@ShanesCows]

The issue is you are referencing controls Reourece_1.Text instead of hte field from the collection.

[@annehinken8012]

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

[@annehinken8012]

done... :)

[@ShanesCows]

Glad you got it 🐶

[@MrFrbohn]

Great video. Love the pace.

[@ShanesCows]

Thanks 😊

[@williammezabazan5096]

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?

[@ShanesCows]

UpdateIf(collectionname, true, {IsChosen: true})

[@Karol-ft9pz]

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)

[@pierregoffin4043]

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

[@ShanesCows]

Attachments are so weird with Power Apps that I don't know of a solid way to tell you to do this short of running a flow. 😐

[@diltoncesarjunior1848]

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

[@pkns_cad]

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.

[@deepikaradhakrishnan01]

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

[@ShanesCows]

Yes, if you add the field to your form Power Apps should make it all work for you.

[@pixelb0i255]

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

[@NikithaLeviosa]

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

[@ShanesCows]

This video is a very deep dive on that and the performance choices kzbin.info/www/bejne/pJzTaoCod62BY9U

[@AhmedBalfaqih]

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.

[@ShanesCows]

Covered here. kzbin.info/www/bejne/naTOYmd6YqiMiKc

[@garyhuang11]

Do you have to use collections to store who has been selected? Is there anyway to use the gallery selected check box item at all?

[@garyhuang11]

I've figured it out. You don't have to use collections: ForAll(RenameColumns(Filter(Gallery2.AllItems, Checkbox2.Value = true), "Dummy_ID", "ClientID"), Patch( 'SourceFINAL', LookUp( 'SourceFINAL', ClientID = Dummy_ID), {Caller: Dropdown2.Selected.Title} ) )

[@ShanesCows]

Sorry I am behind on comments. Glad you got it.

[@tricacole]

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

[@ShanesCows]

Check out this video that talks about bulk writes and how to use Monitor to see the performance ramifications. kzbin.info/www/bejne/pJzTaoCod62BY9U

[@vjdiorio]

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?

[@ShanesCows]

Yes. Give this video a watch for some ideas. kzbin.info/www/bejne/mJe7h5J9jciSgK8

[@vjdiorio]

@@ShanesCows Thank you so much for the prompt response, although that didn't work out for me. I'm looking to extract the selected items within the Gallery, rather than 'allitems'. hmmmmmm

[@vjdiorio]

@@ShanesCows I GOT IT! I GOT IT ..... I ..........iiiiiiiiiiiiiiiiiii GOT IT: Concat(Filter(galLocation.AllItems,Checkbox3.Value), Locations,Char(10))

[@chahineatallah2636]

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

[@traceyblackmore852]

Do you have an example where you can do a Select All with your Gallery and patch the records?

[@ShanesCows]

I didn’t do a video but they key is to update all of the records with IsChosen or whatever to true. You can do that with a ForAll button

[@traceyblackmore852]

@@ShanesCows Thank you! I'm new to PowerApps and enjoy your videos for learning. Would you happen to have a video or explanation that you can direct me to, on how to select employees from an employee list (using IsChosen), then I have an editable table where I add time to separate SP list (called timelist). When I update my record (timelist), I'm only patching one record from the employee list, not all the chosen records in my collection. I'm assuming it's probably due to some ID missing?? Thanks again!

[@adamshrinah2595]

Big Thank you!

[@ShanesCows]

You're welcome!

[@HansAllende]

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?

[@ShanesCows]

Patch the record and change the IsChosen column to true

[@HansAllende]

@@ShanesCows Thanks a lot!

[@rachelreysag7323]

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.

[@ShanesCows]

ForAll(Filter(datasource, criteria to only get the records you want),.... Something like that. Filter the data down you are loopin through

[@rachelreysag7323]

@@ShanesCows got it, thank you so much. It's working smoothly now.

[@barnaliroy8703]

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

[@ShanesCows]

I talk about it in this video. kzbin.info/www/bejne/naTOYmd6YqiMiKc

[@马勒-n3y]

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

[@danhnguyen287]

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

[@ShanesCows]

Nope. Check you code again. You should still be able to ForAll it

[@Nophramel]

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.

[@ShanesCows]

Sort the collection by id and then get the last record. Check if it is bigger than 99?

[@maggiesayabie]

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

[@ShanesCows]

I thought the video showed it. Update all the records at once to true.

[@gatafish]

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

[@ShanesCows]

There is not. 😐

[@DannyMaes]

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)

[@ShanesCows]

It a performance enhancing "feature". Settings> Upcoming Features > Explicit Column Selection. The reason it is happening is POwer Apps doesn't think you need that data.

[@grantrothwell8479]

Hi Shane, I know this is an old video, but after following all the steps to select records in the gallery, it works well for the first dozen or so in the gallery, but the ones at the lower end of the list are "intermittent" and don't change smoothly or regularly when checked or unchecked Any clues???

[@ShanesCows]

Hey Grant, I haven't ran into that. Check to see if the problem is only in the Maker. So if you publish the app and run it as a user does it get as grumpy?

[@sdicoii3456789]

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

[@gustavoleal3397]

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

[@gabrielmelo6688]

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 (...) } ) )

[@Itsprincessa01]

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)

[@ShanesCows]

This video shows most of that. Change the Patch from updating records to creating new records and you should have it.

[@bharathirajkumar]

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

[@Eddyyc]

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

[@ShanesCows]

I am not sure exactly what your are trying but I think this video is in the ballpark 😎

[@rochellenicholson6372]

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.

[@santharamk6764]

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?

[@ShanesCows]

Look into the Concat function

[@justinpollard5774]

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

[@ShanesCows]

Did you see this video? The collection may help you. kzbin.info/www/bejne/bYm7oGytn9N9rMU

[@igortorrealba]

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

[@ShanesCows]

Hey Igor I am not sure. I hope the forums got it solved for you.

[@jeevakumartimirilakshmipat8468]

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.

[@faisalnoorhussain163]

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.

[@ShanesCows]

Responded to other comment

[@shalom9234]

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

[@educacaofisica-tiakarina285]

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

[@alanvelazquez9144]

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.

[@ShanesCows]

Alan look at UpdateIf function. I don’t think I have a video. Guess I need to add it to the list.

[@treybrewington3286]

I have a share point that inventory goes to. You enter the quantity and store number and hit the restock button. The only problem is that I have to hit restock after every quantity entered to send them. I wanna enter multiple quantity's and only hit the restock button 1 time to get them to go to the share point. I've tried using a patch function, and a clear collect function. Any other suggestions?

[@ShanesCows]

Put all of the data into a collection and then ForAll through that collection and patch the values is how I would do it. This video kind of shows the concept kzbin.info/www/bejne/rpjdn55qjdGDedE

[@graffam198]

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?

[@ShanesCows]

One button will be fine. ForAll will help

[@rdk26]

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

[@殷晓峰-b5s]

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.

[@ShanesCows]

To patch an attachment control I think you have to form the table but I am not sure. I have never tried. Sorry

[@殷晓峰-b5s]

@@ShanesCows Thanks. I am trying to use Add Image in the gallery. There is no problem to show in the collection. Any idea how to patch the image to SharePoint?

[@marlondixon7997]

Hi Shane, I am trying to post a gallery to a sharepoint list. I am not getting through with Patch or ForAll

[@ShanesCows]

A gallery is a table and SharePoint is looking for a record. So you might have to think more about what you are trying to do.

[@ShanesCows]

If you want to create a new comment with more details I will try to help you translate.

[@marlondixon7997]

Thank you. I posted to a different list. Then im going to join both lists in the ms flow to show the details hopefully using a filter

[@robblanford9555]

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, … ] )?

[@ShanesCows]

Yikes. Patch doesn’t work that way. I think you would have to figure out a way to use ForAll to iterate through the records.

[@robblanford9555]

@@ShanesCows Yes, it came to exactly that. Also the same methodology for appending one SharePoint list to another seems to be to ForAll row by row, creating a Defaults row in the destination list and specifying every source and destination field including disambiguation. Thanks for the pointer and the vids, you are a rock star.

[@StevenBoliek]

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

[@ShanesCows]

They are just for that control for that instance of it. Doesn’t change the datasource just how the control acts.

[@andreybolanos4883]

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.

[@ShanesCows]

You might have code OnChange that is getting triggered repeatidly?

[@laetitiahuas6461]

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!

[@ShanesCows]

You want to use the function UpdateIf :)

[@kanishkaroychowdhury4050]

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

[@ShanesCows]

Sorry I am behind on comments. Hope you got it.

[@chanokponyongyat7239]

What if I'd like to update individual value of each row of gallery to each row of Sharepoint list? not with the same value

[@ShanesCows]

I think I showed that in this video kzbin.info/www/bejne/pXytnImuZ8yYntk

[@joesstlouis]

Is it possible to use ForAll with Gallery.Allitems so that all items in the gallery get a field populated onselect or something?

[@ShanesCows]

AllItems is read only. You would have to update the collection or table the gallery is using for Items

[@joesstlouis]

@@ShanesCows ForAll(RenameColumns(BrowseGallery1.AllItems, "ID","EID"),Patch(Orders,LookUp(BrowseGallery1.AllItems,ID = EID),{Submitted:true}))

[@joesstlouis]

@@ShanesCows Love your videos btw... they've been a huge help!

[@rosscortb]

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.

[@ivannaivanova3623]

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?

[@ShanesCows]

Check out the function UpdateIf that is exactly what you need in this case I think.

[@sanjayjoshi8957]

Hi Shane, I saw your video. It was great. I am stuck in my one requirement. I have a gallery with 5 items ( not a fixed number ). Each item has "ID , Name and comment" fields. Initially i have value in ID and Name field. But i fill comments manually one by one and then submit all of them into a SharePoint list. In your video you were maintaining a checkbox to select and then save/patch those items into collection. But in my case i need to save all items in a hit of single save button. any suggestion.

[@ShanesCows]

You can’t do that with a gallery

[@sanjayjoshi8957]

Hey Shane Thanks for reply. I was somehow able to implement it. I am able to save all items after modification.

[@marcocruz8440]

@@sanjayjoshi8957 This worked for me. I patched the collection we created. Then used the collection (with the new fields i was using a gallery that had an editable date) to patch the source. I doubt this is optimal but idk what else to do lol

[@joelmartinez7628]

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.

[@ryanvigneau1442]

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?

[@ShanesCows]

Forall(Gallery.AllItems, Patch() ) Should work :| Not sure why it wouldn't. Maybe try ForAll(Formula from the Items property of the gallery, ...) Instead?

[@ryanvigneau1442]

@@ShanesCows I ended up using a Collection of the AllItems and it ended up working. I'm not fully sure why but I got it to work!

[@jeremywintz2575]

Shane - I tried this tutorial but kept getting an error at the ID, EID step. When I checked the gallery data created from a previous video, there was no ID field and I ended up creating it but am still getting the error. My ID field is not reading as IT but as the publisher prefix attached to it. When I try doing the rename with the recognized prefixed ID field, I'm still getting the error.

[@eduardomanrique5794]

Thanks to you I have a job

[@ShanesCows]

Glad to help. 😀 But you did all of the hard work. Good job Eduardo.

[@xaviergonzalez7047]

It works, but when the page is refreshed the Collections calculations are gone. How can I have the calculations refresh when the app is freshed or open by a new user?

[@debaratiray2482]

Can you please help with bulk add option in Powerapps.Lets say we have an excel with the data and i want to upload the file to the table.

[@ShanesCows]

This video kzbin.info/www/bejne/h5S6m3SqbLaJpJY

[@sunpengjie4565]

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?

[@ShanesCows]

Did you set the Default property of the check box

[@sunpengjie4565]

@@ShanesCows I tried both, set or not set. While the result is the same. If you want, I can send you the screenshot to let you have a look at it. The data source I got is result from flow. Then I add those details in a collection.

[@rocheverte]

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?

[@kennykenny5833]

What code language use in power app?

[@ShanesCows]

Power Apps uses its own that is kind of based off Excel. docs.microsoft.com/en-us/powerapps/maker/canvas-apps/formula-reference

[@JerHarwood]

My gallery doesn't recognize the added column for the check-box even though it is there with values when viewing the collection. Since I have no problem creating a new gallery pointed to just the collection, I fear it is due to the gallery where it's needed having a condition for the data source based on a variable. Due to delegation I am using the collection for the "active view" and the SP list for the "completed view" - in simple concept if the variable is "active" the gallery shows the collection data, if "completed" it shows the data from the SP list directly. It is this way in an effort to avoid duplication of galleries and controls within so when change is needed updating is minimal. So, is my fear correct? ...if not, is there a way to identify the collection added column in this case like using [@...] to specify a local data source when duplicate names exist? ...and if so, is my best option to use separate galleries to view collection data vs SP data directly?

[@ShanesCows]

I use renamecolumns to deal with overlapping column namea