cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

How to retrieve specific value from List

Hi All,

 

I need to know the best way to retrieve the a specific value from a list, based on two variables.

Below is the list.

 

So in My flow, I would be iterating through some docsets, I calculate two variables, the ContentType and the condition that has been met (ie 180daysprior, 120daysprior, etc).

 

I then need to retrieve the value stored at that intersection

 

So for example, from below picture, I need to get the value at "Content Type" equals "Customer Contract" and the condition of "Overdue" which return the value of "Red"

 

Is there an efficient way to achieve this.  

 

I could filter the list on Content Type, but then how do i retrieve the specific condition?

 

 

monitoredcondition.PNG

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @wpeers ,

 

Does your issue still exists?

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Jcook
MVP

Hello @Anonymous 

 

When you filter in the content type. Then you can use a apply to each loop, than you pass the value from the SharePoint list and you can use the dynamic content to find the values for that record


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





v-alzhan-msft
Community Support
Community Support

Hi @Anonymous ,

 

What is the type of the OVERDUE column?

Could you please share the screenshot of the configuration of the flow?

Could you please explain more details about your requirement?

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @wpeers ,

 

Does your issue still exists?

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (5,505)