Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

How to copy a field value from one SharePoint list to another list based on condition in PowerApps

(0) ShareShare
ReportReport
Posted on by 87

Hello All,

I need a help in PowerApps please.

I have column value in a SharePoint list1 which needs to be copied to another list 2 with the same column name in the same SharePoint based on the condition in SharePoint List2.

 

For Example,

If the column name is G-No and value is 123 in List 1.

This needs to be copied to List 2 in G-No column based on the condition that col1 in List 2 >5 and Col 2 in List 2= "Yes".

And the values in the G-No should be copied to List 2 line by line without duplicate of the value in List 2.

Can anyone help me out with this please?

  • Nisha_Innola Profile Picture
    Nisha_Innola 87 on at
    Re: How to copy a field value from one SharePoint list to another list based on condition in PowerApps
    Hello Bengo83, Thank you for your reply. But the value should be copied from List1 to List 2 based on a condition that col1 in List 2 >5 and Col 2 in List 2= "Yes". And the value copied should not create as new line item but should be copied in the same line item when the condition is valid. Can you please help me on this?
  • bengo83 Profile Picture
    bengo83 159 on at
    Re: How to copy a field value from one SharePoint list to another list based on condition in PowerApps

    Hi @Nisha_Innola 

    I think the easiest way to do this is with a Powerautomate Flow like this one:

    bengo83_0-1711613608771.png

     

    Does this work for you?

     

    King regards

    Beny

     

     

     

  • Nisha_Innola Profile Picture
    Nisha_Innola 87 on at
    Re: How to copy a field value from one SharePoint list to another list based on condition in PowerApps

    Hello, 

    Thank you for your reply.

    Yes I just want to copy a value from one List1 to List 2 , whenever I load values in the Column G-No in List 1

    Can you please help me with some solutions??

  • bengo83 Profile Picture
    bengo83 159 on at
    Re: How to copy a field value from one SharePoint list to another list based on condition in PowerApps

    Hi @Nisha_Innola 

     

    Can you give more information about the case? If you just want to copy a value from one Sharepoint list to an other Sharepoint list, i think better to use Powerautomate. 

     

    King regards

    Beny

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,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard