You are welcome. If it helps I revisited the concept of selecting multiple items here th-cam.com/video/wpZbYPvPO68/w-d-xo.html a little different take if you are curious.
@ 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! 🇦🇺
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!
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.
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;
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.
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, 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!
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. 🙏🏻
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'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}
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.
Check out this video that talks about bulk writes and how to use Monitor to see the performance ramifications. th-cam.com/video/nkp9MrBHN-s/w-d-xo.html
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 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!
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, 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
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!!! 🙏 🙏 🙏
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.
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!
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 th-cam.com/video/xgznk4XlPCo/w-d-xo.html
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
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! I have a gallery list with toggles defaulted to 'true'. Here, the user can choose to turn off some toggles if needed. I want to display that gallery in the next screen but only show the results which still have toggle = 'true'. How can I do this? (Data from SQL Server). Thanks in advance!
@@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
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.
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.
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.
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
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.
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, 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
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?
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, 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.
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, 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 @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.
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?
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
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.
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?
Hope someone can help me out I'm trying to change the contents of multiple records in a sharepoint list where a certain column equals something example, I want to change the values of Column B where Column A equals "C" for all the records in the sharepoint list. When I try to use the ForAll function, I get an error "This Function cannot opperate on the same data source that is used in the ForAll" for the Patch function. When I remove the ForAll, it just changes the 1st record not all. :(
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)
Hi Shane. I have having some problems leveraging the ForAll to patch records with a checkbox. It doesn't show any error but when i process the button to patch the data from my collection to the Sharepoint list nothing happens. Have you experience this issue below? ForAll( RenameColumns( Filter( SkillsBulk, IsUpdated = true ), "ID", "EID" ), Patch( Resource_Skills, Defaults(Resource_Skills), { Title: Title, RS_RP_ID: LookUp( Resource_Profile, RP_Email = User().Email, ID), RS_Skill_ID: EID, RS_Email: User().Email, RS_EMPLOYEE_LOOKUP_PROFILE: {Id: LookUp( Resource_Profile, RP_Email = User().Email, ID) , Value: User().Email, '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"}, RS_SkillGroup: SD_Practice, RS_Employee: { '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference", Claims: User().Email, Department: "", DisplayName: User().FullName, Email: User().Email, JobTitle: "", Picture: "" } } )); ClearCollect( SkillsBulk, AddColumns( Skills, "IsUpdated", false ) ); Navigate('Edit Entry',ScreenTransition.CoverRight)
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!
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?
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
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, 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 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.
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 could you teach me how to do this: i have an email column in SPList, i want to patch the existing name column, whole column, with O365user.display name if the email match with O365user email. beg for help ~~~
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, 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?
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, 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, 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.
@@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
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! 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! 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, 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?
Forall(Gallery.AllItems, Patch() ) Should work :| Not sure why it wouldn't. Maybe try ForAll(Formula from the Items property of the gallery, ...) Instead?
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, 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.
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)
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.
5 years later and this is still soooo helpful, thank you!
You are welcome. If it helps I revisited the concept of selecting multiple items here th-cam.com/video/wpZbYPvPO68/w-d-xo.html a little different take if you are curious.
@ 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! 🇦🇺
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!
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.
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.
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.
Thanks 😊
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, 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!
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. 🙏🏻
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. 😀
Hey Shane, great video. Your step by step approach makes learning easier.
Hth
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 😻
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 🐶
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.
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!
Just 5 min into the video and you solved my query and saved my day. Can't thank you enough.
Awesome :)
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. th-cam.com/video/nkp9MrBHN-s/w-d-xo.html
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, 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. th-cam.com/video/7XXo9wjnJvc/w-d-xo.html
Do you have an example where you can do a Select All with your Gallery and patch the records?
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
@@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!
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.
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!
Very very important and well done teaching. Thank you Shane and 911 team!!
Thanks :)
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. 😎
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!
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.
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 😎
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 th-cam.com/video/xgznk4XlPCo/w-d-xo.html
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. th-cam.com/video/gsk14D-CYRE/w-d-xo.html
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})
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
Hi!
I have a gallery list with toggles defaulted to 'true'. Here, the user can choose to turn off some toggles if needed.
I want to display that gallery in the next screen but only show the results which still have toggle = 'true'.
How can I do this? (Data from SQL Server).
Thanks in advance!
Same as this video. When they click the toggle update the collection. 😎
@@ShanesCows Thank you :))
Is it possible to use ForAll with Gallery.Allitems so that all items in the gallery get a field populated onselect or something?
AllItems is read only. You would have to update the collection or table the gallery is using for Items
@@ShanesCows ForAll(RenameColumns(BrowseGallery1.AllItems, "ID","EID"),Patch(Orders,LookUp(BrowseGallery1.AllItems,ID = EID),{Submitted:true}))
@@ShanesCows Love your videos btw... they've been a huge help!
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?
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. th-cam.com/video/bfXV_GXc_JM/w-d-xo.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))
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?
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 th-cam.com/video/oKJkVx2gehw/w-d-xo.html
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.
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.
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
same here long time viewer but first time commenter, Hats off to you Shane, simple way to learn one of the complicated topics
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, I am trying to post a gallery to a sharepoint list. I am not getting through with Patch or ForAll
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.
If you want to create a new comment with more details I will try to help you translate.
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
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!
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. 😐
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
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.
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.
This video th-cam.com/video/QcWjAt7QVn4/w-d-xo.html
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.
You are such a great teacher!
Thank 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.
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. 😐
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 😎
Great Job Shane! Please, do you have a content about How alternate selection between two checkboxes?
What code language use in power app?
Power Apps uses its own that is kind of based off Excel. docs.microsoft.com/en-us/powerapps/maker/canvas-apps/formula-reference
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.
Thank's Shane, it works the trick "ID"="EID"; I can patch a whole list or gallery. saludos desde Panamá
Awesome 😎
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?
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
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.
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?
Hope someone can help me out
I'm trying to change the contents of multiple records in a sharepoint list where a certain column equals something
example, I want to change the values of Column B where Column A equals "C" for all the records in the sharepoint list.
When I try to use the ForAll function, I get an error "This Function cannot opperate on the same data source that is used in the ForAll" for the Patch function.
When I remove the ForAll, it just changes the 1st record not all. :(
Try UpdateIf th-cam.com/video/zINTAUJqQhg/w-d-xo.html
@@ShanesCows AMAZING! UpdateIf didn't work but you fixed the same error I had at 8:20 of the video! You are a god! Thanks Bud!
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
Great video, but, how one add a "select all" to this solution, haven't been able to figure it out, thanks in advance.
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. I have having some problems leveraging the ForAll to patch records with a checkbox. It doesn't show any error but when i process the button to patch the data from my collection to the Sharepoint list nothing happens. Have you experience this issue below?
ForAll(
RenameColumns(
Filter(
SkillsBulk,
IsUpdated = true
),
"ID",
"EID"
),
Patch(
Resource_Skills,
Defaults(Resource_Skills),
{
Title: Title,
RS_RP_ID: LookUp( Resource_Profile, RP_Email = User().Email, ID),
RS_Skill_ID: EID,
RS_Email: User().Email,
RS_EMPLOYEE_LOOKUP_PROFILE:
{Id: LookUp(
Resource_Profile,
RP_Email = User().Email,
ID)
,
Value: User().Email,
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference"},
RS_SkillGroup: SD_Practice,
RS_Employee: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
Claims: User().Email,
Department: "",
DisplayName: User().FullName,
Email: User().Email,
JobTitle: "",
Picture: ""
}
}
));
ClearCollect(
SkillsBulk,
AddColumns(
Skills,
"IsUpdated",
false
)
);
Navigate('Edit Entry',ScreenTransition.CoverRight)
I would try removing title: title. Also try only patching one column. Get it working simple then add columns till you find the problem child.
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 :)
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?
Thank you Bro, you're so good to teach us!!! You help me a lot
Happy to help!
Office365OutLook object not available, what is the reason ? Is there a need to install Outlook client ? I am using web based Outlook.
Did you add the Data source?
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
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 great video, I have a question, how can apply this for new (insert) records?
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
Sorry I am behind on comments. You have to use Flow to send files to SHarePoint. th-cam.com/video/3QaiM8SeWfM/w-d-xo.html
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?
Did you set the Default property of the check box
@@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.
With the addcolumns or renamecolumns functions, are those permanent or temporary for the individual user?
They are just for that control for that instance of it. Doesn’t change the datasource just how the control acts.
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 could you teach me how to do this: i have an email column in SPList, i want to patch the existing name column, whole column, with O365user.display name if the email match with O365user email. beg for help ~~~
Did you see this video that talks about complex columns? th-cam.com/video/gsk14D-CYRE/w-d-xo.html
hi Shane, instead of lookup ,cant we use ThisRecord?
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, 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.
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.
Thanks for your video, straightforward and inspired, But can you explain more how can we identify the patched records to the others?
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 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,
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.
You can’t do that with a gallery
Hey Shane
Thanks for reply.
I was somehow able to implement it. I am able to save all items after modification.
@@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
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! 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
(...)
}
)
)
Keep on truckin', Shane! 🤯 I need to take a break, let all this percolate..
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?
Johanna try UpdateIf instead. I think it might be easier to use in this scenario. Probably need to make a video on it.
@@ShanesCows I'll give that a go. Thank you so much!
Can you use ForAll to patch a collection of “People” to a Multiple People column in a SharePoint List?
Yes. Look at my video on patch complex SharePoint columns and combine the concepts. 😀
@@ShanesCows you're a boss
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?
Forall(Gallery.AllItems, Patch() ) Should work :| Not sure why it wouldn't. Maybe try ForAll(Formula from the Items property of the gallery, ...) Instead?
@@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!
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, 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.
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)
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. th-cam.com/video/gsk14D-CYRE/w-d-xo.html
Could you please confirm if this code will work with CDS entity as well? Because i am facing issues with CDS.
Yes. Same formula will work I. CDS
Could you also provide downloadable sample data as well. So that we can practice along with you. Thank you