cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gennarodp
Post Patron
Post Patron

shift records from sharepoint list to powerapps collection

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

5 REPLIES 5
WarrenBelz
Super User
Super User

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.

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.

 

 

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. 

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

 

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.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,205)