Save gallery collection as one Sharepoint record

[Thaone2]

Hello,

I'm in the process of building a canvas app form that submits data to a SharePoint list. The form has a people picker field that is tied to a person column in the SharePoint list. Once a person is selected the data is used to populate a couple of other fields automatically. I need to create the ability to select one person or mulitples so have created a gallery that adds a new line of controls onSelect and stores as a collection. Is there a way to save the entire collection as on record in SharePoint?  Thanks in advance for any help

[subsguts]

Can you clarify what you are trying to do?
If I understand, you are storing each of the rows that are added in your collection temporarily.  Then after the user adds all the lines they want you then want to store all that data into Sharepoint.

If this is correct, is what you are asking is how to take a collection that contains multiple records and store it into SharePoint where it will exists as multiple items in a SharePoint list?

Thanks for the additional details, I think that will help get you the solution you are looking for.

[Thaone2]

@subsguts 

Thanks for your reply. You are correct, except I am wanting to store the multiple records from the collection into SharePoint as one item in the list. Hopefully that makes a little more sense.

[subsguts]

Hi Thaone2, 
Honestly, I'm not sure how to do this without a bunch of steps that I would consider very difficult to maintain.  It wouldn't be conventional to say the least 🙂

Why are you opposed to storing these as multiple items in the SP list?  What requirement is causing this?  Curious now 🙂

[Thaone2]

@subsguts

The form is for a group of people to be nominated for an award. I'm not opposed to storing the values separately. My issue would be pulling the data back into powerapps to display as one full record. Any recommendations?

[subsguts · Accepted solution]

If you don't already, you should have some Primary Key value in your Sharepoint list, like "AwardNumber".  When you store all the names as individual records each will have the same "AwardNumber".

When you want to display all this information as "one record" then I would load all this information into a collection using the "AwardNumber" to get everyone.  Once this information is in the collection you can display it in a gallery, or any number of ways depending on your imagination 🙂

Hope this helps, if not please continue the conversation.