cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wpeers
Frequent Visitor

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
Super User
Super User

Hello @wpeers 

 

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 @wpeers ,

 

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.

View solution in original post

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!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (1,170)