This was one of the first videos I watched as a total PowerApps n00b (I was building a uniform ordering app and used collections to compile the order). I have since (in less than a year) had two promotions and now build and train people in PowerApps, Flow, SharePoint sites and Power BI for a 5200 person State Government department in Australia - all thanks to finding your channel. You are in the 'for more training guides' section of every training session I deliver too. Thanks for being real, concise, practical, and not waffling on! Keep them coming! I still manage to learn new things :)
On the Save button i've reversed the Set(Edit, True) to Set(Edit, False). I'm sure you just forgot, but incase anyone else forgets to do that, it's a great idea. Your videos are great, I wouldn't be able to create PowerApps without them. I was a total noob last week and have created 3 apps since - thanks!
As a newcomer in PowerApps, I really are having great use of your videos. And in these crazy times, I do have some extra time at home, so why not learn something useful!
This video is really awesome. I can really understand very clearly, better watch this than read the manual book. Thank you shane. I hope give the wealthy and healthy for your family.
Hi Shane, Thank you so much for the video! I am new to PowerApps, but have learned so much from you by watching your videos every day. Your ability to explain the complex ideas is truly amazing! Yes, you are so awesome!!! Thanks again!
Hey, Just started your video series, and your videos are fantastic! Subscribed! Keep up the great work. And please don't worry about it when you make small errors on the videos, as they are also very helpful for learning! Thanks!
Thank you Shane for your fantastic video. You are the clearer trainer for ever for PowerApps and what it is complex become simple, thank to your suggestions
Hi Shane! this was awesome. i did one variation and added "Set(Edit,true)" to navigation arrow in gallery like "Select(Parent);Set(Edit,true)". Great job!
Hi Shane, I really like how concise are your videos. Really practical for quick questions or doubts we have when we're creating apps. First video from yours I watch and instant subscribe. Keep it up!
Shane, I have a cool tool tip for you. Instead of hiding variables, set their X position to ScreenName.Width and the Y accordingly. That way users who are editing the app will see the variable.
Awesome presentation skill.. Liked specially for line "better not get ourselves in trouble ... don't wanna get in trouble as close to Valentine's day" :)
Dear Shane, I'm trying to find in your videos or google how to set a lookup with the Patch function. There is absolutely nothing on this topic on th eweb. Could you make a video or explain how to do that ? It is to set, i.e., the Account field of a Contact in Dynamics 365 CRM. An error returns "the type must be a Record" but the schema waited is a mystery. Thanks again.
Shane, Thanks for all your great videos. Can you guide on limitations around collections. Like how many collections can an app handle & how many items in single collection can there be. Considering the regular mobile phone capabilities.
Shane, really good material. I spent time looking for this type of content for PowerApps. Thanks I found you hahahha Thanks man! I'm just getting started. Your knowledge reach me here in Brazil
Collection function looks like shopping cart to me, but i'm not sure after this video. I will be great if you can elaborate on how to use this function, e.g. transfer the data in collection to CDS or Sharepoint List or workflow. Overall it's still super helpful, thanks for your wonderful video!
This video I show one of the ways to get data out of the collection and into your data source. ua-cam.com/video/MclJ_O9HvJQ/v-deo.html Also I think the ForAll video shows it more complicated, I think ua-cam.com/video/0xZ4fMJbLvk/v-deo.html
Hi Shane! Thanks for this informative video. Really helpful. I just had a doubt about whether this PowerApps collection has any item limit? Please let me know. Thanks!!
Shane, can you run more than one function on a button click?On Select of the button to Save, I'd like also to Save (Patch) the collection and switch the display move of the Grouped item back to View from Edit.Great show, just getting into PowerApps and the short snap approach works well for my aging brain cells.Keep up the good work.
Nice video. I am new to PowerApp and just think of asking this questions as I recently started using collections because of performance app considerations. - How to get the Auto ID of the row in the Collection? - Can I use just Collection function for a custom App I want to build lets say Customer and invoice app, instead of a external dbase like sharepoint or sql? - How many rows can collection capture? - When using collections, should I be concern about delegations issues? - What are the scenarios of using Collections
@@ShanesCows Thank you very much for your reply and it helps alot. But just one question, how to delete record from gallery loading from collection that is loading from sharepoint list onstart and reload to collection
Hello Shane, first of all many thanks for your effective presentations. They have often given me the necessary food for thought with my Powerapps problems. At the moment I have a problem that I can't get solved. I thought this video would help me, but somehow I'm stuck. I have a sharepoint list that contains all the computers in my company. I filter this list by my department and display it in a collection. I would like to include individual records from this collection in a form. Unfortunately, I cannot do this. Please excuse my inconvenience but my English is not that special. I hope you have some time.
Love your videos! They're very useful! Hey, if I quit on editing and wanto bring back the values set before (that are saved in the colletion) to the text fields, how can I do?
Thanks Shane for this videos they really help us A LOT!, one question, is it possible to add a field from another screen into a collection using Collect()?; it's a shopping cart that needs to specify delivery destination and that data is added on the first screen before collecting data on the details screen of each sku... thaks again in advance. cheers from Chile!
You are just awesome.... I really like the way you explain different topics... Can you please plan to work on few videos for common data service or Dynamics365 application... I am looking for solution where I want to show activities or opportunities of all child/grandchild accounts under parent/grandparent account.. Does Canvas app supports looping across records present in collections? Any reference material will be much appreciated.. Thanks...
Hey Shane, have things changed regarding Patching a record in a Collection since you made this video? When I follow these steps my Patch actually Adds a Record! I have to do a Lookup in the Patch function to find the Record, and then it will Patch. Is it just me? Thanks mate.
Hi Dave - Ran into the same issue myself today. Take a look at the comment from Prabir Choudhury from about a week ago. He replied to his comment with a solution that worked for me. Good luck!
great video. Have you discovered a way to use forms with collections? The collection shows up as an option for the datasource but it doesn't recognize it when trying to add fields. It looks like powerapps doesn't support this functionality yet. What I've actually tried doing is setting the data source to my sql table, adding fields, and then switching back to the collection, which is basically a copy of the sql table. I'm using the collection to store the records on start so I don't have to make frequent calls to the database. It's a shame forms can't officially be used with collections w/o a work around.
One of MANY great videos! This helped me greatly! I'm trying to go one step further in the Collection area. I have a form for requesting Exchange resources. These resources have multiple security groups. Most of them will have the same users in each security group. Others will have some but not all. What I want to do, is have the user have an option to click a button to copy the users from say fullAccessCollection to sendasCollection. Then they will have the option to edit the sendascollection to add or remove more users. I'm trying to make the User Experience as simple as possible to speed up the process of filling out the forms. I can have up to 7 security groups with some having duplicate data. I've scoured the web but haven't found much of anything addressing this possibility. Any suggestions you give would be appreciated!!!
Not sure Matt I haven’t done much there. My first thought is a gallery. Maybe look at my video on Duplicates to help you understand how to compare tables b
Hey Shane! Your videso are very easy to follow! Thanks so much! I have a question: Is it possibile to a Sharepoint list that contains a column "stakeholders" which is a type Choice, multiple choices allowed, modifiable? In powerapps someone is able to type out a new stakeholder and is it possible to update and add this new item to a the sharepont list choices?
It is. SharePoint will let you patch in a choice that isn't in the current list. I have done it messing around without issue but not sure how it plays out. Use this video patch in the value. ua-cam.com/video/gsk14D-CYRE/v-deo.html I have this on my list of videos to make in the future.
hi Shane, how do you use Collect on a Multi-Choice combobox, so my collect will gather the multiple selection from a combobox as a table? I watched this video and the Patch video and can't get it to work! Thanks, awesome video!
Hi Shane your videos are very much informative. I need a help. I am totally new to Powerapps. I want to add the picture to the sharepoint list with other list column data in the same form and user will have a remove button too to change the picture again. So basically in new form user would be able to add the photo(from gallery) and then could change it in edit form and would be able to see in the view form.
Hey Shane, in some of your previous videos you mentioned "=" is actually ":" in PowerApps. But in this video, ~18:55 ,you use the formula If(Edit = true, DisplayMode.Edit, DisplayMode,View)....wondering why sometimes PowerApps likes the "=" and others it only accepts the ":"
Quick question. I've got a gallery showing data that I want to filter by a the value in a column of a collection. Like only show items #2, #4,#5,#12. I'm banging my head trying to figure out how to make that work. I can filter the gallery by a single value just fine, but making it only show specific items... Thanks for all the great videos, I've learned so much from them.
Hello Shane I have a question, I have a table in which one field is another collect, how can I patch that table that is inside another, thanks for the help, excellent channel!!!
Hi Shane thank you for doing these videos. Have you covered Auto Generating an ID? I would like each new record to auto-populate an ID based on the last ID in Excel.
I haven't..... My first thought is to use the Last function to get the last record in the Excel and then just make your new ID something like Sum(LastRecordID, 1) probably easier way but that is first thought I have. Hope it helps.
Hello, Shane Thanks for the video it's really helpful. Wondering if you can answer a question related to the collection. I want to remove items from a collection based on another collection. Not sure how to do this though. I tried RemoveIf and couldn't get it working. Basically what I want to do is to remove columns from my first collection if my fist collection's date column matches with my second collections's date column. Help will be really appreciated. Been stuck with this last couple days. Thanks.
1 hour after I posted this comment I found a solution for this. Just commenting here if anyone else is looking for this. ForAll(colSubmitted, RemoveIf( colSaturdays, Date = submittedDate )) here it will remove all columns from colSaturdays collection where Date column in colSaturdays match with submittedDate column in colSubmitted.
Hey Shane, Thanks for the video and all the other ones you put out, they really help me out. I have a question about how collections are stored in memory and I was hoping maybe you could shed some light on this. For instance, if I were to create an web store in powers apps, and I wanted to create a collection of selected products to populate a gallery, how long does a collection stay in memory and who will have access to it. I would want to make this site publicly facing, with the customers not having any unique identifier or set permissions for them. Thanks, Chris Benoit
Collections are just there for the user who is running the app. If you want to have more permanent data then store you items in a data source, like SharePoint or SQL.
Hello, Shane. The trainings are very useful but I have a question. You have grouped the Item Details field and set it as DisplayMode View. Then you made it editable with the help of an icon. How can we return DisplayMode.View again after editing is done?
Hi Shane, is there a way to have more "rows" than just title, subtitle and body (with no images) in a gallery? If I want the users to be able to edit more than 3 fields? thank you by the way for the awesome content, I'm new to powerapps and a big fan of your viedos !
Shane, I’m just starting to learn power apps, thanks for your videos, they’re awesome. The issue I’m having whilst putting this demo together. When I put the second lot of labels in at the bottom and group them, then apply the patch, rather than editing an existing record, it adds a new record, rather than editing the existing one in the gallery?
Hi Shane, thanks for the video, can you also please let us know how we can store values into CRM on submit (for Ex:- lead creation , i have few text boxes on view , on click of submit , data should go to CRM)
Shane Young that's how I've done it as well and it works very well in the collection however in the gallery when a new line is created it keeps the date chosen in the previous line meaning it doesn't clear the date fields, if it's as per design then it's fine it's not a biggy, it's just that our users in many instances they don't change the defaults maybe it will have to be a training issue from our side.....thank you
hi shane, i watched you video, that so usefull. but i have some question, how i can save the items of the collection into datasource( i mean Sharepoint list). thanks a lot for help
Hi Shane, hope it finds you well, I just started working in power apps and following your methods which are amazing, suddenly I faced an issue while updating my sql table records from power apps through patch function. The error is 'the formula has side effects and can not be evaluated', can you give some idea how to debug. I can explain more if you want. Hope to get a quick reply as I'm in the middle of a development activity
The text field did not change when you selected different records because you set the default property of the text box to the gallery info. Default only works as the first one. If you change the text of a box, it does not change again
This is a very nice video. Just discovered it. Do you know or do you know how can I export / imports those collections into a SharePoint List? Many thanks.
Collect(SharePointList, CollectionName) will work if the columns match. I am pretty sure I cover it in this video. ua-cam.com/video/MclJ_O9HvJQ/v-deo.html And this video gets deeper in the weeds. ua-cam.com/video/nkp9MrBHN-s/v-deo.html
Hello Shane. I have started to use powerapps and I have started to see all your videos since those are the best one I have seen so far! Congrats for the good work and keep it up!!! One question: I have done a draft app when the first step is to download the data from a onedrive folder, and don't have any problems with it since the default connection handles it pretty good, however when I run the app in Microsoft Teams the data is not uploaded. I have tried to execute the collection both "On Start" and on the "Visible" of the first screen but none of them have worked... Do you have any suggestion? I don't want to use a button to trigger the data to be downloaded. Thank you again!
Good afternoon. Sorry for the translation ... Very good tutorials !! This is what I need. it remains to know how to save the data in an excel database. Can you explain it? Greetings from Argentina! Thanks a lot. Leonardo
Hi Shane, thanks for making this so easy to understand! I'm trying to create an app that tracks some items for home improvements - dates for tiling, painting etc. So I have a screen with some cards in it, one for each stage. I'd like to then collect each of them on a separate line and then patch to be stored at the end, but can't figure out how to make that happen? So it would have columns for QuoteID, Stage, StartDate, EndDate, where stage refers to what's happening (painting, tiling etc). I'm also wondering how best to update records as well - if a date changes, and the quote is opened up again, how to collect that information and then when patching back how to overwrite the original record?
Hi Shane. Great video. How would this work if you're trying to patch multiple items? I created a checkbox and I want the data inputted on the text input to update everything identified with a checkbox.
Hi Shane, I want to build a line chart in powerapps but It seems to be that bowerapps doesn't has many useful options supporting that. Can you make a video for building charts in powerapps?
Can you make this same setup work with checkboxes? For example...have a gallery of items and go through and check some of them and the status is changed on just the selected items? I loathe checkboxes but have a project where it is what I am needing.
Yes. It is a lot harder than it should be though. What I usually do is put the data for the gallery in a collection. Then have the check box OnChange update the collection. Then process the collection.
Hi Shane! Let´s say a have the the source data in a sharepoint list. A person in the company needs to add records and sometimes edit this data every day with this powerapp app. Does it make sense to use collection in this situation?
Dear Shane, how do I relate collections to Excel spreadsheets for example? I would like to be able to pass this information to somebody and preferably on excel. Thanks for the videos, they are truly awesome and easy to follow.
Shane Young hey ! Thank you for taking the time to write me. I think I am not clear with how “patch” works. As far as I know or understand, “collection” ‘s informations stays saved in the app and it is not “connected” to any data source like an excel sheet for example. How the saved scanned codes are saved in some sort of datasource ? My app is a simple inventory tracker for the tools everyone uses.
Hey, Shane...I know this is a super-old video, and I thought you had more recent ones about collections but couldn't find any. Basically, I've found that a bunch of folks out there misuse/abuse collections to do things they probably shouldn't (like loading thousands of rows from a data source to get around delegation warnings and ending up with bloated, poorly performing apps). I'm wondering if you do have another video along those lines or have another resource I can point those folks to?
I have talked about Collections but not dedicated video. :( I will add it to my list to redo. Thanks for the idea. I am with you. I hate seeing Collection abuse.
Updated version April 2023 ua-cam.com/video/4zM-Oyhpc3U/v-deo.html 🤩🤩
This was one of the first videos I watched as a total PowerApps n00b (I was building a uniform ordering app and used collections to compile the order). I have since (in less than a year) had two promotions and now build and train people in PowerApps, Flow, SharePoint sites and Power BI for a 5200 person State Government department in Australia - all thanks to finding your channel. You are in the 'for more training guides' section of every training session I deliver too. Thanks for being real, concise, practical, and not waffling on! Keep them coming! I still manage to learn new things :)
Thank you for sharing this. It means a lot. 😀
On the Save button i've reversed the Set(Edit, True) to Set(Edit, False). I'm sure you just forgot, but incase anyone else forgets to do that, it's a great idea.
Your videos are great, I wouldn't be able to create PowerApps without them. I was a total noob last week and have created 3 apps since - thanks!
Thanks for that!
As a newcomer in PowerApps, I really are having great use of your videos. And in these crazy times, I do have some extra time at home, so why not learn something useful!
Love it! 😀
Great video Shane, thanks. Appreciate the subtle humor too here and there :D
Glad you enjoyed it!
shane Young, your tutorial is better than the course I purchased from Udemy! Cheers!
Thank you. Please check out training.powerapps911.com for some of my courses. 😻
This video is really awesome. I can really understand very clearly, better watch this than read the manual book. Thank you shane. I hope give the wealthy and healthy for your family.
Thanks 😊
Shane wonderful job! Within a week of watching your series, I’ve began my adventure into the PowerApps world!!! Keep them coming :)
I will. You keep learning 😀
Watching again after 2 years. Great how you don’t age Shane!
Thanks 😊 not sure it is true but thanks 😊
You are a good trainer Shane! Kudos!
Thank you
Hi Shane, i just want to say thank you for all your videos. it helps me a lot in my projects.
Glad to help. 😀 you are welcome
Serious talk my man. You are awesome. This is great work. In as little as 3 days, I have gone from zero to hero. Keep up the great work.
Thanks! Keep kicking butt!
Thank you very much! You are very clear and you do everything step by step. Everyone up to the Spanish speakers like me, we understand you perfectly!
Glad to help. 😀
Hi Shane, Thank you so much for the video! I am new to PowerApps, but have learned so much from you by watching your videos every day. Your ability to explain the complex ideas is truly amazing! Yes, you are so awesome!!! Thanks again!
Thank you very much. These comments keep me making content.
I really enjoy these videos! Thank you for being so thorough. I hope to see more
I have over 100 so I got you covered. 😀
Hey, Just started your video series, and your videos are fantastic! Subscribed! Keep up the great work. And please don't worry about it when you make small errors on the videos, as they are also very helpful for learning! Thanks!
Thanks and thanks!
Great video! Thanks for getting to the point and explaining things clear.
Glad to help. 😀
Thank you Shane for your fantastic video. You are the clearer trainer for ever for PowerApps and what it is complex become simple, thank to your suggestions
Glad to help. 😀 And thanks for the kind words.
Such an awesome teacher of Powerapps ! Many thanks for great tutorials . Keep up the great work :)
I will. Thanks
This was really helpful and easy to follow. Thank you!
Happy to help. Have a great day. 🐶
Great Job Shane Young its very very use full for a beginner.Excellent explanation.
Thanks
Shane you are really Awesome. You are doing a great work to make people like us reaching to next level in PowerApps. Thanks for all the help.
I appreciate that!
Hi Shane! this was awesome. i did one variation and added "Set(Edit,true)" to navigation arrow in gallery like
"Select(Parent);Set(Edit,true)". Great job!
Cool. Glad it is working for you. :)
Hi Shane, I really like how concise are your videos. Really practical for quick questions or doubts we have when we're creating apps. First video from yours I watch and instant subscribe. Keep it up!
Awesome
Shane, I have a cool tool tip for you. Instead of hiding variables, set their X position to ScreenName.Width and the Y accordingly. That way users who are editing the app will see the variable.
Fancy Kelly. Thanks for sharing 😍
Awesome presentation skill.. Liked specially for line "better not get ourselves in trouble ... don't wanna get in trouble as close to Valentine's day" :)
Thanks 😊
You are welcome sir. I am addicted to ur courses. Please let me know if you have courses for SPFx as well. 😊
Thanks for expediting my learning. Extremely good videos.
My pleasure!
Thank you Shane, your videos are very helpful
My pleasure!
Thank you so much Shane for your great videos!
Happy to help
When I first heard your intro I hated the music, but now I just get excited for a good video, haha!
🤣😂🤣 Love it.
Always teaches me something I didn't know. Great Tutorials, Thanks
Glad to hear that!
there is a very nice teaching, it's very much practical; I believe, this video is helpful for more people! Great!
Thanks
Your videos are amazing. Thank you for taking the time to make these. Thumbs up!
You are welcome.
Thanks for sharing!! loved the lesson :)
You are welcome 🙏
Thanks Shane! Great video! Very helpful!
Thanks 🙏
Very helpful and easy to learn video, many thanks, Subscribed !
Thanks for the sub!
Thanks a lot for your videos!! Brilliantly explained as allways
Happy to help Jason
Great explanation of collections as always. Thank you very much.
My pleasure!
Exactly what I wanted!
thanks in million shane! this really helps!
Glad to help. 😀
Hi，Shane!Your Videos are very userful for me,and I am a newer to powerapps,Thanks a lot!
Glad to help. 😀
Big Thanks for all your Videos !!!!!!!You are Awsome
☺️☺️☺️
Thank you for your content Shane.
You are welcome 🙏
Dear Shane, I'm trying to find in your videos or google how to set a lookup with the Patch function. There is absolutely nothing on this topic on th eweb. Could you make a video or explain how to do that ? It is to set, i.e., the Account field of a Contact in Dynamics 365 CRM. An error returns "the type must be a Record" but the schema waited is a mystery. Thanks again.
hmmm finally I'd figured out. You need to patch the virtual fields _value and _type of a lookup.
Shane,
Thanks for all your great videos.
Can you guide on limitations around collections. Like how many collections can an app handle & how many items in single collection can there be. Considering the regular mobile phone capabilities.
There are not any hard limits, the answers are all just "it depends" on your device, your data, and how you are using the collection.
@@ShanesCows thanks.
Its working fine with 4 collections of 300+ records having 10 items each.
Like your contributions a lot!
Thanks 🙏
Thank you Shane! It was very good! Thumbs up!
You are welcome.
Shane, really good material. I spent time looking for this type of content for PowerApps. Thanks I found you hahahha Thanks man! I'm just getting started.
Your knowledge reach me here in Brazil
Awesome Sergio!
So helpful and answered all my current questions!
Awesome! Thanks for sharing.
Thanks for your vids! They've been a big help.
You are welcome Danny!
Great work, Shane! Your presentation has saved me much work and brought me one step futher in doing things the PowerApps way. :)
I like it Mike. Thanks
Collection function looks like shopping cart to me, but i'm not sure after this video. I will be great if you can elaborate on how to use this function, e.g. transfer the data in collection to CDS or Sharepoint List or workflow. Overall it's still super helpful, thanks for your wonderful video!
This video I show one of the ways to get data out of the collection and into your data source. ua-cam.com/video/MclJ_O9HvJQ/v-deo.html Also I think the ForAll video shows it more complicated, I think ua-cam.com/video/0xZ4fMJbLvk/v-deo.html
Hi Shane! Thanks for this informative video. Really helpful. I just had a doubt about whether this PowerApps collection has any item limit? Please let me know. Thanks!!
Not really. But the larger the collection the more stuff you have in memory the more likely you are to cause performance issues.
Great Info!! Keep rocking
Thanks! Will do!
Shane, can you run more than one function on a button click?On Select of the button to Save, I'd like also to Save (Patch) the collection and switch the display move of the Grouped item back to View from Edit.Great show, just getting into PowerApps and the short snap approach works well for my aging brain cells.Keep up the good work.
Yes separate the two functions by a ;
Very Useful. Excellent work.
Glad it was helpful!
Nice video. I am new to PowerApp and just think of asking this questions as I recently started using collections because of performance app considerations.
- How to get the Auto ID of the row in the Collection?
- Can I use just Collection function for a custom App I want to build lets say Customer and invoice app, instead of a external dbase like sharepoint or sql?
- How many rows can collection capture?
- When using collections, should I be concern about delegations issues?
- What are the scenarios of using Collections
There isn’t an auto id. Collections are temporary so if you want to keep the data thenyou need a data source.
@@ShanesCows Thank you very much for your reply and it helps alot. But just one question, how to delete record from gallery loading from collection that is loading from sharepoint list onstart and reload to collection
Very helpful Shane.
Awesome
Hello Shane, first of all many thanks for your effective presentations. They have often given me the necessary food for thought with my Powerapps problems.
At the moment I have a problem that I can't get solved. I thought this video would help me, but somehow I'm stuck.
I have a sharepoint list that contains all the computers in my company. I filter this list by my department and display it in a collection. I would like to include individual records from this collection in a form. Unfortunately, I cannot do this.
Please excuse my inconvenience but my English is not that special. I hope you have some time.
You cannot use Forms with collections. 😔
Shane - love your videos! You make learning Power Apps fun! :-)
Thanks. 😊
Love your videos! They're very useful!
Hey, if I quit on editing and wanto bring back the values set before (that are saved in the colletion) to the text fields, how can I do?
If you Reset(ControlName) that will set the control back to its default value.
@@ShanesCows gracias! 😊
Your videos are awesome.
Thanks 🙏
Hi Shane, Thank you for such a wonderful video. Need Clarity how to disable the Edit mode after saving the changes .
hi shane... as usual great video
Thanks 😊
Thanks Shane for this videos they really help us A LOT!, one question, is it possible to add a field from another screen into a collection using Collect()?; it's a shopping cart that needs to specify delivery destination and that data is added on the first screen before collecting data on the details screen of each sku... thaks again in advance. cheers from Chile!
Yes. You reference controls (fields) the same regardless if they are the same screen or not.
You are just awesome.... I really like the way you explain different topics... Can you please plan to work on few videos for common data service or Dynamics365 application... I am looking for solution where I want to show activities or opportunities of all child/grandchild accounts under parent/grandparent account.. Does Canvas app supports looping across records present in collections? Any reference material will be much appreciated.. Thanks...
Yes I need to do CDS. And ForAll is the way to loop through a collection
Hey Shane, have things changed regarding Patching a record in a Collection since you made this video? When I follow these steps my Patch actually Adds a Record! I have to do a Lookup in the Patch function to find the Record, and then it will Patch. Is it just me? Thanks mate.
Hi Dave - Ran into the same issue myself today. Take a look at the comment from Prabir Choudhury from about a week ago. He replied to his comment with a solution that worked for me. Good luck!
I do think they messed up something if you don't have a Key defined in the collection. 😑 Check the comment below for ideas.
Thanks Tom!
@@ThomasSMcNamara thanks Tom, I'll check out the solution.
great video. Have you discovered a way to use forms with collections? The collection shows up as an option for the datasource but it doesn't recognize it when trying to add fields. It looks like powerapps doesn't support this functionality yet. What I've actually tried doing is setting the data source to my sql table, adding fields, and then switching back to the collection, which is basically a copy of the sql table. I'm using the collection to store the records on start so I don't have to make frequent calls to the database. It's a shame forms can't officially be used with collections w/o a work around.
Yup, no collections and forms. :(
One of MANY great videos! This helped me greatly!
I'm trying to go one step further in the Collection area. I have a form for requesting Exchange resources. These resources have multiple security groups. Most of them will have the same users in each security group. Others will have some but not all.
What I want to do, is have the user have an option to click a button to copy the users from say fullAccessCollection to sendasCollection. Then they will have the option to edit the sendascollection to add or remove more users. I'm trying to make the User Experience as simple as possible to speed up the process of filling out the forms. I can have up to 7 security groups with some having duplicate data. I've scoured the web but haven't found much of anything addressing this possibility. Any suggestions you give would be appreciated!!!
Not sure Matt I haven’t done much there. My first thought is a gallery. Maybe look at my video on Duplicates to help you understand how to compare tables b
Hey Shane! Your videso are very easy to follow! Thanks so much! I have a question: Is it possibile to a Sharepoint list that contains a column "stakeholders" which is a type Choice, multiple choices allowed, modifiable? In powerapps someone is able to type out a new stakeholder and is it possible to update and add this new item to a the sharepont list choices?
It is. SharePoint will let you patch in a choice that isn't in the current list. I have done it messing around without issue but not sure how it plays out. Use this video patch in the value. ua-cam.com/video/gsk14D-CYRE/v-deo.html I have this on my list of videos to make in the future.
Love the videos :) learning PowerApps with you
hi Shane, how do you use Collect on a Multi-Choice combobox, so my collect will gather the multiple selection from a combobox as a table? I watched this video and the Patch video and can't get it to work! Thanks, awesome video!
Collect(yourCollection, combobox.selecteditems) should work
Hi Shane your videos are very much informative. I need a help. I am totally new to Powerapps. I want to add the picture to the sharepoint list with other list column data in the same form and user will have a remove button too to change the picture again. So basically in new form user would be able to add the photo(from gallery) and then could change it in edit form and would be able to see in the view form.
If you want to use a form then you will need to do it as attachments.
Hey Shane, in some of your previous videos you mentioned "=" is actually ":" in PowerApps. But in this video, ~18:55 ,you use the formula If(Edit = true, DisplayMode.Edit, DisplayMode,View)....wondering why sometimes PowerApps likes the "=" and others it only accepts the ":"
They like to keep us guessing. 😀 : means equal only with update context and patch/record stuff I think. If you always use =
Quick question. I've got a gallery showing data that I want to filter by a the value in a column of a collection. Like only show items #2, #4,#5,#12. I'm banging my head trying to figure out how to make that work. I can filter the gallery by a single value just fine, but making it only show specific items...
Thanks for all the great videos, I've learned so much from them.
Look into the in operator. It is possible 😀
Hello Shane I have a question, I have a table in which one field is another collect, how can I patch that table that is inside another, thanks for the help, excellent channel!!!
It is possible but tricky. Something like Patch(collection, RecordToPatch, {FieldToPatch: {RecordFieldInsideTheField: ValueYouWantToSave}})
Hi Shane thank you for doing these videos. Have you covered Auto Generating an ID? I would like each new record to auto-populate an ID based on the last ID in Excel.
I haven't..... My first thought is to use the Last function to get the last record in the Excel and then just make your new ID something like Sum(LastRecordID, 1) probably easier way but that is first thought I have. Hope it helps.
Hello, Shane Thanks for the video it's really helpful. Wondering if you can answer a question related to the collection. I want to remove items from a collection based on another collection. Not sure how to do this though. I tried RemoveIf and couldn't get it working. Basically what I want to do is to remove columns from my first collection if my fist collection's date column matches with my second collections's date column. Help will be really appreciated. Been stuck with this last couple days. Thanks.
1 hour after I posted this comment I found a solution for this. Just commenting here if anyone else is looking for this.
ForAll(colSubmitted, RemoveIf(
colSaturdays,
Date = submittedDate ))
here it will remove all columns from colSaturdays collection where Date column in colSaturdays match with submittedDate column in colSubmitted.
Awesome
Hey Shane,
Thanks for the video and all the other ones you put out, they really help me out. I have a question about how collections are stored in memory and I was hoping maybe you could shed some light on this. For instance, if I were to create an web store in powers apps, and I wanted to create a collection of selected products to populate a gallery, how long does a collection stay in memory and who will have access to it. I would want to make this site publicly facing, with the customers not having any unique identifier or set permissions for them.
Thanks,
Chris Benoit
Collections are just there for the user who is running the app. If you want to have more permanent data then store you items in a data source, like SharePoint or SQL.
Hello, Shane. The trainings are very useful but I have a question. You have grouped the Item Details field and set it as DisplayMode View. Then you made it editable with the help of an icon. How can we return DisplayMode.View again after editing is done?
Hello, I found out how. Thank you for your videos.
Glad you got it.
Hi Shane, is there a way to have more "rows" than just title, subtitle and body (with no images) in a gallery? If I want the users to be able to edit more than 3 fields? thank you by the way for the awesome content, I'm new to powerapps and a big fan of your viedos !
Yes you can! Edit your gallery and you can insert a label or any other control.
Shane, I’m just starting to learn power apps, thanks for your videos, they’re awesome. The issue I’m having whilst putting this demo together. When I put the second lot of labels in at the bottom and group them, then apply the patch, rather than editing an existing record, it adds a new record, rather than editing the existing one in the gallery?
Maybe this video will help. ua-cam.com/video/MclJ_O9HvJQ/v-deo.html
Hi Shane, thanks for the video, can you also please let us know how we can store values into CRM on submit (for Ex:- lead creation , i have few text boxes on view , on click of submit , data should go to CRM)
It shouldn’t be any different. Just need to know the field names
Hi Shane, thank you very much for the video. Can you please assist. I'm strggling with the date picker, how do I ClearCollect the date picker field?
ClearCollect(colDates, {chosenDate: datepicker.SelectedDate})
Shane Young that's how I've done it as well and it works very well in the collection however in the gallery when a new line is created it keeps the date chosen in the previous line meaning it doesn't clear the date fields, if it's as per design then it's fine it's not a biggy, it's just that our users in many instances they don't change the defaults maybe it will have to be a training issue from our side.....thank you
hi shane, i watched you video, that so usefull. but i have some question, how i can save the items of the collection into datasource( i mean Sharepoint list). thanks a lot for help
Look for my video on save data. It is Halloween themed but should work.
Hi Shane, hope it finds you well, I just started working in power apps and following your methods which are amazing, suddenly I faced an issue while updating my sql table records from power apps through patch function. The error is 'the formula has side effects and can not be evaluated', can you give some idea how to debug. I can explain more if you want. Hope to get a quick reply as I'm in the middle of a development activity
That isn’t an error that is just the preview tool telling you it can’t preview that data
Thats was really useful, fast and even funny video, thanks a lot!
Glad to help.
The text field did not change when you selected different records because you set the default property of the text box to the gallery info. Default only works as the first one. If you change the text of a box, it does not change again
Whoops. Thanks for that. Sometimes I get caught up in making the recording and miss the little things. :)
This is a very nice video. Just discovered it. Do you know or do you know how can I export / imports those collections into a SharePoint List?
Many thanks.
Collect(SharePointList, CollectionName) will work if the columns match. I am pretty sure I cover it in this video. ua-cam.com/video/MclJ_O9HvJQ/v-deo.html And this video gets deeper in the weeds. ua-cam.com/video/nkp9MrBHN-s/v-deo.html
Hello Shane.
I have started to use powerapps and I have started to see all your videos since those are the best one I have seen so far! Congrats for the good work and keep it up!!!
One question: I have done a draft app when the first step is to download the data from a onedrive folder, and don't have any problems with it since the default connection handles it pretty good, however when I run the app in Microsoft Teams the data is not uploaded. I have tried to execute the collection both "On Start" and on the "Visible" of the first screen but none of them have worked... Do you have any suggestion? I don't want to use a button to trigger the data to be downloaded.
Thank you again!
I have not seen OnStart not work. Sorry
Good afternoon. Sorry for the translation ... Very good tutorials !!
This is what I need. it remains to know how to save the data in an excel database. Can you explain it? Greetings from Argentina! Thanks a lot. Leonardo
Add Excel as a datasource. Makes sure the Excel file has a table. Maybe this helps? ua-cam.com/video/-Z_13J02RPU/v-deo.html
Smart Presentation style...i like it. In Javanesse language is "Jos Tenan"
Thanks you! :)
Hi Shane, thanks for making this so easy to understand! I'm trying to create an app that tracks some items for home improvements - dates for tiling, painting etc. So I have a screen with some cards in it, one for each stage. I'd like to then collect each of them on a separate line and then patch to be stored at the end, but can't figure out how to make that happen?
So it would have columns for QuoteID, Stage, StartDate, EndDate, where stage refers to what's happening (painting, tiling etc).
I'm also wondering how best to update records as well - if a date changes, and the quote is opened up again, how to collect that information and then when patching back how to overwrite the original record?
Watch this video on patching. PowerApps Save Data - Patch, Collect, and ForAll ua-cam.com/video/MclJ_O9HvJQ/v-deo.html hopefully it helps.
Hi Shane. Great video. How would this work if you're trying to patch multiple items? I created a checkbox and I want the data inputted on the text input to update everything identified with a checkbox.
ForAll function
Hi Shane, I want to build a line chart in powerapps but It seems to be that bowerapps doesn't has many useful options supporting that.
Can you make a video for building charts in powerapps?
I should. The problem is I don’t do it often so you might know more than I do.
Can you make this same setup work with checkboxes? For example...have a gallery of items and go through and check some of them and the status is changed on just the selected items? I loathe checkboxes but have a project where it is what I am needing.
Yes. It is a lot harder than it should be though. What I usually do is put the data for the gallery in a collection. Then have the check box OnChange update the collection. Then process the collection.
Great videos, helped me a lot! Thank you!!
Thanks 🙏
Very helpful! Thanks for great tutorials :)
Glad to help. 😀
Hi Shane!
Let´s say a have the the source data in a sharepoint list. A person in the company needs to add records and sometimes edit this data every day with this powerapp app. Does it make sense to use collection in this situation?
Without knowing more I would say probably a collection is not needed.
Dear Shane, how do I relate collections to Excel spreadsheets for example? I would like to be able to pass this information to somebody and preferably on excel. Thanks for the videos, they are truly awesome and easy to follow.
I think you just need to patch it back. Unless I am missing what you need to do?
Shane Young hey ! Thank you for taking the time to write me. I think I am not clear with how “patch” works. As far as I know or understand, “collection” ‘s informations stays saved in the app and it is not “connected” to any data source like an excel sheet for example. How the saved scanned codes are saved in some sort of datasource ? My app is a simple inventory tracker for the tools everyone uses.
Maybe this video will help. ua-cam.com/video/MclJ_O9HvJQ/v-deo.html
Hey, Shane...I know this is a super-old video, and I thought you had more recent ones about collections but couldn't find any. Basically, I've found that a bunch of folks out there misuse/abuse collections to do things they probably shouldn't (like loading thousands of rows from a data source to get around delegation warnings and ending up with bloated, poorly performing apps). I'm wondering if you do have another video along those lines or have another resource I can point those folks to?
I have talked about Collections but not dedicated video. :( I will add it to my list to redo. Thanks for the idea.
I am with you. I hate seeing Collection abuse.
Is there a way to look through a collection and see if a certain text string exists within it and use that as a boolean value?
You could use the Search function to search a text column of the collection