Unanswered

Filtering a sharepoint list then modifying

(0) Share

Report

Posted on by Community Power Pla...

Hi,

So I have a sharepoint list with several items (a lot of items in the future)

Instead of using 'Apply to each' on all of them I wanted to filter first since only specific ones are going to be potentially changed.

The 'changing' value is true if it's going to be changed by the flow and false if it isn't.

This was my original thought but then I realized there were two problems.

First off, when I used 'Apply to each' on the filtered array, none of the variables that the sharepoint list existed from the variable.

The second problem is that I don't know how I would update the sharepoint list.

The reason I'm doing this is because the 'Apply to each' function takes too long even with only 7 items. When it's at its shortest speed its fine but it varies in times between 1 minute and 9 minutes which is rather annoying.

Anyone know a solution? Or an alternative method of speeding up an 'Apply to each' function?

Currently it seems to be taking 3.5 minutes to go through 7 items (which all should immediately end because of 'Contition 6' being false....

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

ScottShearer 25,270 Most Valuable Professional on at

Like (1)

Report

@Anonymous

A much better approach might be to use an OData filter query rather than grabbing all of the items, filtering the array, etc.. The filter is applied prior to the items being returned. This will allow your Flow to run much more quickly and also help you avoid the 5000 item limitation - Flow will only retrieve a maximum of 5000 items unless you have a premium license. You'll also want to remember that SharePoint only returns 100 items by default.

Here is a link to a blog that discusses the use of OData filters

Here is a link to a blog that I wrote that discusses the 100 item default and the 5K limit.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@ScottShearer
Thanks ^^
Link proved very useful.
Just wondering, with boolean is this correct?
Tried looking the boolean version up but people were using links -

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report

@Anonymous

If the value that you are testing in your filter is an boolean, then you need to enter true or false in the expression window.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@ScottShearer
Thanks very much for the help.
I don't know whether power automate has changed but using formula 'true' doesn't work anymore and does work with 0 (false) and 1 (true) - just finished testing it
The filter was actually too good and caused errors by working too fast so i had to put a delay in 😂

Many Thanks!

Was this reply helpful? Yes No