Please just take a try with the data operations –Filter array action.
Using this action could help reduce the number of objects in an array to a subset that matches the criteria you provide.
Here is the doc for your reference:
thanks for your reply.
Unfortunately, the HTTP action returns an object and thus I can't get the filter action to work.
gives the following error:
Changing the expression to @contains(body('HTTP')['value']['mail'], 'com')
I also tried putting the filter condition in the expression of the Select action but also to no avail:
There must be something I'm getting wrong that I'm not seeing.
I ran into this topic while trying to find out how to filter HTTP REST requests in combination with Business Central. You can filter the results of your HTTP request by conforming to the API guidelines specified in the following documentation: https://github.com/Microsoft/api-guidelines/blob/master/Guidelines.md#97-filtering.
Your filter will look as below. In the query, use $filter as parameter instead of the fields. Your value will contain the complete REST filter string.
When executed, it looks as following:
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!