I have this app working which has data from users, which actually are students.
By now there are around 400 students that are using the app.
I would like to send an email to each of these students once a new item is created in another Sharepoint list.
Problem is I once used the get items action from the SharePoint connector and it just pulled out like 200 items from a 2000 items list...
How could I manage for a way to kind of loop the get items to a way that it captures aaaall the students that are in the list just once and send them the email I need?
Is this possible? what are your thoughts on this?
Thanks in advance!
Solved! Go to Solution.
I think this would be limitation for the Get Item in Power Automate. In that case, you can try to call all the list items from the SharePoint REST API using "HTTP Request" card in Power Automate.
Please refer to the following SharePoint REST API information:
Working with lists and list items with REST: https://docs.microsoft.com/en-us/sharepoint/dev/sp-add-ins/working-with-lists-and-list-items-with-re...
How to get all items in a view using REST API: https://sharepoint.stackexchange.com/questions/135936/how-to-get-all-items-in-a-view-using-rest-api
Hope this helps.
Have you tried modifying the settings of the 'Get Items' action like the below? please try to use the pagination and Threshold settings to get all the items. This will have an impact on performance.
Hope it helps, please like it or mark it as a solution if it resolves ur clarification or issue
Also if the number of items is less than 5,000 and no expectation to grow over this figure, there is a simple solution that does not require to activate pagination. The trick, valid for both 'Get items' and 'Get files (properties only', is to declare 5,000 as Top Count input (default is 100 if left empty) as explained in this excellent post:
Hope this helps