Answered

Not every expired item appears in sent email

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi again!

I've created a flow that sends an email whenever there are expired items within the document library. However, I've noticed a problem. Within the document library, there are roughly about 7 items that have expired as you can see below:

However, in the email that has been triggered to be sent out, only 2 of these 7 expired items show up:

For reference, here is my flow:

How do I make it so that all the expired items show up in the email table? Is it because the document library has too many items (around 200 documents)? Thank you in advance!

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

v-LilyW-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous
Get files (properties only) returns 100 records by default.
If you files more than 100, you can increase this limit up to the list view threshold limit of 5,000 as below:

For more info about the limits of Get items or Get files, you can refer to:
https://docs.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/working-with-get-items-and-get-files
Hope the content above may help you.
Best Regards
If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thank you so much for this! Now it works:

Was this reply helpful? Yes No
v-LilyW-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous
You're welcome ! 😀
Best Regards.

Was this reply helpful? Yes No