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 : R6oWDgQm4vk1XHLkYq5Mr9
Power Automate - Building Flows
Answered

flow for an automated email to be sent out on the date in cell which matches todays date

Like (0) ShareShare
ReportReport
Posted on 15 Jun 2023 22:11:40 by 18

hi 

I am struggling to create a flow that will do the following:

- send an email daily by scanning the online Excel spreadsheet (specific date column) and sending it to the cells containing the same date as today's date.

 

thanks in advance

 

  • Verified answer
    v-qiaqi@microsoft.com Profile Picture
    on 19 Jun 2023 at 09:14:39
    Re: flow for an automated email to be sent out on the date in cell which matches todays date

    Hi @N53,

    1). You refer to the Date here, however you refer to date in the filter query of the list rows present in a table, please pay attention here to troubleshoot.

    vqiaqimsft_0-1687165369067.png

    vqiaqimsft_1-1687165452481.png

    2). The DateField in my excel table named Date, and it is a Date column format using "/" as below:

    vqiaqimsft_2-1687165707968.png

    So I formate it to match to the ISO8601 as:

    formatDateTime(utcNow(),'yyyy/MM/dd')

    vqiaqimsft_4-1687165956963.png

    Here you should compare it with your scenario, if you use "-", you should modify it as formatDateTime(utcNow(),'yyyy-MM-dd')

     

     

     

  • N53 Profile Picture
    18 on 19 Jun 2023 at 08:55:05
    Re: flow for an automated email to be sent out on the date in cell which matches todays date

    error3.png

  • N53 Profile Picture
    18 on 19 Jun 2023 at 08:53:16
    Re: flow for an automated email to be sent out on the date in cell which matches todays date

    error 2.png

    e3df0613-d936-4f55-ba5e-a7720ad9a688.png

  • v-qiaqi@microsoft.com Profile Picture
    on 19 Jun 2023 at 08:42:55
    Re: flow for an automated email to be sent out on the date in cell which matches todays date

    Hi @N53,

    Please show me the configuration of the list rows present in a table and show me the completed formula you write for the filter query in this action.

     

  • N53 Profile Picture
    18 on 19 Jun 2023 at 08:41:04
    Re: flow for an automated email to be sent out on the date in cell which matches todays date

    thanks, I have followed all your steps but having no luck

  • v-qiaqi@microsoft.com Profile Picture
    on 19 Jun 2023 at 08:34:30
    Re: flow for an automated email to be sent out on the date in cell which matches todays date

    Hi @N53,


    @N53 wrote:

    hi

     

    formatting in the spreadsheet (source data) is same as 'yyyy-MM-dd'.

     

    how does the flow know which column to look for the date to match the todays date?


    We need to hard code it, which means you should enter the following in the filter query:

    DateField eq <date_formula>

     

    What's more, I don't know how you write the formula.

    Please DO check  my first reply and write the filter query as I mentioned in the list rows present in a table.

     

  • N53 Profile Picture
    18 on 19 Jun 2023 at 08:27:01
    Re: flow for an automated email to be sent out on the date in cell which matches todays date

    hi

     

    formatting in the spreadsheet (source data) is same as 'yyyy-MM-dd'.

     

    how does the flow know which column to look for the date to match the todays date?

  • N53 Profile Picture
    18 on 19 Jun 2023 at 08:25:35
    Re: flow for an automated email to be sent out on the date in cell which matches todays date

    flow error message.png

  • v-qiaqi@microsoft.com Profile Picture
    on 19 Jun 2023 at 01:50:12
    Re: flow for an automated email to be sent out on the date in cell which matches todays date

    Hi @N53,

    Please post a clear scrrenshot, I could not capture the error from this blurred one.

     

    Further, if the error is related to the date format, please do check my formula and keep the date format as ISO8601, which expects the date as 'yyyy-MM-dd'.

  • N53 Profile Picture
    18 on 16 Jun 2023 at 10:50:05
    Re: flow for an automated email to be sent out on the date in cell which matches todays date

    this was the error code when i used your flow

    flow error.png

     

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

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2