Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

Update list1 with info from list 2 using flow

(0) ShareShare
ReportReport
Posted on by 22

Hi,

 

 

i've got a list (list 2) with info about cliënts. If a specific field in list 2 is set 'true' i want to copy some of the fields of list 2 to another list (list 1)

 

I managed (not an experienced flow user) to let the first steps work, but the last step, update list 1, won't work. Perhaps i'm missing a stip, or am i on a complete wrong track. Does anyone has suggestions?

 

Thanks in advance,

 

Categories:
  • henkprins Profile Picture
    henkprins 22 on at
    Re: Update list1 with info from list 2 using flow

    Hi Mabel,

     

    thnx for your support. Took a lot of time because of some stupid mistakes i made, but in the end i managed to get the flow working. Thanks again!

     

    Henk.

  • Verified answer
    v-yamao-msft Profile Picture
    v-yamao-msft on at
    Re: Update list1 with info from list 2 using flow

    Hi @henkprins,

     

    Thanks for providing the detailed flow configuration.

    It seems that there are two conditions in the flow to check if the two fields in the list are True or False.

    I assume that you could use an and function to combine both the two conditions into one.

    I have made the following flow for your reference.

    Add a trigger button.

    Get items from list11. There are two Boolean column named as Status and Status2 in the list.

    Add a Condition to check if the Status equals to false and Status2 equals to true with the following code:

    @and(equals(items('Apply_to_each')?['Status'], bool('false')),equals(items('Apply_to_each')?['Status2'],bool('true')))

    Under if yes branch, add action Get items 2 to get items from list 22.

    Add Condition2 to check if they have the same Title to filter out the one that needs to be updated. Select dynamic content Title from Get item and Get items 2.

    Under if yes branch, add action Update item to update corresponding item. Note, select dynamic content ID from Get items 2 (list22) for the Id field, other fields with dynamic contents from Get items (list11).

    Images for your reference.

     1.PNG2.PNG3.PNG 

     

    Best regards,

    Mabel

     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,304

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard