web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Flow that Creates and ...
Power Automate
Answered

Flow that Creates and Updates from Two SharePoint Lists

(0) ShareShare
ReportReport
Posted on by 25

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".

 

THough_0-1698345518132.png

 

Categories:
I have the same question (0)
  • Verified answer
    Nicbo Profile Picture
    145 on at

    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'

    Nicbo_1-1698355577877.png


    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

    Nicbo_3-1698356580186.png

     

    Nicbo_2-1698356361462.png

     

     

    Hope it helps!

  • Verified answer
    THough Profile Picture
    25 on at

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

     


     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 707

#2
Haque Profile Picture

Haque 475

#3
Valantis Profile Picture

Valantis 456

Last 30 days Overall leaderboard