You’re offline. This is a read only version of the page.
16
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.
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,
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:
Share
Report
All responses (
Answers (
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.
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. |
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
