cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ryang
Helper I
Helper I

Updating Multiple Entries in a Sharepoint List

As part of the OnVisible Property of  Screen i have the following formula:

 

ClearCollect(PassengersTemp,Filter(Passengers,BookingId=BookingFilterId))

Then on a button I have the following formula which has no errors until after I click the button:

 

Forumla - ForAll(PassengersTemp,Patch(Passengers,First(Filter(Passengers,ID=ID)),{Queue:Queue+1}))

Error - The requested operation is invalid. Server response: Fetching items failed. Possible invalid string in filter query.

 

What I am essentially attempting to do, update a subset of the Passengers table all at once. I had done a concept similar to this using SQL Server as the data source. I do not know if there is something I am over looking.

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

@ryang  PowerApps doesn't like ID=ID. You can use disambiguation or what I've also done in the past is rename one of the ID columns like this:

 

ForAll( RenameColumns(PassengersTemp, "ID", "ID1"), Patch(Passengers, First( Filter(Passengers, ID = ID1)), { Queue: Queue+1 } ));

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

@ryang  PowerApps doesn't like ID=ID. You can use disambiguation or what I've also done in the past is rename one of the ID columns like this:

 

ForAll( RenameColumns(PassengersTemp, "ID", "ID1"), Patch(Passengers, First( Filter(Passengers, ID = ID1)), { Queue: Queue+1 } ));

Even though I didn't post the question, your solution helped me great deal. Thanks @ryang 

Thanks @Anonymous. Kudos.

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (1,639)