You’re offline. This is a read only version of the page.
Announcements
22
would like to get some ideas about creating the flow,
if i modify a field in sharepoint list A, it will look up the order number of that modified field in sharepoint list B and change that modified field for all order with that order number
lets say in sharepoint list A, i have an order for 2 red balls with an order number 123123
in sharepoint list B that same order will be list twice and with an extra field call qtyOf, in there it will show 1 of 2 and 2 of 2
so if i modify the color red to yellow in sharepoint list a, it should automatic reflect that in sharepoint list b
i was thinking about creating a flow to achieve this using the, when sharepoint list is modify flow, but unsure how to target it so it look up for the order number and change all that meet that criteria
Sure. So.
Trigger when a file or item is modified.
Then, "Get Items". Filter Query: OrderNumber eq 'DC-OrderNumber' (where the first "OrderNumber" is the internal name of the column in SharePoint List B, and DC-OrderNumber is the Dynamic Content of Order Number from SharePoint List A (which you can get from dynamic content from the trigger.)
That will get you all items in SharePoint List B where the Order # is the same.
Then, "Update Item". As soon as you reference the "ID (which will be dynamic content from the "Get Items" output), it will turn into an Apply To Each, meaning you'll update each entry that applied to that Order Number.
Share
Report
All responses (
Answers (
