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
@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.
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.
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. 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.
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. 🙏🏻
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!
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!
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!!! 🙏 🙏 🙏
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.
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!
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..
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.
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;
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 😆👍)
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/
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!
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 } ) )
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.
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! :)
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 (...) } ) )
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
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?
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
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?
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 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.
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?
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?
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
Great vid. Thanks. Please remember that there is no such thing as a "parenthesi". Websters says: "Parenthesis is the singular form. The plural is parentheses. This is a trick question, since “parenthesis” is already the singular, with final syllable pronounced “SIS”. The plural is “"parentheses,” with final syllable pronounced “SEES” (or “seas,” “seize,” or “C’s,” as you please)." Pronouncing it correctly makes you sound even smarter than you already are.
@@ShanesCows You do very well. Your explanations are clear and instructive. We appreciate your videos. It's a small thing, but like that pesky closing parenthesis, it matters.
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?
Hi Shane! I am trying to bulk patch different items to my gallery. It works fine if the value is the same. However when I use this code it copies the record so all the items get the same value as the first one. How do I get different values in the rows, if I want to change multiple items but not with the same value? Love your videos by the way, keep up the awesome work :D
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
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
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
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?
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???
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?
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)
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.
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?
@@ShanesCows How do you tackle this if the items in your gallery has been filtered by using a text input box? For example Filter(Gallery1, InputBox.Text in Title)
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, 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)
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.
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?
@@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
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
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.
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.
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
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?
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
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?
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.
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 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?
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.
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}
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?
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! I think you are not through with the Patch and ForAll functions. I see people use Patch( ... ForAll(...)) and you are using ForAll(... Patch () ). I'm a bit confused about it all. Could you please elaborate on this?
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.
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?
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 czcams.com/video/xgznk4XlPCo/video.html
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
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!
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?
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)
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.
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.
Thanks 😊
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
Happy to help Nick! Thanks for the support.
@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.
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.
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!
Appreciate that. I really try to focus on breaking things down so glad it shows. Have a great day!
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.
This video is like a symphony - it starts slow, builds up and culminates into a crescendo. Wow!
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.
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. 🙏🏻
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!
Awesome and congrats on getting your project done! 🤩
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!
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!!! 🙏 🙏 🙏
Awesome!
Your videos have enabled me to up our powerapps development to a completely different level - Thank you for your efforts !!
Awesome. Good job to you for digging in and learning 😻
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.
Next time Dean, next time. 😀
Very very important and well done teaching. Thank you Shane and 911 team!!
Thanks :)
Hey Shane, great video. Your step by step approach makes learning easier.
Hth
Just 5 min into the video and you solved my query and saved my day. Can't thank you enough.
Awesome :)
Keep on truckin', Shane! 🤯 I need to take a break, let all this percolate..
Thank's Shane, it works the trick "ID"="EID"; I can patch a whole list or gallery. saludos desde Panamá
Awesome 😎
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!
Awesome 😎
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..
Glad it helped!
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.
Awesome, thank you!
Thank you Bro, you're so good to teach us!!! You help me a lot
Happy to help!
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;
Nice explanation. :) I like it. :)
@@ShanesCows Thanks Shane. I have found that I learn best when I can relate it to my developer tools or languages.
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 😆👍)
Glad it helped! Hope you have a happy holiday and my face doesn’t show up too much for you. 😎
@@ShanesCows😂I'm glad, when it does, because then I will probably find what I was looking for 😉 Have a happy holiday, too!
same here long time viewer but first time commenter, Hats off to you Shane, simple way to learn one of the complicated topics
Thank you Shane! This truly saved my life.
Awesome!
You are such a great teacher!
Thank you! 😃
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/
Welcome aboard!
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!
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
}
)
)
The issue is you are referencing controls Reourece_1.Text instead of hte field from the collection.
Amazing video Shane, very practical. Thanks a lot for sharing.
Thanks 😊
This was very helpful thank you
Glad it was helpful!
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!!
Lots of great stuff in one video! Thanks Shane!
Glad to help. 😀
Thanks to you I have a job
Glad to help. 😀 But you did all of the hard work. Good job Eduardo.
Excellent video .. the checkbox option helped me a lot.
Glad to help. 😀
Big Thank you!
You're welcome!
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.
Covered here. czcams.com/video/gsk14D-CYRE/video.html
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! :)
Hey Igor I am not sure. I hope the forums got it solved for you.
Thanks for your video, straightforward and inspired, But can you explain more how can we identify the patched records to the others?
Great video. Love the pace.
Thanks 😊
Hi Shane,you are awesome , also can you please explain how to update sharepoint list from collection values.
This video is a very deep dive on that and the performance choices czcams.com/video/nkp9MrBHN-s/video.html
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
(...)
}
)
)
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
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. 😐
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?
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
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?
UpdateIf(collectionname, true, {IsChosen: true})
Great Job Shane! Please, do you have a content about How alternate selection between two checkboxes?
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, … ] )?
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.
@@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.
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?
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?
Look into the Concat function
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
This video is older. For the most part we use ThisRecord these days. 😎
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
Nope. Check you code again. You should still be able to ForAll it
Great vid. Thanks. Please remember that there is no such thing as a "parenthesi". Websters says: "Parenthesis is the singular form. The plural is parentheses. This is a trick question, since “parenthesis” is already the singular, with final syllable pronounced “SIS”. The plural is “"parentheses,” with final syllable pronounced “SEES” (or “seas,” “seize,” or “C’s,” as you please)." Pronouncing it correctly makes you sound even smarter than you already are.
Thanks. I am terrible at English. 😂
@@ShanesCows You do very well. Your explanations are clear and instructive. We appreciate your videos. It's a small thing, but like that pesky closing parenthesis, it matters.
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?
Hi Shane!
I am trying to bulk patch different items to my gallery. It works fine if the value is the same. However when I use this code it copies the record so all the items get the same value as the first one. How do I get different values in the rows, if I want to change multiple items but not with the same value?
Love your videos by the way, keep up the awesome work :D
You have to save to the collection line by line. You can’t bulk patch the collection
@@ShanesCows What does that mean? how are you doing that in your youtube example?
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
Did you see this video? The collection may help you. czcams.com/video/7XXo9wjnJvc/video.html
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
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
There is not. 😐
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?
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???
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?
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)
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.
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?
You need the check boxes to be tied(default) to a value in the data source that is the Items for your gallery. Then use ForAll to change that value
@@ShanesCows How do you tackle this if the items in your gallery has been filtered by using a text input box? For example Filter(Gallery1, InputBox.Text in Title)
Very Good video! A lot of good stuff. Keep it up!
Will do. Thanks
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.
Responded to other comment
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)
This video shows most of that. Change the Patch from updating records to creating new records and you should have it.
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.
Sort the collection by id and then get the last record. Check if it is bigger than 99?
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,
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?
Hi Shane, thanks a lot for your Videos! Is it possible to sort the gallery so the selected Items are placed on top ?
done... :)
Glad you got it 🐶
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?
Yes. Give this video a watch for some ideas. czcams.com/video/bfXV_GXc_JM/video.html
@@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
@@ShanesCows I GOT IT! I GOT IT ..... I ..........iiiiiiiiiiiiiiiiiii GOT IT:
Concat(Filter(galLocation.AllItems,Checkbox3.Value), Locations,Char(10))
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
I think I showed that in this video czcams.com/video/oKJkVx2gehw/video.html
hi Shane, instead of lookup ,cant we use ThisRecord?
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
Sorry I am behind on comments. Hope you got it.
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.
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.
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
I talk about it in this video. czcams.com/video/gsk14D-CYRE/video.html
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?
I use renamecolumns to deal with overlapping column namea
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
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?
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?
Patch the record and change the IsChosen column to true
@@ShanesCows Thanks a lot!
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.
ForAll(Filter(datasource, criteria to only get the records you want),.... Something like that. Filter the data down you are loopin through
@@ShanesCows got it, thank you so much. It's working smoothly now.
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.
To patch an attachment control I think you have to form the table but I am not sure. I have never tried. Sorry
@@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?
Hi Shane. I was wondering If there is way to edit and update a person field inside a gallery
Yes, if you add the field to your form Power Apps should make it all work for you.
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.
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?
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}
)
)
Sorry I am behind on comments. Glad you got it.
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?
Check out the function UpdateIf that is exactly what you need in this case I think.
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.
thanks !!!!!
Happy to help
Hi Shane great video, I have a question, how can apply this for new (insert) records?
Hi Shane! I think you are not through with the Patch and ForAll functions. I see people use Patch( ... ForAll(...)) and you are using ForAll(... Patch () ). I'm a bit confused about it all. Could you please elaborate on this?
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.
Alan look at UpdateIf function. I don’t think I have a video. Guess I need to add it to the list.
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?
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 czcams.com/video/xgznk4XlPCo/video.html
If you have the for all out of the patch it might slow down?
Check out this video that talks about bulk writes and how to use Monitor to see the performance ramifications. czcams.com/video/nkp9MrBHN-s/video.html
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
I am not sure exactly what your are trying but I think this video is in the ballpark 😎
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!
You want to use the function UpdateIf :)
Thank Shane for this. Instead of selecting one by one, how can one implement select all then patch?
I thought the video showed it. Update all the records at once to true.
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.
You might have code OnChange that is getting triggered repeatidly?
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?
One button will be fine. ForAll will help
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)
Hey Shane! Congrats to your videos! I need some help... How could I do to create a new column at my data source?
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.