cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

List Resources by Subscription

Hi

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: List Resources by Subscription

 

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,

Community Support Team _ Barry
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

4 REPLIES 4
Highlighted
Community Support
Community Support

Re: List Resources by Subscription

 

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.

139.PNG

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,

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

Re: List Resources by Subscription

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.

Highlighted
Community Support
Community Support

Re: List Resources by Subscription

 

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,

Community Support Team _ Barry
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

Highlighted
Helper I
Helper I

Re: List Resources by Subscription

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"

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Kudoed Authors
Users online (8,082)