Working with a PowerApps Collection - Check Description for new version

  Рет қаралды 323,282

Shane Young

Shane Young

Күн бұрын

🆕 New Video April 2023 • Power Apps Collections...
In this video, we learn about PowerApps collection. These are a special type of variable that allows you to collect a table worth of information as a variable. You can use it for things like creating a shopping cart.
Functions used:
* Collect
* ClearCollect
* Patch
* Remove
* ThisItem
* Gallery
Video on other types of PowerApps Variables
• Intro to PowerApps Var...
For information or PowerApps consulting check out www.PowerApps911.com

Пікірлер: 576
@ShanesCows
@ShanesCows Жыл бұрын
Updated version April 2023 kzfaq.info/get/bejne/auB9YLKqzdbHY4k.html 🤩🤩
@rachelharris8885
@rachelharris8885 5 жыл бұрын
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 :)
@ShanesCows
@ShanesCows 5 жыл бұрын
Thank you for sharing this. It means a lot. 😀
@Fearless0427
@Fearless0427 6 жыл бұрын
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!
@ShanesCows
@ShanesCows 6 жыл бұрын
Thank you very much. These comments keep me making content.
@sidneyerickson5951
@sidneyerickson5951 6 жыл бұрын
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!
@ShanesCows
@ShanesCows 6 жыл бұрын
Thanks and thanks!
@michaelperez1744
@michaelperez1744 4 жыл бұрын
Shane wonderful job! Within a week of watching your series, I’ve began my adventure into the PowerApps world!!! Keep them coming :)
@ShanesCows
@ShanesCows 4 жыл бұрын
I will. You keep learning 😀
@unilustredesconocido
@unilustredesconocido 5 жыл бұрын
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!
@ShanesCows
@ShanesCows 5 жыл бұрын
Glad to help. 😀
@frodounterberg1113
@frodounterberg1113 4 жыл бұрын
Love the videos :) learning PowerApps with you
@HelloMrMike
@HelloMrMike 6 жыл бұрын
Great work, Shane! Your presentation has saved me much work and brought me one step futher in doing things the PowerApps way. :)
@ShanesCows
@ShanesCows 6 жыл бұрын
I like it Mike. Thanks
@mercadomarcos
@mercadomarcos 6 жыл бұрын
Great video! Thanks for getting to the point and explaining things clear.
@ShanesCows
@ShanesCows 6 жыл бұрын
Glad to help. 😀
@djsinjin
@djsinjin 5 жыл бұрын
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.
@ShanesCows
@ShanesCows 5 жыл бұрын
Thanks! Keep kicking butt!
@Querinfer
@Querinfer 5 жыл бұрын
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!
@ShanesCows
@ShanesCows 5 жыл бұрын
Cool. Glad it is working for you. :)
@JGNiDK
@JGNiDK 4 жыл бұрын
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!
@ShanesCows
@ShanesCows 4 жыл бұрын
Love it! 😀
@jarodjenkins
@jarodjenkins 5 жыл бұрын
Your videos are amazing. Thank you for taking the time to make these. Thumbs up!
@ShanesCows
@ShanesCows 5 жыл бұрын
You are welcome.
@br31woodlands69
@br31woodlands69 4 жыл бұрын
Watching again after 2 years. Great how you don’t age Shane!
@ShanesCows
@ShanesCows 4 жыл бұрын
Thanks 😊 not sure it is true but thanks 😊
@pankajverma29007
@pankajverma29007 4 жыл бұрын
Such an awesome teacher of Powerapps ! Many thanks for great tutorials . Keep up the great work :)
@ShanesCows
@ShanesCows 4 жыл бұрын
I will. Thanks
@fabiorondini5810
@fabiorondini5810 5 жыл бұрын
Thank you Shane! It was very good! Thumbs up!
@ShanesCows
@ShanesCows 5 жыл бұрын
You are welcome.
@tenisviejos
@tenisviejos 5 жыл бұрын
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!
@ShanesCows
@ShanesCows 5 жыл бұрын
Awesome
@RGFWZ
@RGFWZ 5 жыл бұрын
Thank you so much Shane for your great videos!
@ShanesCows
@ShanesCows 5 жыл бұрын
Happy to help
@thatpowerappsguy
@thatpowerappsguy Жыл бұрын
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!
@ShanesCows
@ShanesCows Жыл бұрын
Thanks for that!
@handouble2796
@handouble2796 4 жыл бұрын
Hi Shane, i just want to say thank you for all your videos. it helps me a lot in my projects.
@ShanesCows
@ShanesCows 4 жыл бұрын
Glad to help. 😀 you are welcome
@sconsalter
@sconsalter 4 жыл бұрын
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
@ShanesCows
@ShanesCows 4 жыл бұрын
Awesome Sergio!
@potterfreak63
@potterfreak63 3 жыл бұрын
I really enjoy these videos! Thank you for being so thorough. I hope to see more
@ShanesCows
@ShanesCows 3 жыл бұрын
I have over 100 so I got you covered. 😀
@hi_vishy
@hi_vishy Жыл бұрын
Thanks for expediting my learning. Extremely good videos.
@ShanesCows
@ShanesCows Жыл бұрын
My pleasure!
@NicatBehbudov
@NicatBehbudov Жыл бұрын
Great video Shane, thanks. Appreciate the subtle humor too here and there :D
@ShanesCows
@ShanesCows Жыл бұрын
Glad you enjoyed it!
@ArevikPoladian
@ArevikPoladian 5 жыл бұрын
Very helpful! Thanks for great tutorials :)
@ShanesCows
@ShanesCows 5 жыл бұрын
Glad to help. 😀
@StephanOnisick
@StephanOnisick Жыл бұрын
Always teaches me something I didn't know. Great Tutorials, Thanks
@ShanesCows
@ShanesCows Жыл бұрын
Glad to hear that!
@Jasonmadcow666
@Jasonmadcow666 5 жыл бұрын
Thanks a lot for your videos!! Brilliantly explained as allways
@ShanesCows
@ShanesCows 5 жыл бұрын
Happy to help Jason
@RACHIMSAJA
@RACHIMSAJA 3 жыл бұрын
Exactly what I wanted! thanks in million shane! this really helps!
@ShanesCows
@ShanesCows 3 жыл бұрын
Glad to help. 😀
@jackbeyant9116
@jackbeyant9116 4 жыл бұрын
Hi,Shane!Your Videos are very userful for me,and I am a newer to powerapps,Thanks a lot!
@ShanesCows
@ShanesCows 4 жыл бұрын
Glad to help. 😀
@MaicaLRM
@MaicaLRM 6 жыл бұрын
So helpful and answered all my current questions!
@ShanesCows
@ShanesCows 6 жыл бұрын
Awesome! Thanks for sharing.
@MortgageConsultancy2005
@MortgageConsultancy2005 4 жыл бұрын
shane Young, your tutorial is better than the course I purchased from Udemy! Cheers!
@ShanesCows
@ShanesCows 4 жыл бұрын
Thank you. Please check out training.powerapps911.com for some of my courses. 😻
@robertomancino5517
@robertomancino5517 4 жыл бұрын
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
@ShanesCows
@ShanesCows 4 жыл бұрын
Glad to help. 😀 And thanks for the kind words.
@muyiwaishola3196
@muyiwaishola3196 4 жыл бұрын
You are a good trainer Shane! Kudos!
@ShanesCows
@ShanesCows 4 жыл бұрын
Thank you
@sandorapati3156
@sandorapati3156 4 жыл бұрын
Great videos, helped me a lot! Thank you!!
@ShanesCows
@ShanesCows 4 жыл бұрын
Thanks 🙏
@atriyana6746
@atriyana6746 4 жыл бұрын
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.
@ShanesCows
@ShanesCows 4 жыл бұрын
Thanks 😊
@MelwynRodrigues
@MelwynRodrigues 4 жыл бұрын
Thanks Shane! Great video! Very helpful!
@ShanesCows
@ShanesCows 4 жыл бұрын
Thanks 🙏
@defyingblueprints6914
@defyingblueprints6914 5 жыл бұрын
When I first heard your intro I hated the music, but now I just get excited for a good video, haha!
@ShanesCows
@ShanesCows 5 жыл бұрын
🤣😂🤣 Love it.
@danielderese3170
@danielderese3170 5 жыл бұрын
Big Thanks for all your Videos !!!!!!!You are Awsome
@ShanesCows
@ShanesCows 5 жыл бұрын
☺️☺️☺️
@cardinalnight3883
@cardinalnight3883 6 жыл бұрын
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?
@DannyRusbasan
@DannyRusbasan 3 жыл бұрын
Thanks for your vids! They've been a big help.
@ShanesCows
@ShanesCows 3 жыл бұрын
You are welcome Danny!
@bunty12000
@bunty12000 4 жыл бұрын
Very helpful and easy to learn video, many thanks, Subscribed !
@ShanesCows
@ShanesCows 4 жыл бұрын
Thanks for the sub!
@princex100
@princex100 2 жыл бұрын
Thank you Shane, your videos are very helpful
@ShanesCows
@ShanesCows 2 жыл бұрын
My pleasure!
@santoshdhasmana5028
@santoshdhasmana5028 3 жыл бұрын
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.
@ShanesCows
@ShanesCows 3 жыл бұрын
I appreciate that!
@zaydarendse2812
@zaydarendse2812 3 жыл бұрын
Thanks for sharing!! loved the lesson :)
@ShanesCows
@ShanesCows 3 жыл бұрын
You are welcome 🙏
@berndkroon5147
@berndkroon5147 4 жыл бұрын
Like your contributions a lot!
@ShanesCows
@ShanesCows 4 жыл бұрын
Thanks 🙏
@benjaminliu1100
@benjaminliu1100 5 жыл бұрын
there is a very nice teaching, it's very much practical; I believe, this video is helpful for more people! Great!
@ShanesCows
@ShanesCows 5 жыл бұрын
Thanks
@SA-kt3wt
@SA-kt3wt 2 жыл бұрын
Hi Shane, I really enjoy your videos! I have an excel table which will likely be a few thousand records in a year. My question is, which I can't seem to find the answer to - are collections always necessary? The workarounds to bring multiple records up to the app seem quite cumbersome, especially if they wanting to update records. Where data exceeds 2000 rows, is using a delegable function like filter just a better option?
@KariGrafton
@KariGrafton 2 жыл бұрын
This was really helpful and easy to follow. Thank you!
@ShanesCows
@ShanesCows 2 жыл бұрын
Happy to help. Have a great day. 🐶
@pixelb0i255
@pixelb0i255 3 жыл бұрын
Very helpful Shane.
@ShanesCows
@ShanesCows 3 жыл бұрын
Awesome
@janib4348
@janib4348 5 жыл бұрын
Great Job Shane Young its very very use full for a beginner.Excellent explanation.
@ShanesCows
@ShanesCows 5 жыл бұрын
Thanks
@gangavi3
@gangavi3 3 жыл бұрын
Great Info!! Keep rocking
@ShanesCows
@ShanesCows 3 жыл бұрын
Thanks! Will do!
@fifimomo5146
@fifimomo5146 4 жыл бұрын
Thank you sir, might God bless you and you knowledge.
@ShanesCows
@ShanesCows 4 жыл бұрын
So nice of you
@josephinetrudgen2917
@josephinetrudgen2917 5 жыл бұрын
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?
@ShanesCows
@ShanesCows 5 жыл бұрын
Watch this video on patching. PowerApps Save Data - Patch, Collect, and ForAll kzfaq.info/get/bejne/g8mcfcKAnq7aeoU.html hopefully it helps.
@mohammedghufranahmedkhan3143
@mohammedghufranahmedkhan3143 2 жыл бұрын
Very Useful. Excellent work.
@ShanesCows
@ShanesCows 2 жыл бұрын
Glad it was helpful!
@nikomouklab
@nikomouklab 5 жыл бұрын
Thank you for your content Shane.
@ShanesCows
@ShanesCows 5 жыл бұрын
You are welcome 🙏
@nikomouklab
@nikomouklab 5 жыл бұрын
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.
@nikomouklab
@nikomouklab 5 жыл бұрын
hmmm finally I'd figured out. You need to patch the virtual fields _value and _type of a lookup.
@yvonnew2010
@yvonnew2010 6 жыл бұрын
Excellent
@donnagrover5193
@donnagrover5193 5 жыл бұрын
Shane - love your videos! You make learning Power Apps fun! :-)
@ShanesCows
@ShanesCows 5 жыл бұрын
Thanks. 😊
@RudyBaroudi
@RudyBaroudi 3 жыл бұрын
Great explanation of collections as always. Thank you very much.
@ShanesCows
@ShanesCows 3 жыл бұрын
My pleasure!
@siddharthsingh7341
@siddharthsingh7341 4 жыл бұрын
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" :)
@ShanesCows
@ShanesCows 4 жыл бұрын
Thanks 😊
@siddharthsingh7341
@siddharthsingh7341 4 жыл бұрын
You are welcome sir. I am addicted to ur courses. Please let me know if you have courses for SPFx as well. 😊
@shawnlloyd7526
@shawnlloyd7526 4 жыл бұрын
Awesome!
@ShanesCows
@ShanesCows 4 жыл бұрын
Thanks 🙏
5 жыл бұрын
Thats was really useful, fast and even funny video, thanks a lot!
@ShanesCows
@ShanesCows 5 жыл бұрын
Glad to help.
@kanishkaroychowdhury4050
@kanishkaroychowdhury4050 4 жыл бұрын
hi shane... as usual great video
@ShanesCows
@ShanesCows 4 жыл бұрын
Thanks 😊
@AI-Health-posts
@AI-Health-posts 4 жыл бұрын
thanks Shane great video
@ShanesCows
@ShanesCows 4 жыл бұрын
Glad you like it.
@matiascaamano3160
@matiascaamano3160 5 жыл бұрын
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!
@ShanesCows
@ShanesCows 5 жыл бұрын
Yes. You reference controls (fields) the same regardless if they are the same screen or not.
@ktaber317
@ktaber317 4 жыл бұрын
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.
@ShanesCows
@ShanesCows 4 жыл бұрын
Fancy Kelly. Thanks for sharing 😍
@arifhassan3987
@arifhassan3987 4 жыл бұрын
Your videos are awesome.
@ShanesCows
@ShanesCows 4 жыл бұрын
Thanks 🙏
@juan07241981
@juan07241981 5 жыл бұрын
Eres un maestro,,, gracias (You are a Master,,, Tanks)
@ShanesCows
@ShanesCows 5 жыл бұрын
De nada. (Did I do that right?)
@gautamdas1267
@gautamdas1267 3 жыл бұрын
awesome Shane
@ShanesCows
@ShanesCows 3 жыл бұрын
Thanks 😊
@louiscutmore
@louiscutmore 3 жыл бұрын
Fantastic 👏
@ShanesCows
@ShanesCows 3 жыл бұрын
Thank you! Cheers!
@katiebeton2767
@katiebeton2767 6 жыл бұрын
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.
@ShanesCows
@ShanesCows 6 жыл бұрын
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.
@asimrehan73
@asimrehan73 2 жыл бұрын
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.
@ShanesCows
@ShanesCows 2 жыл бұрын
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.
@asimrehan73
@asimrehan73 2 жыл бұрын
@@ShanesCows thanks. Its working fine with 4 collections of 300+ records having 10 items each.
@vishaljhaveri7565
@vishaljhaveri7565 2 жыл бұрын
Thank you sir.
@deogardener
@deogardener 4 жыл бұрын
So good video!
@ShanesCows
@ShanesCows 4 жыл бұрын
Thank you ☺️
@alyssacpkids97
@alyssacpkids97 3 жыл бұрын
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?
@ShanesCows
@ShanesCows 3 жыл бұрын
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. kzfaq.info/get/bejne/ndmbZJd1kqm9gnk.html I have this on my list of videos to make in the future.
@mtamitolanga
@mtamitolanga 6 жыл бұрын
Hi Shane thank you for the video on collection. Just one question, I've created an attendance list in sharepoint that captures trainees details and instead of creating as items I want to create as a collection through powerapps. I've customised the list in powerapps as a collection but how do I display my collection back to sharepoint. Thanks
@ShanesCows
@ShanesCows 6 жыл бұрын
You can display a collection using a gallery or data table. What is your end goal? If you want to keep it you will need to save it somewhere.
@nocodeyuan
@nocodeyuan 4 жыл бұрын
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!
@ShanesCows
@ShanesCows 4 жыл бұрын
This video I show one of the ways to get data out of the collection and into your data source. kzfaq.info/get/bejne/g8mcfcKAnq7aeoU.html Also I think the ForAll video shows it more complicated, I think kzfaq.info/get/bejne/Zt6KZ8l-r8iwpp8.html
@Porknan
@Porknan 2 жыл бұрын
Hi, I am new to powerapps, I find your videos interesting and straight forward to follow. I have a question regarding collections. I would like to be able to add images to a collection but there is not a set amount, I would like to user to be able to add as many images (from the camera) as they need to. Therefore the collection would need to be dymanic? Or would all the images be stored in the one field? Hope this makes sense and hope you can help. Many thanks
@matthewboulden7215
@matthewboulden7215 3 жыл бұрын
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?
@ShanesCows
@ShanesCows 3 жыл бұрын
Maybe this video will help. kzfaq.info/get/bejne/g8mcfcKAnq7aeoU.html
@gingerelm6694
@gingerelm6694 6 жыл бұрын
Hello, i created a collection by collecting datas from different galleries(different data sources). Is there a way for me to patch and get the collection up on sharepoint, like create a new list based of the new collection. Basically the context is, the students get to choose the courses that they wish to take from different subjects and that directs them to a summary page with all their choices. and when they click confirm, (this is what i want to achieve) their choices gets recorded and saved into a list on sharepoint which i can view. Would appreciate if you can give me some advice on this!!
@AnandavadivelanV
@AnandavadivelanV 6 жыл бұрын
Great video, very helpful, thanks. Do you have tips for avoiding duplicates going into a collection and maybe even with a message “already exists”?
@ShanesCows
@ShanesCows 6 жыл бұрын
I haven't done much there. I guess you could do a lookup and if the lookup doesn't find anything then write the record. Not sure. Something I need to learn more about for sure.
@maidstone53
@maidstone53 5 жыл бұрын
Shane, Thanks again for the great videos! I have one question, how do you take several forms on different screens and put them into a collection, then submit them to a sharepoint list. I use Collect( CollectReport, {All my stuff}) on each of the screens then a Collect( 'Sharepoint List', MyCollection). It will not write to the sharepoint list and will create a row of data for each form in my collection?!?! Not sure what Im doing wrong, any Ideas??
@ShanesCows
@ShanesCows 5 жыл бұрын
I bet your columns don't match between 'SharePoint List' and MyCollection. If you hover over the formula with the mouse it will usually tell you what columns don't match.
@mattengel1866
@mattengel1866 4 жыл бұрын
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!!!
@ShanesCows
@ShanesCows 4 жыл бұрын
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
@seegeat
@seegeat 6 жыл бұрын
Smart Presentation style...i like it. In Javanesse language is "Jos Tenan"
@ShanesCows
@ShanesCows 6 жыл бұрын
Thanks you! :)
@jorgcordes7906
@jorgcordes7906 4 жыл бұрын
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.
@ShanesCows
@ShanesCows 4 жыл бұрын
You cannot use Forms with collections. 😔
@niuean22kid
@niuean22kid 3 жыл бұрын
Thank you Shane! Can I ask in some of your other videos you used the 'Parent (Default)' as the second input for the patch, what is the purpose of using the Parent Default input?
@ShanesCows
@ShanesCows 3 жыл бұрын
Patch(List, Defaults(List), {column: value}) is used to create a new item via patch. Patch(List, LookUp(List, column = value), {column: value}) is used to edit the existing record returned by the lookup. I hope that helps.
@travelexplore3306
@travelexplore3306 4 жыл бұрын
Awesome 👍 well explained
@ShanesCows
@ShanesCows 4 жыл бұрын
Thanks 🙏
@gudivadamaruthisudhakar5132
@gudivadamaruthisudhakar5132 4 жыл бұрын
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)
@ShanesCows
@ShanesCows 4 жыл бұрын
It shouldn’t be any different. Just need to know the field names
@noznip2008
@noznip2008 5 жыл бұрын
thank you so much man
@ShanesCows
@ShanesCows 5 жыл бұрын
😎
@franciscolopes8337
@franciscolopes8337 4 жыл бұрын
Hello Shane!! Thanks for the video... I'm in a difficult situation... I have two tables, and in one of them i have a item (Score) thats need the value of a datacard from the other table, but with the specific Value ... how can i pickup that value from the other form with the specified item?? Thanks for the Help!!
@ShanesCows
@ShanesCows 4 жыл бұрын
Use Lookup to query the other record I think is what you are asking 😀
@christopherbenoit6794
@christopherbenoit6794 4 жыл бұрын
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
@ShanesCows
@ShanesCows 4 жыл бұрын
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.
@rebeccasackett6472
@rebeccasackett6472 5 жыл бұрын
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.
@ShanesCows
@ShanesCows 5 жыл бұрын
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.
@nbincompliance6436
@nbincompliance6436 5 жыл бұрын
Love all these Lessons - you're Awesome!! Shane when editing details from the collection... the coding we used was Gallery1.Selected.@#$#@ (name of the list-item in the collection). I'm trying to find the coding for a Dropdown Box can you help? this is what i'm using to add the dropdown item to the collection: {Managed: Managed_YN.Selected.Value} (the dropdown options are Yes, No) How do I pull this to the Edit Screen?? Gallery1.Selected.Manged isn't working LOL..
@ShanesCows
@ShanesCows 5 жыл бұрын
Gallery1.selected.value
@JMT1gmail
@JMT1gmail 2 жыл бұрын
Hi Shane, First, I love your work - you are a wealth of knowledge and experience. Thank you. I'm trying to create a collection that adds to a SP list. The process is: (i) fields of {text, date, dropdown and attachment} to collect, (ii) view collection of four fields, (iii) collect/patch collection to SP [same as your halloween Patch, Collect, and ForAll video). However, I get an incompatibility error as the SP column (Title) wants a record, but the PA attachment is a table [name & value]. Is this why you made two videos about attaching files to SP (based off Ramerio's idea) - because the three step process I have (enter, view collection, collect/patch) can never work with an attachment? The reason why I liked what you did here was because one could edit the item details before confirming.
@udaypatil9753
@udaypatil9753 5 жыл бұрын
Very helpful.. you are doing very good.. thank you very much.
@ShanesCows
@ShanesCows 5 жыл бұрын
Happy to help
@udaypatil9753
@udaypatil9753 5 жыл бұрын
@@ShanesCows Can you add some video related to - Connect power apps to D365 & perform some crud operations on entity using connectors.
@philipmarno4989
@philipmarno4989 4 жыл бұрын
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.
@ShanesCows
@ShanesCows 4 жыл бұрын
Yes separate the two functions by a ;
@turtogtokhmunkhtsooj6800
@turtogtokhmunkhtsooj6800 5 жыл бұрын
Love your video
@ShanesCows
@ShanesCows 5 жыл бұрын
Thanks 😀
@givanildosilvadeamorim326
@givanildosilvadeamorim326 5 жыл бұрын
Hello Shane! How can I save attachments (images) when offline? I have an Attachment Column in a Sharepoint List where I store the images. Thanks!
@ShanesCows
@ShanesCows 5 жыл бұрын
You can’t use forms with collections. Will have to store the images in a collection when offline.
@ahalyayallamalli2310
@ahalyayallamalli2310 2 жыл бұрын
Hi Shane, Thank you for such a wonderful video. Need Clarity how to disable the Edit mode after saving the changes .
@miprofetic
@miprofetic 3 жыл бұрын
Shane! I need you. My teachers now say that when there is no internet , the patching is lost. Obviously because the patching is in the last button when they select all the options in the drop-down. Is there a way to prevent this? Save the evaluation to a point so they can come back and continue the teacher evaluation ?
@MarcSoester
@MarcSoester 6 жыл бұрын
Thanks buddy 👍
@ShanesCows
@ShanesCows 6 жыл бұрын
You are welcome. 😎
Learn to use the PowerApps Power BI Visual
19:02
Shane Young
Рет қаралды 73 М.
PowerApps Save Data - Patch, Collect, and ForAll
25:52
Shane Young
Рет қаралды 243 М.
Каха и суп
00:39
К-Media
Рет қаралды 6 МЛН
Does size matter? BEACH EDITION
00:32
Mini Katana
Рет қаралды 20 МЛН
PowerApps Collection - Send emails, sum, and format
21:53
Shane Young
Рет қаралды 71 М.
Intro to PowerApps Variables
19:23
Shane Young
Рет қаралды 203 М.
Power Apps Collections Introduction
18:48
Shane Young
Рет қаралды 78 М.
Google Data Center 360° Tour
8:29
Google Cloud Tech
Рет қаралды 5 МЛН
Mastering Delegation in Power Apps: A Comprehensive Guide
23:13
Shane Young
Рет қаралды 37 М.
PowerApps Conditional Formatting and Popups
25:42
Shane Young
Рет қаралды 135 М.
Collection in Power Apps
12:09
Dhruvin Shah
Рет қаралды 15 М.
PowerApps Multiple Data Sources
22:09
Shane Young
Рет қаралды 200 М.
Power Apps Variables - All 5 Types
30:11
Shane Young
Рет қаралды 7 М.
Что делать если в телефон попала вода?
0:17
Лена Тропоцел
Рет қаралды 2,5 МЛН
iPhone 15 Pro в реальной жизни
24:07
HUDAKOV
Рет қаралды 438 М.
Смартфон УЛУЧШАЕТ ЗРЕНИЕ!?
0:41
ÉЖИ АКСЁНОВ
Рет қаралды 1,2 МЛН