shift records from sharepoint list to powerapps collection

[gennarodp]

Hello,

i would like to know how to shift (cut and copy) records selected in a gallery (from sharepoint list), in a powerapps collection, with a button.

The process that i search is similar to a shopping cart, but i would that in the moment that i add a record in chart, this record disappears in sharepoint list.

How can i do this ?

Thanks

[WarrenBelz]

Hi @gennarodp ,

You would use Collect() - assuming the Collection is based on the list with the same field Names and Types, if you were to put an icon in a Gallery based on the List with this code on the OnSelect

Collect(
   YourCollectionName,
   ThisItem
)

you would add the current record to the Collection.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

[gennarodp]

hello @WarrenBelz , thank you for your answer.

With collect function, i add in chart the item, but this item doesn't disappear in sharepoint list.

The second step for me is very important.

[sfreitas]

You can create a power automate flow. When you add the item to the collection you call the flow and delete the item in sharepoint list. 

[gennarodp]

yes could be a solution...but i would'nt use automate for this.

In alternative, could be possible, to create a flow with power automate, that when a new item in sharepoint list is created, create this records also in powerapps collection ?

In this way, then, i could transfer data records from a collection to another collection, with a combination of function collect and remove functions.

Thank you

[sfreitas]

You couldn't acess to your power apps collection using power automate. Your collection is unique per user, per session and is local and you can't acess to her. 

You can try the function removeif with your sharepoint list as datasource and the second parameter is the item id.