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 Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,340)