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 / Check the date in a flow
Power Automate
Answered

Check the date in a flow

(0) ShareShare
ReportReport
Posted on by 33

Hi

 

I want to make a flow where I compare the date of today with the date in the list.

The goal of the flow is to check the date that a licence expieres, with the flow I should get an email when it's a month from expiering. It should run once a day.

 

Thanks!

Categories:
  • v-duann-msft Profile Picture
    Microsoft Employee on at

    Hi @Double_v 

     

    Thank you for posting.

     

    According to your description, you would like to send email based on date comparing with utcnow().

     

    If that’s the case, please refer below flow.

    formatDateTime(items('Apply_to_each')?['ExpiryDate'],'yyyy-MM-dd')

    formatDateTime(addDays(utcNow(),30),'yyyy-MM-dd')

    v-duann-msft_0-1622451484898.png

     

    If you have any further detailed requirement, you just need to reply me.

     

    Hope the content above may help you.

     

    Best regards,

    Anna

  • Double_v Profile Picture
    33 on at

    Hi @v-duann-msft 

     

    Thanks for the fast response.

    I would like to get multiple items in my list, so if multiple licence expieres I only get 1 email.

     

    Thanks

  • v-duann-msft Profile Picture
    Microsoft Employee on at

    Hi @Double_v 

     

    You can modify flow as below:

     

    formatDateTime(item()?['ExpiryDate'],'yyyy-MM-dd')
    formatDateTime(addDays(utcNow(),30),'yyyy-MM-dd')
    v-duann-msft_0-1622453385845.png

      

    Here is my list btw:

    v-duann-msft_1-1622453404625.png

     

    The result:

    v-duann-msft_2-1622453442124.png

     

    v-duann-msft_3-1622453504654.png

     

    Hope it helps.

     

    Best regards,

    Anna

  • Double_v Profile Picture
    33 on at

    Hi @v-duann-msft 

     

    The flow is verry good the only problem I have now is that I want to do a query filter at Get Items but when I try to create a query it always fails. Is there a good way to solve this?

     

    Thanks!

  • Double_v Profile Picture
    33 on at

    The problem with the query I already solved but now I see this in my mail.

    Double_v_0-1622460121877.png

     

  • v-duann-msft Profile Picture
    Microsoft Employee on at

    Hi @Double_v 

     

    Could you please share me your flow? It looks like you insert array variable or something similar? 

     

    Hope to hear from you soon.

     

    Best regards,

    Anna

  • Double_v Profile Picture
    33 on at

    Hi @v-duann-msft 

     

    This are pictures of my flow.

    Double_v_0-1622540070805.pngDouble_v_1-1622540132498.png

     

    Thanks!

  • Verified answer
    v-duann-msft Profile Picture
    Microsoft Employee on at

    Hi @Double_v 

     

    Thank you for update.

     

    The issue is caused by unnecessary 'apply to each' around 'create html table'. Please help to follow my flow and input item()?['columnname'] one by one manually. We shouldn't configure looping here. 

    v-duann-msft_0-1622540302886.png

     

    Best regards,

    Anna

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 321 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 244

#3
Henil Profile Picture

Henil 102

Last 30 days Overall leaderboard