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!
I don't know why but I still have troubles when I need to work with Collections. Therefore, I viewed this video again. It is very helpful and brings me a step further. Would be great if you made some new videos about collections. This one is 3 years old and there are more examples to explain the basics with collections. But for now thanks Shane!!
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.
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!
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
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!
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" :)
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, 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
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.
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
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.
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
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
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!!
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.
Shane Young Might because you are not using fancy slides and so, however they should understand that helps u to produce more and faster They have no clue how many hours we stay in front of the pc editing 2 hours vid to upload this good content, well done again Shane
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
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.
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...
Great video, as all of your's are. Special request, I am close on my own, but myself and others could probably benefit from your sage advice on how to create an app that uses external data sources, but will work offline. (Use collections to bring all the data into the app and also use SaveData and LoadData to store it into cache)
Same here, would to love to see how it all works offline. I am trying this myself at the moment. I have managed to get to the point where if the app is offline it saves the data to a collection but once online I need to then save that data back to a Sharepoint list.
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
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.
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.
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?
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.
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 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!!!
Great video...it's, indeed, very informative.. @Shane -. Can you plz make a video on the issue we experience while picking up DATE to edit form from Excel online (for business). The date picker simply goes blank and it doesn't pick up date from Excel table (date column) while other details from the table appear correctly. Any get around will help many of the people. I got the same issue posted by someone on powerplatform community but none of the answers fixed the issue..
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 ":"
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!
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!
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!
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!
Hey Shane - awesome video yet again. Have you got a video which shows how you would 'patch' or 'update' an external data source like an SP list using a Collection?
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! 😀
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 😊
Watching again after 2 years. Great how you don’t age Shane!
Thanks 😊 not sure it is true but 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 😀
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.
You are a good trainer Shane! Kudos!
Thank you
I don't know why but I still have troubles when I need to work with Collections. Therefore, I viewed this video again. It is very helpful and brings me a step further. Would be great if you made some new videos about collections. This one is 3 years old and there are more examples to explain the basics with collections. But for now thanks Shane!!
A new video on collections is a solid idea. :)
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 😍
Thanks for expediting my learning. Extremely good videos.
My pleasure!
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 just want to say thank you for all your videos. it helps me a lot in my projects.
Glad to help. 😀 you are welcome
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.
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 Shane, thanks. Appreciate the subtle humor too here and there :D
Glad you enjoyed it!
Always teaches me something I didn't know. Great Tutorials, Thanks
Glad to hear that!
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. 😊
Thank you Shane, your videos are very helpful
My pleasure!
Very helpful Shane.
Awesome
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!
Such an awesome teacher of Powerapps ! Many thanks for great tutorials . Keep up the great work :)
I will. Thanks
Great video! Thanks for getting to the point and explaining things clear.
Glad to help. 😀
Great Job Shane Young its very very use full for a beginner.Excellent explanation.
Thanks
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
Hi,Shane!Your Videos are very userful for me,and I am a newer to powerapps,Thanks a lot!
Glad to help. 😀
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.
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. 😀
Very Useful. Excellent work.
Glad it was helpful!
When I first heard your intro I hated the music, but now I just get excited for a good video, haha!
🤣😂🤣 Love it.
Very helpful and easy to learn video, many thanks, Subscribed !
Thanks for the sub!
there is a very nice teaching, it's very much practical; I believe, this video is helpful for more people! Great!
Thanks
This was really helpful and easy to follow. Thank you!
Happy to help. Have a great day. 🐶
Great explanation of collections as always. Thank you very much.
My pleasure!
Thanks Shane! Great video! Very helpful!
Thanks 🙏
Big Thanks for all your Videos !!!!!!!You are Awsome
☺️☺️☺️
Your videos are awesome.
Thanks 🙏
Thank you so much Shane for your great videos!
Happy to help
Like your contributions a lot!
Thanks 🙏
Thanks for sharing!! loved the lesson :)
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!
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.
Thanks a lot for your videos!! Brilliantly explained as allways
Happy to help Jason
Your videos are amazing. Thank you for taking the time to make these. Thumbs up!
You are welcome.
Exactly what I wanted!
thanks in million shane! this really helps!
Glad to help. 😀
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
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
Fantastic 👏
Thank you! Cheers!
awesome Shane
Thanks 😊
Shane - love your videos! You make learning Power Apps fun! :-)
Thanks. 😊
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!
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 ;
Great Info!! Keep rocking
Thanks! Will do!
Thank you Shane! It was very good! Thumbs up!
You are welcome.
hi shane... as usual great video
Thanks 😊
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
Thank you sir, might God bless you and you knowledge.
So nice of you
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
thanks Shane great video
Glad you like it.
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.
Smart Presentation style...i like it. In Javanesse language is "Jos Tenan"
Thanks you! :)
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. 😔
Awesome!
Thanks 🙏
I have no clue from where those dislikes came from?!
great effort Shane!
Thanks. I just assume they pressed the wrong button. 😻
Shane Young
Might because you are not using fancy slides and so, however they should understand that helps u to produce more and faster
They have no clue how many hours we stay in front of the pc editing 2 hours vid to upload this good content, well done again Shane
Very helpful.. you are doing very good..
thank you very much.
Happy to help
@@ShanesCows
Can you add some video related to - Connect power apps to D365 & perform some crud operations on entity using connectors.
Awesome 👍 well explained
Thanks 🙏
Very nice.thanks
Most welcome
Hi Shane, Thank you for such a wonderful video. Need Clarity how to disable the Edit mode after saving the changes .
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
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 😀
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
Thats was really useful, fast and even funny video, thanks a lot!
Glad to help.
Power Explainer, you are. Thank you.
Thanks 😊
Great video, as all of your's are. Special request, I am close on my own, but myself and others could probably benefit from your sage advice on how to create an app that uses external data sources, but will work offline. (Use collections to bring all the data into the app and also use SaveData and LoadData to store it into cache)
You are the second person to ask for this. It is on the list but I haven't tried it yet. Hopefully one day. :) Thanks for the idea. -Shane
Same here, would to love to see how it all works offline. I am trying this myself at the moment. I have managed to get to the point where if the app is offline it saves the data to a collection but once online I need to then save that data back to a Sharepoint list.
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. :)
Love the videos :) learning PowerApps with you
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. :(
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.
Thanks
You are amazing
Really thanks
Happy to help. Have a great day. 🐶
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! 😊
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.
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 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}})
Great video...it's, indeed, very informative..
@Shane -. Can you plz make a video on the issue we experience while picking up DATE to edit form from Excel online (for business). The date picker simply goes blank and it doesn't pick up date from Excel table (date column) while other details from the table appear correctly.
Any get around will help many of the people. I got the same issue posted by someone on powerplatform community but none of the answers fixed the issue..
Love your video
Thanks 😀
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 =
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.
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
Great videos, helped me a lot! Thank you!!
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.
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
Very helpful! Thanks for great tutorials :)
Glad to help. 😀
So good video!
Thank you ☺️
Thank you sir.
Hey Shane - awesome video yet again. Have you got a video which shows how you would 'patch' or 'update' an external data source like an SP list using a Collection?