Answered

Not every expired item appears in sent email

(0) Share

Report

Posted on by Community Power Pla...

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!

All responses (3)

Answers (1)

v-LilyW-msft on at

Like (0)

Report

Re: Not every expired item appears in sent email

Hi @Anonymous
You're welcome ! 😀
Best Regards.
Community Power Pla... on at

Like (0)

Report

Re: Not every expired item appears in sent email

Thank you so much for this! Now it works:
Verified answer

v-LilyW-msft on at

Like (0)

Report

Re: Not every expired item appears in sent email

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.