Hi,
I need to write an OData filter query in Get items from SharePoint list that allows me to check if the title (Title column in SharePoint list) of those items is in the array variable defined previously in the flow.
For example, I have a following SharePoint list items:
| ID | Title |
| 1 | Apple |
| 2 | Banana |
| 3 | Pear |
and the array Fruits in the flow with the following items ["Apple", "Banana", "Peach"].
How do I write a OData filter query that Gets items from the SharePoint list only with titles that are in the array. Contains() and SubstringOf() expressions do not seem to have this functionality.
Thank you 😊

Report
All responses (
Answers (