Unanswered

Get Items Filter Query

(0) Share

Report

Posted on by NoNameOH

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.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

rsaikrishna

3,703 on at

Like (0)

Report

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 Solution. Marking 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.

Was this reply helpful? Yes No

js-dattics 98 on at

Like (0)

Report
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:

Greetings from Colombia.

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

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,

Was this reply helpful? Yes No