cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Get Items Filter Query

I'm trying to filter the results from the sharepoint list i'm using in Get items. However, can't choose any List fields in the Dynamic Content. 

3 REPLIES 3
Dual Super User
Dual Super User

For Get Items action, Filter Query field accepts OData operations. 

 

In this field, you need to type SharePoint list column's internal names (manually) and place Odata operators. 

 

Here is a reference blog:

https://blog.velingeorgiev.com/powerautomate-and-sharepoint-odata-filter-queries

 

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted SolutionMarking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

 

Resolver I
Resolver I

Hi @NoNameOH 

As stated by @rsaikrishna, you should use OData for filtering queries.

 

It's very simple, if your list has a column named "Country", and you need to filter only "France", the OData is:

 

Country eq 'France'

 

If you need to filter numbers, it would be for example:

 

Quantity gt 5

 

 

The first parameter "eq" means "equal", the second ("gt") means "greater than".

 

You can however, dynamically change the OData value like this:

js-dattics_0-1595183767966.png

 

Greetings from Colombia.

Community Support
Community Support

 

Hi @NoNameOH ,

 

Can you share a screenshot of the Flow configuration to illustrate the problem you are experiencing now?

 

During configuration, sometimes it is impossible to directly obtain the Dynamic content, which may be due to the type mismatch or some other reasons.

 

You can try to add Compose action, and then see if you can fill Dynamic content in Compose.

 

In addition, we can also use the expression to get the field value. Please provide more details so that we can provide you with a suitable workaround.

 

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.

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (19,774)