You’re offline. This is a read only version of the page.
Hi all,
To preface, I have very little experience with Flow or Power Automate in general. So I'm not familiar with a lot of the techy terms - please use layman's terms for me where possible 🙂
I'm trying to link two Sharepoint lists.
1. Master List that holds 10,000+ line items,
2. Secondary list with 3,000+ line items.
I need a flow that will update the master list when items are modified or created on the secondary list. I have tried a number of Flows with test lists, but the main issues I have are:
1. Every line item is updated on every run,
2. Nothing is update, and;
3. Newly created items are added to the master list multiple times.
My unique identifiers/ filters are 'Document Number' (single line text), 'Update Master list' (Yes/No), 'Modified' (Date and time).
I happy to create two separate flows, one for creations and the other for modifications, if it lowers the risk of any issues. The master data list has been manually updated for 8+ years and will be nearly impossible to reconcile if something goes wrong.
Unfortunately, I'm unable to share screenshots due to my companys DI policies.
Any help appreciated!
Amy
hi@Anonymous ,
Below I have a trigger when an item is modified, then I "get the changes for an item" since I only want to update my master list when specific columns are updated. My condition checks if the column has changed and other conditions based on field values.
If yes, I get Items (Get the ID) of the item on my master list by specifying a filter query using values from the item that got modified. This should be the document number in your case.
After I get the item, I check if I did get something (condition 2). If yes, I then proceed to update the item using the ID I got and fields from the modified item on the first step.
Share
Report
All responses (
Answers (
458
