cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
confusedintern
New Member

Not every expired item appears in sent email

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:

confusedintern_1-1627280603990.png

 

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

confusedintern_2-1627280632390.png

 

For reference, here is my flow: 

confusedintern_6-1627280982423.png

confusedintern_5-1627280818177.png

 

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!

1 ACCEPTED SOLUTION

Accepted Solutions
v-LilyW-msft
Microsoft
Microsoft

Hi @confusedintern 

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:

vLilyWmsft_1-1627282535641.png
vLilyWmsft_0-1627282419086.png

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-g...

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.

View solution in original post

3 REPLIES 3
v-LilyW-msft
Microsoft
Microsoft

Hi @confusedintern 

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:

vLilyWmsft_1-1627282535641.png
vLilyWmsft_0-1627282419086.png

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-g...

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.

View solution in original post

Thank you so much for this! Now it works:

 

confusedintern_0-1627284012949.png

 

Hi @confusedintern 

You're welcome ! 😀

Best Regards.

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,482)