cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tamras
Level 10

Patch another item on SharePoint

Normally I would use ID to patch a specific item on SharePoint but on this app I need to patch the next record based on 2 columns.

SP List:

IDMasterIDRouting Order
10471
11473
12472

 

Lets say the current app is updating ID #10...after submit, i need to patch the next order which is 2. 

Currently, I have the following formula but it creates a new record rather than updating an existing record.

SubmitForm(Form1); Patch(Task, First(Filter(Task, MasterID=InProgressGallery.Selected.MasterID && RoutingOrder=InProgressGallery.Selected.RoutingOrder+1)), {Status: "In Progress"}); 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Tamras
Level 10

Re: Patch another item on SharePoint

I may have found the solution using Lookup rather than Filter from this post.  Formula below works for now but only tested with 3 routing orders.

Patch(Task, LookUp(Task, MasterID = InProgressGallery.Selected.MasterID && RoutingOrder = InProgressGallery.Selected.RoutingOrder +1), {Status: "In Progress"});

 

View solution in original post

1 REPLY 1
Tamras
Level 10

Re: Patch another item on SharePoint

I may have found the solution using Lookup rather than Filter from this post.  Formula below works for now but only tested with 3 routing orders.

Patch(Task, LookUp(Task, MasterID = InProgressGallery.Selected.MasterID && RoutingOrder = InProgressGallery.Selected.RoutingOrder +1), {Status: "In Progress"});

 

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 218 members 5,697 guests
Please welcome our newest community members: