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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Return file which are ...
Power Automate
Answered

Return file which are due to expire in 30 days

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi All,

 

I have a flow, which i was helped to build, that returns files when the retraining date is coming up. The problem i have is that it returns all the files which have a retrain date and i only want it to show me the files that will expire in 30 days of the retrain date.

 

ArturDj_0-1624434232438.png

 

I assume the filter array would need to be change to do this but i am not quite sure to what. This is what it currently looks like:

@And(not(equals(item()?['RetrainingDate'], null)),lessOrEquals(formatDateTime(item()?['RetrainingDate'],'dd-MM-yyyy'), formatDateTime(utcNow(),'dd-MM-yyyy'))). 

 

Thank you

 

Categories:
I have the same question (0)
  • Verified answer
    v-LilyW-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous 

    According to your description, you want to filter out the files that will expire in 30 days, but your formula does not reflect 30 days, so please modify the formula to and try again:

    @And(not(equals(item()?['RetrainingDate'],null)),lessOrEquals(formatDateTime(item()?['RetrainingDate'], 'yyyy-MM-dd'), addDays(utcNow(), 30, 'yyyy-MM-dd')))

    Best Regards

    If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 103 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 87

#3
trice602 Profile Picture

trice602 63 Super User 2026 Season 1

Last 30 days Overall leaderboard