Hi folks,
I'm trying to build a flow to retrieve data from SPO list using rest API. A filter query is used which filters on the column employee email. There can be large number of filter conditions (based on data send from canvas app). The overall URI looks like below:
https://site.sharepoint.com/sites/sitename/_api/web/lists/getbytitle('listname')/items?$select=column1,column2&$filter=(EmployeeEmail eq useremail1 or EmployeeEmail eq useremail2 or EmployeeEmail eq useremail3 or EmployeeEmail eq useremail4...)
The problem with this is, sometimes the number of users are huge (like 70+) and I receive below error from power automate:
Is there any other way to achieve this? I need to get list items specific to certain employees only as entire list is quite large. I've considered splitting API calls, but it will affect the performance of app. Any suggestions?
Thank you.
