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.
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!
Unbelievable! I recently spent days creating an app exactly like this using checkboxes to patch selections to sharepoint. I spent hours just figuring out the rename columns in the ForAll condition because PowerApps was bugging out about the whole ID=ID thing. This video could've saved me a lot time and stress. Note to self...always check with Shane first.
I must call you, "Shane The Savior". Seriously! I was struggling form the with ForAll because my two CDS entities having the same column name. RenameColumns was an excellent workaround. It really helps me. Thank you thank you!!! 🙏 🙏 🙏
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 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..
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 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 😆👍)
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, 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
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.
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?
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 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.
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
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 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.
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 } ) )
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
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!
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, 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, 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?
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, 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.
Hey Shane, I want to patch multiple entities/columns one w/a drop down and the other with text. I.e. Change the title and the team responsible. Can I do this with one button and expression or do I need multiple?
Hi Shane, 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 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?
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.
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
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, 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.
Hi, great video! I need some help. I am developing an app which is like a shopping cart. Everything is based in Sharepoint. Table 1 shows all the products, Table 2 are the products that were added to the shopping cart. If there are 5 for example bottles of water in Table 1 and two are being ordered (in Table 2), I need a formula that updates Table 1 with the new number of products - in this case 3 bottles. Could you please give me some guidance?
@@ShanesCows 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, 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, 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 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, 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, 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.
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.
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, big fan of your work and have spent most of the past year working from your videos. I'm a little confused as to when to use the column like you do when you rename the column in the for all at 14:01 or when to use a ThisRecord.Id for example. When using this record it seems to patch to a collection fine but not to an SQL database. Thanks from Scotland, Angus
@@ShanesCows 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! 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, 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
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, I have over 1000 records to update (Patch All). This is running really slow. Is there a way to make it run faster or an alternative method I can use? And Thanks for all your videos. They are great help!
ForAll iterates over each record which makes it slow. You can pass Patch a table which has the potential to be processed all at once, which would be far quicker. I've not managed to get the syntax right and have asked for Shane's help above. I want to use it for something like updating the job description with the same new content for everyone with the title "Software Engineer".
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?
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! I was just wondering if it's possible to apply different conditions for each record of the gallery. For example, an if statement, but searching data from different SharePoint lists, if they are true, patch it, if don't, then do anything. Thanks.
Hi, Shane! 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, 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! 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, 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?
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.
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?
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. 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 Shane! Your videos have helped me a lot lately, I have 0 experience with programming and code, but I have created and ap that actually works. I have a bounch of textboxes that are collected and then sent to an excel table source with the ForAll function in a button. Could it be possibe to sort the excel source table by the date column after the data is sent?
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
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?
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.
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 😊
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!
Hey Shane, great video. Your step by step approach makes learning easier.
Hth
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. 😀
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!
Very very important and well done teaching. Thank you Shane and 911 team!!
Thanks :)
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 😻
Just 5 min into the video and you solved my query and saved my day. Can't thank you enough.
Awesome :)
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!
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 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!
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's Shane, it works the trick "ID"="EID"; I can patch a whole list or gallery. saludos desde Panamá
Awesome 😎
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!
hi Shane, instead of lookup ,cant we use ThisRecord?
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, 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. 😐
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 🐶
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.
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?
You are such a great teacher!
Thank you! 😃
Thank you Bro, you're so good to teach us!!! You help me a lot
Happy to help!
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 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.
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 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 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, 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.
same here long time viewer but first time commenter, Hats off to you Shane, simple way to learn one of the complicated topics
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!
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.
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. 😐
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!
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, 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?
Keep on truckin', Shane! 🤯 I need to take a break, let all this percolate..
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?
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,
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.
Thank you Shane! This truly saved my life.
Awesome!
Hi Shane great video, I have a question, how can apply this for new (insert) records?
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
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 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})
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.
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
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, 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.
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.
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
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, 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, 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 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
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.
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,
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.
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.
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, 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. 😎
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! 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 :)
Amazing video Shane, very practical. Thanks a lot for sharing.
Thanks 😊
Hi Shane, great videos, question, I need to pass values to a table to filter, as a single variable they work great, however there are some instances where i need to pass a list of values, how can i accomplish the filtering passing this list? I havent found anything referring this so wondering if you have any guidance on this. cheers
I am not sure exactly what your are trying but I think this video is in the ballpark 😎
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,
I have over 1000 records to update (Patch All). This is running really slow. Is there a way to make it run faster or an alternative method I can use? And Thanks for all your videos. They are great help!
ForAll iterates over each record which makes it slow. You can pass Patch a table which has the potential to be processed all at once, which would be far quicker. I've not managed to get the syntax right and have asked for Shane's help above. I want to use it for something like updating the job description with the same new content for everyone with the title "Software Engineer".
I think passing the data to flow and the letting it do the long running work may be the best answer.
Great Job Shane! Please, do you have a content about How alternate selection between two checkboxes?
Hey Shane! Congrats to your videos! I need some help... How could I do to create a new column at my data source?
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.
Thanks for your video, straightforward and inspired, But can you explain more how can we identify the patched records to the others?
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?
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?
Lots of great stuff in one video! Thanks Shane!
Glad to help. 😀
Great video, but, how one add a "select all" to this solution, haven't been able to figure it out, thanks in advance.
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, 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.
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,
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.
Excellent video .. the checkbox option helped me a lot.
Glad to help. 😀
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! 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!
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,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 th-cam.com/video/nkp9MrBHN-s/w-d-xo.html
This was very helpful thank you
Glad it was helpful!
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?
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
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?
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)
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!
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 Shane! Your videos have helped me a lot lately, I have 0 experience with programming and code, but I have created and ap that actually works. I have a bounch of textboxes that are collected and then sent to an excel table source with the ForAll function in a button. Could it be possibe to sort the excel source table by the date column after the data is sent?
There is a SortByColumns function. I don't see why it wouldn't wokr. th-cam.com/video/7CpRC5AM_Is/w-d-xo.html
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
Great video. Love the pace.
Thanks 😊
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
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