How to retrieve specific value from List

[Anonymous]

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?

[Jcook]

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

[v-alzhan-msft]

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.

[v-alzhan-msft · Accepted solution]

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.