Copy item list 1 to list 2 according to conditions

(0) Share

Report

Posted on by Ben-00-38

176

Hello,

I have two sharepoint lists.

I want to copy the value of list1 to list2 according to the number.value colum

list1 (userlist) fixbase with 10 000 items
number column name column

4 david

5 robert

6 tom

list2 (ticketlist) dynamicbase
number column name column

4 blank // david (to paste from list 1)

6 blank // tom (to paste from list 1)

4 blank // david (to paste from list 1)

the lists are used without app via windows.

Office 365 list and flow.

i want to fill name column in list2 according to number column

thanks

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!
@Ben-00-38 here is the flow

length(outputs('Get_items_2')?['body/value']) /*Compose formula*/

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

@Ben-00-38 Logic explained:
1. Get items from list 1
2. Iterate through each item in apply to each loop
2.1 Get items from list 2 with filter query Title eq 'current item'
2.2 Compose to check the length of results, if record found(e.g 4,5,6) then value will be 1 else 0
2.3 Check if length condition, if 1
2.4 Update item in list 2

Make sure you have unique results, if the Get items 2 will return more than 1 result then this will fail.
Hope this helps.

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Was this reply helpful? Yes No
Ben-00-38 176 on at

Like (0)

Report
Copy link

Link copied!

I must have made a mistake in flow can you verified my flow

detail

Was this reply helpful? Yes No
jinivthakkar 4,187 on at

Like (0)

Report
Copy link

Link copied!

@Ben-00-38 what is the error ?

Was this reply helpful? Yes No
Ben-00-38 176 on at

Like (0)

Report
Copy link

Link copied!

the flow is running but I don't have ATC.displayname and Chefvente.displayname arriving in list 2
I must have made a mistake in the feed.

I checked your feed.
I think my error comes from this line: in red

can you explain me this code.
thanks

Was this reply helpful? Yes No