Loop through a SharePoint List or Library

[Bill44]

There are many use cases here.  Example:  I want to see which list items in an issues list in SharePoint are OPEN.  For every list item whose STATUS column equals OPEN, the FLOW ACTION should send an email to the person listed in the OWNER column.  This could be set to run once a week on a schedule.  

[Anonymous]

Hi,

Do you still need this?

I just did something like this.

1-Did a Recurrence for Monday mornings

2-Initialized a variable statusvar as a string equal to In Progress (yours is Open)

3-Get items from list

4-Condition Status Value is equal to statusvar

5-If yes, send an email to the assigned to person (this is within the apply to each statusvar = In Progress condition)

[WillyD44]

Thank you Joanna!  I've been learning a bit more about FLOW and yes, your solution above would work well.  Any reason I can't just run a condition witihn an apply to each that says 

IF Status column = Open, then send email?   Do I need to initialize the variable?

Kind regards,

Bill

[Anonymous]

Hi Bill,

Go ahead and try it.  It did not work for me but I think it should work. The variable always works for me. The other thing that's easy to do is to not pick Status Value when it's a choice field.  I've forgottent to do that twice 🙂

[dmorrell]

A better solution is to put the condition as an odata filter in the Get Items step. This minimises the data transfer and eliminates the need for the conditional statement.

[WillyD44]

Yes dmorrell, that does sound like a better solution. Thx!