Working with a PowerApps Collection - Check Description for new version 

Thank you for sharing this. It means a lot. 😀

Thanks and thanks!

Thank you very much. These comments keep me making content.

Thanks! Keep kicking butt!

I will. You keep learning 😀

Glad to help. 😀

Love it! 😀

I like it Mike. Thanks

Cool. Glad it is working for you. :)

Awesome

I will. Thanks

Thanks 😊 not sure it is true but thanks 😊

Thanks for that!

You are welcome.

Glad to help. 😀

Awesome Sergio!

Glad to help. 😀 And thanks for the kind words.

Glad to help. 😀 you are welcome

Thanks 😊

I appreciate that!

Watch this video on patching. PowerApps Save Data - Patch, Collect, and ForAll ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MclJ_O9HvJQ.html hopefully it helps.

Thank you

Thank you. Please check out training.powerapps911.com for some of my courses. 😻

I have over 100 so I got you covered. 😀

You are welcome.

🤣😂🤣 Love it.

Happy to help

Yes. You reference controls (fields) the same regardless if they are the same screen or not.

Fancy Kelly. Thanks for sharing 😍

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.

Glad you enjoyed it!

Thanks

Happy to help Jason

Maybe this video will help. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MclJ_O9HvJQ.html

Glad to help. 😀

Awesome! Thanks for sharing.

☺️☺️☺️

Thanks

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.

Thanks 🙏

Glad to help. 😀

Glad to help. 😀

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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-gsk14D-CYRE.html I have this on my list of videos to make in the future.

This video I show one of the ways to get data out of the collection and into your data source. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-MclJ_O9HvJQ.html Also I think the ForAll video shows it more complicated, I think ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-0xZ4fMJbLvk.html

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.

You cannot use Forms with collections. 😔

My pleasure!

My pleasure!

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.

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.

It shouldn’t be any different. Just need to know the field names

Thanks 🙏

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.

Glad to hear that!

I have not seen OnStart not work. Sorry

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

You are welcome Danny!

You are welcome 🙏

I talk about Duplicates in this video. Maybe it will help ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Ap3_Ea9H8b0.html

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.

Not really. But the larger the collection the more stuff you have in memory the more likely you are to cause performance issues.

Thanks, Timothy - Maybe I did a bad job setting context. Here I was trying to teach collections. I think to your questions there a lot of answers. For customers, I have been creating the referential integrity within PowerApps. Example, the customer has a SharePoint list integration form that he uses to track job applicants. For the location field, we provide a drop-down. That drop-down is populated from their master location list in a different Site Collection. When you add a new item you choose your location Cincinnati in the drop-down and then we write that text value to the SharePoint applicants list. We don't store any type of reference back to the master list. Now if that was what you wanted to do you could. You could display the text Cincinnati but capture the list item ID and write that behind the scenes. Then you would do all of the plumbing but you would have the reference I think you are looking for. There is also the ability within SharePoint to use LookUP columns which do a lot of this for you for free as long as the other list is in the same site collection. Personally, I stay away from LookUp columns. They are just slightly different in every way possible. And they and PowerApps have some challenges working together. I know lots of people do use them, I just don't like them so I don't. Long story short. You are right thinking that PowerApps and SharePoint can give you the experience you are looking for. Just takes a bit more work. I think if you look at the mutiple-data source's video I talk about how to write back to a data source with info from a different data source. Hope this help. - Shane

If you Reset(ControlName) that will set the control back to its default value.

@@ShanesCows gracias! 😊

Yes separate the two functions by a ;

Gallery1.selected.value

Thanks 😊

You are welcome sir. I am addicted to ur courses. Please let me know if you have courses for SPFx as well. 😊

Yup, no collections and forms. :(

To write only the changes you would need to track those changes and then update those records. I will sometimes add a field to my collection IsEdited and set it to false. Then if they edit that record set it to true. Then only update those changes.

@@ShanesCows Thank you, I will give that a go. Keep up the good work.

Thanks 🙏

My pleasure!

Look for my video on save data. It is Halloween themed but should work.

Christophe not exactly sure what you are trying to do? Maybe give me more details? :)

Basically I would like powerapps' users to be able to copy a list of names from an excel file to a text input in powerapps. Then they would chose the City from a dropdown list which is common to all the names listed. After submission, I would like these information to be consolidated on a onedrive excel file, where first column is Name and second one is City. Each name they pasted in powerapps would be added to the end of the Excel list, by adding a new row, and the city they chose from the dropdown list would be applied to all these names recently added. I kind of have a result by using the Split(XXX,Char(10)) function to my text input and then Collect, but I still struggle to apply the same city chosen from the dropdown list to all these names, in the excel file.. Not sure if it is easier to understand now ?! :) Thanks anyway for trying to help me on this!

If someone is trying to work on the same idea, I found an easy way to do that. I used a Microsoft Flow triggered by a powerapps button. The flow is linked to my excel file on Onedrive, and the action triggered is "add a new row in the datatable". From there, it is easy to declare in Microsoft Flow which data we want to add to the different columns of the datatable. Hope this helps.

Use Lookup to query the other record I think is what you are asking 😀

Thanks for the sub!

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.

Happy to help. Have a great day. 🐶

Thanks. 😊

Look into the in operator. It is possible 😀

Collections are variables. So you can populate them from your SharePoint list. Then you can edit them in your app and then push them back to SharePoint. Maybe leave a new comment on more speficially what you want to do ?

Thanks! Will do!

If you want to use a form then you will need to do it as attachments.

So nice of you

You can only collect 2000 items from a data source but I am pretty sure you can add as many items as you want to a collection. Never explored the upper bounds here. What do you have in mind?

Hi Shane, I have a SharePoint list that has just over 6000 items in it which I need to manipulate. My thought process is to add all the items to the collection and then use that to work with, patching the changes back to the SP List on a button select. That way, I should be able to get round the delegation issues that I keep getting. Hope that makes sense!

Collect(yourCollection, combobox.selecteditems) should work

ForAll function

Why do you need the data in the collection stored in a different order? I bet your answer to that question is going to be to show a certain column. Check out this video for help with ShowColumns ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Gtzs1-IuXuY.html

I haven't done that topic yet but I should. Sorry. I agree with you though. I never use the template other than to learn.

They like to keep us guessing. 😀 : means equal only with update context and patch/record stuff I think. If you always use =

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.

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

Yes you can! Edit your gallery and you can insert a label or any other control.

Thanks 🙏

Yes you need to have collections. You should never do a lookup to your datasource inside a gallery. Way too many calls.

@@ShanesCows Thanks Shane... the lookups aren't in a gallery... they are text fields on a screen that do the lookup to SQL and are patched to SharePoint. But I agree... I need a collection here so that the collection pulls one record from SQL and i can then use the collection to populate the text fields. Can you provide the syntax to populate a collection with one row from a SQL table? I've had the worst time trying to find it. Thanks again!