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 / Copy one to another us...
Power Automate
Answered

Copy one to another using flow and expression

(0) ShareShare
ReportReport
Posted on by 4

Hello,

I am new with PowerApps and flow.

I need to copy all values from one SP list to another but I want to change the structure of the new list (less columns).

I stuck on creating flow that will check the condition:

 

Example:

Old List

Column__A - Name of app

Columnt_B - revised name of the app

New List

Column_A - Name of app

 

Column_A in old list always has values, Column__B may be empty. 

 

I want to merg data from Column_A and Column_B from Old list to Column_A in new list. 

 

I need to write an Expression that will check (during Create Item flow) if Column_B in Old list is empty and then copy Column_A from Old List to Column_A in new list.

 

IF(Column__B=empty, copy Column_A) else copy Column_B)

 

I hope it is understandable.

 

Regards,

Marcin

Categories:
I have the same question (0)
  • Verified answer
    v-liwei-msft Profile Picture
    Microsoft Employee on at

    Hi @WoMasta 

     

    I have made a test for your reference:
    1.

    vliweimsft_0-1665045095661.jpegvliweimsft_1-1665045102656.png

    2.

    vliweimsft_2-1665045120743.jpeg

    3.

    vliweimsft_3-1665045130355.jpeg

    4.

    vliweimsft_4-1665045144953.png

     

    Best Regards,

    Levi

     

     

     

     

  • WoMasta Profile Picture
    4 on at

    Hi,

    thank you very much for this, I will test it.

     

    Regards,

    Marcin

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 March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Vish WR Profile Picture

Vish WR 873

#2
Valantis Profile Picture

Valantis 813

#3
Haque Profile Picture

Haque 526

Last 30 days Overall leaderboard