Unanswered

ODATA Filter and HTML Table - Get Items based off of parameters

(0) Share

Report

Posted on by Salamander94

184

So I have an inventory app. I want it to email me every Monday morning with specific item quantities. At the moment, any item marked with an 'H' in the priority column is spit out in the email.

That's fine, but I don't need to see the item in the email if I have enough of it. For example, I only want to see items marked with 'H' less than or equal to the quantity of 1.

I'd also love to have a second parameter for the priority column. Like L, for example. I could make it so any item marked with L in the priority section and less than or equal to the quantity of 3 is spit out in the email. I'm not sure if that's possible though.

Thank you.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Salamander94 184 on at

Like (0)

Report

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (0)

Report

Hi @Salamander94 ,

I'm afraid I don't quite understand what you mean. I need a more detailed explanation to understand your needs.

But if you want to configure multiple filters, you could use “and” directly in Filter Query to configure multiple filters.

Please check this blog and get more details about Filter Query:

https://veenstra.me.uk/2018/11/12/microsoft-flow-filter-queries-in-sharepoint-get-items/

Correct the method I provided. When configuring Filter Query in List rows present in a table action, we can only configure a single filter, and temporarily do not support using “and” to configure multiple filters.

However, you could use Filter array to configure multiple conditions to filter records.

https://docs.microsoft.com/en-gb/power-automate/data-operations#use-the-filter-array-action

Please take a try.

Best Regards,

Was this reply helpful? Yes No
Salamander94 184 on at

Like (0)

Report

Okay thank you for the help!

Was this reply helpful? Yes No