Answered

Flow that Creates and Updates from Two SharePoint Lists

Like (0) Share

Report

Posted on 26 Oct 2023 18:49:52 by THough

PLEASE HELP! I've been trying to build a Flow that GETS items from List A (Schedule Test) and not only CREATES Items in List B (Document Tracker) but then UPDATES List B when Item changes in List A (Schedule Test). Get Item and Create work fine, I just don't know how to update List B Items when those Items change in List A. Example: Column: Task Name changes from "A Red Rose" to "A Yellow Rose" and / or column Status changes from "Growing" to "Picked".

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

THough 25 on 28 Oct 2023 at 15:35:30

Like (0)

Report

Re: Flow that Creates and Updates from Two SharePoint Lists

You are brilliant! Thank you so much for the assist! It worked. Yay!

Was this reply helpful? Yes No
Verified answer

Nicbo 145 on 26 Oct 2023 at 21:44:52

Like (0)

Report

Re: Flow that Creates and Updates from Two SharePoint Lists

ou can use the trigger 'When an item is created or modified' instead, but then we need a value in List B that links it to List A. I suggest you add a column in List B called something like ListA_ID. So in addition to adding Task name and Status Value, you also add the ID. Then we can check when a new item is added if it already exists, then we should update, if it doesn't exist, we create a new one.

So when a new item is created in List A, retrieve items in List B but filter by ID by adding this to the Filter Query
ListA_ID eq 'INSERT dynamic value ID'

Then check if the output is empty, if so create a new item, otherwise update an existing one.

The expression is just empty() and then y add the dynamic content of the body inside the ()
and just write true in is equal to-field

Hope it helps!

Was this reply helpful? Yes No