web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Not all expiry dates returns!

(0) ShareShare
ReportReport
Posted on by

Hi All!

 

I'm currently building a flow that "reads" an entire sharepoint document list and returns back the name of the document + expiry date within an email. The flow runs daily at 7:30am to detect if anything has expired. Currently for this particular list, not all the expired documents are returned back within the email: 

userneeds_help_0-1646191219377.png

(these are the items that have expired)

 

userneeds_help_1-1646191247080.png

(only this item is returned in the email) 

 

Some details of my current flow include: 

userneeds_help_2-1646191313091.png

Get files with the threshold already set to 500 (above the document library number) 

 

userneeds_help_3-1646191346440.png

Filter array (makes sure the expiry date captured is less than or equal to the current date) 

userneeds_help_4-1646191393709.png

Condition that runs only if there's an expiry date due

 

userneeds_help_5-1646191448687.png

The flow for the email table

 

I don't know if there's anything I'm missing! Please help. Thank you so much! 

 

 

 

I have the same question (0)
  • MJain Profile Picture
    2,450 on at
    Re: Not all expiry dates returns!

    Hi @Anonymous ,

     

    Can you please check what is the output of filter array , I guess that is where you are getting only 1 record. Also please post the filter conditions you are using .

     

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 544 Moderator

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 482 Super User 2025 Season 2

#3
chiaraalina Profile Picture

chiaraalina 287

Last 30 days Overall leaderboard