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

(0) Share

Report

Posted on by Nisha_Innola

117

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

bengo83 159 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Nisha_Innola 117 on at

Like (0)

Report
Copy link

Link copied!

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??

Was this reply helpful? Yes No
bengo83 159 on at

Like (0)

Report
Copy link

Link copied!

Hi @Nisha_Innola

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

Does this work for you?

King regards
Beny

Was this reply helpful? Yes No
Nisha_Innola 117 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No