Patch all filtered items in a gallery to a new SharePoint List

(0) Share

Report

Posted on by brianpinkelman

I am struggling with the code to Patch all filtered items from a Gallery to a different SharePoint List. For example, there are 5 filtered items in Gallery2 and I would like each of those records to be patched to the new SharePoint list which is called RouteItineraryList. Currently it works but only copies the first 'Selected' item 5 times. How can I accomplish this? I am assuming it has to do something with the .Selected but could use some help!

ForAll(
 Gallery2.AllItems,
 Patch(RouteItineraryList,
 {Title:Gallery2.Selected.Title,
 'Route Name':Gallery2.Selected.'Route Name',
 'Itinerary Creator':User().Email,
 'Distributor Dealer Number':Gallery2.Selected.'Distributor Dealer Number',
 'Retail Customer':Gallery2.Selected.'Retail Customer',
 'Retail Customer Street Address':Gallery2.Selected.'Retail Customer Street Address',
 'Stop Number':Gallery2.Selected.'Stop Number'
 }
 )
)

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

VDI 337 on at

Like
a
(1)

Report
Copy link

Link copied!
try below code,
ForAll( Gallery2.AllItems, Patch(RouteItineraryList, {Title:ThisRecord.Title, 'Route Name':ThisRecord.'Route Name', 'Itinerary Creator':User().Email, 'Distributor Dealer Number':ThisRecord.'Distributor Dealer Number', 'Retail Customer':ThisRecord.'Retail Customer', 'Retail Customer Street Address':ThisRecord.'Retail Customer Street Address', 'Stop Number':ThisRecord.'Stop Number' } ) )