Skip to main content

Notifications

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / I'm STUCK!! Copy data ...
Power Automate - Building Flows
Answered

I'm STUCK!! Copy data from list1 column2, on list2 column2 based on same column1 data

(0) ShareShare
ReportReport
Posted on by virgula 16

I have 2 sharepoint lists, let's call them list1 and list2. Each list has 2 columns 

list1 column1 has apple, banana, and cherry, and column2 has some, few, a lot relevant to each fruit.

list2 column1 has strawberry, banana, and mango, and on column2 its empty.

 

What I want is, if the fruits on list1 matches with the fruits on list2, update the second column on list2 with the relevant data on list1 column2. 

I have no idea how to fix this, both columns on both lists being single line of text.

 

Thanks a lot.

  • Verified answer
    v-yetonggu-msft Profile Picture
    v-yetonggu-msft on at
    Re: I'm STUCK!! Copy data from list1 column2, on list2 column2 based on same column1 data

    Hi @virgula ,

    Please check the source of the dynamic content filled in your Update item control.

    vyetonggumsft_0-1698053347975.png

    And only one value returned is true:

    vyetonggumsft_2-1698053512288.png

    Best Regards,

    Sunshine Gu

     

  • virgula Profile Picture
    virgula 16 on at
    Re: I'm STUCK!! Copy data from list1 column2, on list2 column2 based on same column1 data

    virgula_0-1698052141397.png

     

    @v-yetonggu-msft I swear I can't understand what's happening. I'm following the same things exactly, but still it doesn't work.

    virgula_1-1698052243825.pngvirgula_2-1698052254633.png

    When i run the flow, it's successful, but it returns each value as false:

    virgula_3-1698052320567.png

     

     

  • v-yetonggu-msft Profile Picture
    v-yetonggu-msft on at
    Re: I'm STUCK!! Copy data from list1 column2, on list2 column2 based on same column1 data

    Hi @virgula ,

    I have a test for your reference.

    In my scenario:

    vyetonggumsft_0-1698050353181.png

    vyetonggumsft_1-1698050433154.png

    vyetonggumsft_2-1698050859657.png

    My SharePoint List1 and List2:

    vyetonggumsft_3-1698050954102.png

    vyetonggumsft_4-1698050965788.png

     

    Best Regards,

    Sunshine Gu

  • virgula Profile Picture
    virgula 16 on at
    Re: I'm STUCK!! Copy data from list1 column2, on list2 column2 based on same column1 data

    it doesn't work. When i run the test, and i don't add any if true or if false, the output of the condition is always false.

    in get items i've added list1, get items2 list2, in the first apply to each is list2, and the second apply to each is list1.

    In the condition the uniq11 is the first column on list 2, and the uniq1 is the first column on list1

     

    virgula_0-1698049974321.png

     

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans