Answered

List Resources by Subscription

(0) Share

Report

Posted on by Morke

I'm trying to use this Resource manager action in my flow and I get the response in a JSON
However, I need help understanding how to use the Advanced options in the Action like Filter

I want to be able to filter by resource type, for example, and only select certain types.

No matter what I try, I get an error saying the filtering expresion is wrong, and the documentation doesn't show any example.

Categories:

Using connectors

All responses (4)

Answers (1)

Sort by

v-bacao-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Morke ,

We could click Advanced options to configure multiple conditions in this action filter records.

For example, the following example can filter out items whose title is Test or ABC in the list.

Besides, you could check the following video and article to get the usage of Filter array:

https://www.youtube.com/watch?v=guBAtdAcNrM

https://www.alanps1.io/power-platform/flow-filter-array-on-multiple-parameters-using-and/

You could use Parse JSON action to parse the response so that you could filter the data:

http://johnliu.net/blog/2018/6/a-thesis-on-the-parse-json-action-in-microsoft-flow

Hope this helps.

Best Regards,
Morke 62 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,
It seems this Connector doesn't accept that kind of filter and I get an error when trying to use it

Invalid $filter 'False' specified in the query string.
Verified answer

v-bacao-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Morke ,

Please check this online doc and get more details about the filters which could be configured in Filter field.

https://docs.microsoft.com/en-us/rest/api/resources/resources/list#uri-parameters

Best Regards,
Morke 62 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @v-bacao-msft , spot on, that was the reference I needed.
For you all lazy that don't want to read the provided link:

to filter by Azure's Resource Type, instead of "type eq Microsoft.Compute/virtualMachines", you must use "resourceType eq Microsoft.Compute/virtualMachines"