
Announcements
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 😊
I think first you need to convert array into string then use SubstringOf() function in Get Items. I have not tested this. Once i will sit in front of laptop will check and give you screens.
Thanks
Hardesh