Power Platform Community Forum Thread Details

Updating Sharepoints list with Power Automate Flow

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

Quick Links