Answered

Sharepoint with power automate

(0) Share

Report

Posted on by cheers1903

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?

Categories:

General topics

I have the same question (0)

All responses (9)

Answers (1)

Sort by

ScottShearer 25,290 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@cheers1903

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.

Was this reply helpful? Yes No
cheers1903 70 on at

Like (0)

Report
Copy link

Link copied!

this is the get item with advanced options

Was this reply helpful? Yes No
PowerAppsWizard 388 on at

Like (0)

Report
Copy link

Link copied!

Try to add brackets around each filter expression e.g. (Column le 'Something') or (Column eq null)

Was this reply helpful? Yes No
cheers1903 70 on at

Like (0)

Report
Copy link

Link copied!

I have done this. But it will not run now.

Was this reply helpful? Yes No
PowerAppsWizard 388 on at

Like (0)

Report
Copy link

Link copied!

Hi @cheers1903

The first closing bracket is wrong...

Correct would be:
(ExpiryDate le 'Outputs') or (ExpiryDate eq null)

Was this reply helpful? Yes No
cheers1903 70 on at

Like (0)

Report
Copy link

Link copied!

thanks for that. it now runs but the run is still not sending me all the expiries from the database list.

Any other thoughts?

Was this reply helpful? Yes No
cheers1903 70 on at

Like (0)

Report
Copy link

Link copied!

it has sent me exactly 100 expiries via email.
So i am guessing is that the limit it can send?

Was this reply helpful? Yes No
Verified answer

PowerAppsWizard 388 on at

Like (0)

Report
Copy link

Link copied!

Hi
See this post
https://powerusers.microsoft.com/t5/General-Power-Automate/What-is-the-maximum-limit-for-Get-Items-action-in-MS-flow-for/td-p/136275

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 😁

Was this reply helpful? Yes No
cheers1903 70 on at

Like (0)

Report
Copy link

Link copied!

thank you very much. works now.

Was this reply helpful? Yes No