cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
keyboardWrench
Helper III
Helper III

SharePoint Get Items Filter Result evaluate if Status is In Progress

Hello,

 

I have a SharePoint Get Items Filter Query that use a Variable for list of rows to be evaluated.

 

I want to check if all items in the filter have In Progress status if True I need to perform a step.

 

Any inputs are appreciated. 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Mira_Ghaly
Dual Super User II
Dual Super User II

@keyboardWrench 

Please use the below condition 

In the RHS of your condition use the below expression:

items('Apply_to_each')?['Status']['Value']

 

Mira_Ghaly_0-1602324336545.png

Hope this fix your problem!

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

3 REPLIES 3
Mira_Ghaly
Dual Super User II
Dual Super User II

@keyboardWrench 

Please use the below condition 

In the RHS of your condition use the below expression:

items('Apply_to_each')?['Status']['Value']

 

Mira_Ghaly_0-1602324336545.png

Hope this fix your problem!

If this post helps you with your problem, please mark your as Accepted solution.If you like my response, please give it a Thumbs Up.

Blog: here

View solution in original post

Hi @Mira_Ghaly  thank you 🙂

Hello @Mira_Ghaly 

 

How do I tweak this if my Odata Filter is ID eq 2.01,2.02 you expressions works perfectly if my filter is only one ID. I get below result if my filter result is more than 1 ID.

 

ConditionResults.jpg

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (2,837)