I have created a database in sharepoint and create a power automate to send an email of expired dates. However, when i receive the email, with the table, the table does not show all the expired dates, there various missing. Could anyone help. is there a limit to the amount of entries that can be send via email etc?
thank you very much. works now.
Hi
See this post
Try this press the three dots at the get items action:
And turn On pagination and increase the threshold to max 100000
Maybe now solved 😁
it has sent me exactly 100 expiries via email.
So i am guessing is that the limit it can send?
thanks for that. it now runs but the run is still not sending me all the expiries from the database list.
Any other thoughts?
Hi @cheers1903
The first closing bracket is wrong...
Correct would be:
(ExpiryDate le 'Outputs') or (ExpiryDate eq null)
I have done this. But it will not run now.
Try to add brackets around each filter expression e.g. (Column le 'Something') or (Column eq null)
this is the get item with advanced options
Can you expand the actions in your Flow and post a screen shot? I assume that you are using a filter query and I need to see the query.