Compare two lists and avoid apply to each loops

(1) Share

Report

Posted on by FC-26071453-0

Hi everyone,

I'm working with two lists:

Sharepoint list Partners, with Name of partner & Risk (text columns)
Excel table Partners, with Name of partner & Risk

I try to copy the risk in excel to the corresponding partner in Sharepoint list. I made it with get items > apply to each > filter array 'Name eq Name' > update item.

Problem : with this solution, I have two apply to each, and when I run this flow I got warnings because I exceed 10k actions.

Any idea how to get rid of one apply to each ?

Thanks for your help !

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

FC-26071453-0 4 on at

Like (0)

Report
Copy link

Link copied!

Hello everyone,

Any help would be greatly appreciated. I'm still working on this issue.

Thanks!

Was this reply helpful? Yes No
takolota1 4,980 Moderator on at

Like (0)

Report
Copy link

Link copied!

This should only take 1 Apply to each at most.

You probably have an extra SP list reference somewhere where you should only be referencing the Filter array items & Excel.

I’m assuming your Filter array From input is the SP values.

Then the conditional should be an expression & a dynamic content.

item()?[‘Name’] eq InsertExcelDynamicContentForName

Then your Update item action should only have Filter array & Excel references.

Like body(‘Filter_array’)[‘ID’]

Was this reply helpful? Yes No
Anil_g 668 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi

chamge the flow as below

1. get list items

2. list rows from table

3. for eaxh on list items step 1

4. Inside that use filter array on excel list rows

5. if output count of step 4 is greater than 0 then update list else do nothing

cheers

Was this reply helpful? Yes No