• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

My Online Training Hub

Learn Dashboards, Excel, Power BI, Power Query, Power Pivot

  • Courses
  • Pricing
    • Free Courses
    • Power BI Course
    • Excel Power Query Course
    • Power Pivot and DAX Course
    • Excel Dashboard Course
    • Excel PivotTable Course – Quick Start
    • Advanced Excel Formulas Course
    • Excel Expert Advanced Excel Training
    • Excel Tables Course
    • Excel, Word, Outlook
    • Financial Modelling Course
    • Excel PivotTable Course
    • Excel for Customer Service Professionals
    • Multi-User Pricing
  • Resources
    • Free Downloads
    • Excel Functions Explained
    • Excel Formulas
    • Excel Add-ins
    • IF Function
      • Excel IF Statement Explained
      • Excel IF AND OR Functions
      • IF Formula Builder
    • Time & Dates in Excel
      • Excel Date & Time
      • Calculating Time in Excel
      • Excel Time Calculation Tricks
      • Excel Date and Time Formatting
    • Excel Keyboard Shortcuts
    • Excel Custom Number Format Guide
    • Pivot Tables Guide
    • VLOOKUP Guide
    • ALT Codes
    • Excel VBA & Macros
    • Excel User Forms
    • VBA String Functions
  • Members
    • Login
  • Blog
  • Excel Webinars
  • Excel Forum
    • Register as Forum Member

Automatically Email Reminders from Excel with Power Automate

You are here: Home / Power Automate / Automatically Email Reminders from Excel with Power Automate
Power Automate Emails From Excel
February 24, 2022 by Mynda Treacy

We can automatically email reminders from Excel with Power Automate and there’s no programming required. You don’t even need to open the Excel file to trigger the emails to send! In the video and tutorial below we’ll look at a scenario where we have a list of tasks, and we want to automatically remind those responsible prior to the task due date.

Note: Requires Microsoft 365 and either OneDrive for Business or SharePoint.

Watch the Video

Subscribe YouTube

Automatically Email Reminders from Excel with Power Automate Step by Step

Below is a screenshot of my task list which is in an Excel table called Tasks:

excel task list table

The reminder date is a set number of days before the task due date. I want to send an email to the manager containing a list of their tasks when the reminder date falls due.

Launch Power Automate and Schedule Flow

Step 1: Your data must be in an Excel Table. Use the keyboard shortcut CTRL+T to format your data in a table or go to the Insert tab > Table.

Step 2: Save your Excel file on OneDrive for Business or SharePoint. Note: it doesn’t work with OneDrive Personal accounts, and you need a Microsoft 365 account.

Step 3: Login to OneDrive or SharePoint in your browser and navigate to Power Automate. Tip: if you don’t see Power Automate in the list of apps, click on ‘All apps’:

Launch Power Automate

Step 4: click on ‘Create’ and then choose ‘Scheduled cloud flow’:

create Power Automate scheduled cloud flow

Step 5: Name your flow and set the schedule. I want the reminders to be sent out daily:

Set Power Automate flow name and schedule

Step 6: You’ll now have one step in your flow for ‘Recurrence’:

Power Automate Recurrence step

Connect to Excel File with Power Automate

Click on + New step and choose ‘List rows present in a table’. Tip: if you don’t see this option in the list, you can filter it by clicking on the ‘Excel Online (Business)’ icon first.

Add new Power Automate step

Step 7: Choose the location OneDrive for Business or SharePoint:

choose file location

If you choose OneDrive, then the Document Library is also OneDrive. If you choose SharePoint, then the Document Library field is automatically populated for you.

Next, navigate to the file location and select the file. Note: there is a limit to the number of folders that will display in this list, so you may need to create a folder that appears near the top.

Lastly, select the table name containing your data. Remember, mine is called Tasks:

Power Automate List rows present in a table step

Step 8: Open the Advanced Options and add an ODATA filter for the ReminderDate field. Start by typing in the Filter Query field:  ReminderDate eq ‘

filter query

Then click on ‘Add dynamic content’, go to the Expression tab and in the formula bar enter this formula:

formatDateTime(convertFromUTC(utcNow(), 'E. Australia Standard Time'), 'yyyy-MM-dd')

Note: You can edit the time zone to your own using the time zones names listed here.

Filter query based on date with Power Automate

Lastly, set the DateTime format to ISO 8601:

Power Automate Advanced Options list rows present in a table

IMPORTANT: Note the expression in the filter query is surrounded by single quotes.

Extract Distinct List of Emails

Step 9: Next we need to get a distinct (unique) list of emails so that each person only gets one email. We do this by adding a select step. Click ‘Add Step’ and in the search box type ‘select’ and choose it from the list of actions:

Power Automate Add dynamic content

Click on Add dynamic content and choose Value from the list:

Power Automate Select Action

Click on the Text icon:

Power Automate Select Action Text icon

And choose Email from the list. Tip: enter the column name in the search field to filter the list:

Power Automate Select Action dynamic content

Step 10: Add a new step to compose a list of distinct emails. Tip: type ‘compose’ in the search filed to reduce the list of actions:

Power Automate Compose Action

Click on ‘Add dynamic content’ and go to the Expression tab and enter union()

Power Automate Union

Then click on the Dynamic Content tab to the left of the Expression tab and select ‘output’ from the list, then enter a comma and select ‘output’ again. You should have a formula like this:

Power Automate Compose union

Click OK to complete the formula for Compose.

Step 11: add a control

Power Automate add a control

And select ‘apply to each’:

Power Automate control apply to each

Click on ‘Add dynamic content’ and select ‘Outputs’ from the Compose step:

Power Automate apply to each

Extract Data for Email from Each Row

Step 12: Add an action:

Power Automate add filter action

To Filter array:

Power Automate add filter array

Click on ‘Add dynamic content’ and choose ‘Value’:

Power Automate filter array dynamic content

In the next fields choose ‘Add dynamic content’ and select ‘Email’ and ‘Current item’ as per the screenshot below:

Power Automate filter array current item

Generate HTML for Email

Step 13: Add an action to create a HTML table:

Power Automate create html table

In the From field enter dynamic content from the Filter array body:

Power Automate dynamic content for html table

Then ‘Show advanced options’ and change the Columns to Custom:

Power Automate html table custom columns

Enter names for the columns that you want in your table names in the Header column. And in the Value column enter expressions for the column names as they appear in the table using the item function like so:

item()['ColumnName']

Power Automate html table column expressions

Note that date fields need to be wrapped in the formatDateTime function otherwise they will appear as a date serial number in the email.

Create Email

Step 14: Add an action for sending the email. I’m using Office 365 Outlook:

Power Automate email action

Choose Current Item from Dynamic content.

Power Automate email dynamic content

Add a subject and then add dynamic content for the body by inserting the Output of the Create HTML table action:

Power Automate email current item

Click ‘Save’:

save Power Automate

Your completed flow should look like this:

Power Automate steps

Power Automate Emails From Excel

More Power Automate Posts

Category: Power Automate
Previous Post:5 Pro excel dashboard design tips5 Pro Excel Dashboard Design Tips
Next Post:Combine Files With Different Column Names in Power Querycombine files with different column names in power query

Reader Interactions

Comments

  1. Serene

    January 28, 2023 at 9:01 am

    I kept getting status code 400 and not sure how to fix this.

    “There is an unterminated strong literal at position 27 in ‘ReminderDate eq ‘2023-01-27’.\r\n Inner exception: There is an unterminated strong literal at position 27 in ‘ReminderDate eq ‘2023-01-27’.\r\n”

    Reply
    • Mynda Treacy

      January 28, 2023 at 12:59 pm

      Sounds like you’re missing a closing single quote on your expression.

      Reply
  2. Margaret

    January 26, 2023 at 8:41 am

    Hi
    I love all your videos and are well articulated. I tried replicating the above tutorial but on the 3rd step after adding List rows present in table, Select Data operation it does not present all the rows in the table. What can I do to fix this?

    Reply
    • Mynda Treacy

      January 26, 2023 at 11:02 am

      Step 3 is login and open Power Automate, so I’m not sure what you’re referring to.

      Reply
  3. Chris Rayers

    January 25, 2023 at 12:39 am

    This is absolutely brilliant.
    Thank you so much.
    It took me a few goes before I got it working – stupid things like a space on the end of the column header so it couldn’t be found, or missing the step to make the email a text field.
    But eventually it worked and I was able to expand on it a little to make it suit my requirements.
    Thanks for not only the video but the steps in the description

    Reply
    • Mynda Treacy

      January 25, 2023 at 9:38 am

      Great to hear it was helpful, Chris!

      Reply
  4. Kamlesh Dhuri

    January 12, 2023 at 12:09 am

    Getting Error as :

    Syntax error at position 19 in ‘ReminderDate eq2023-01-11’.
    inner exception: Syntax error at position 19 in ‘ReminderDate eq2023-01-11’.
    clientRequestId: e0458996-a2c9-44dc-87cd-d52c0344471a

    Reply
  5. Omkar

    January 10, 2023 at 5:08 pm

    Please help getting below error
    Syntax error at position 13 in ‘Reminder Date eq ‘2023-37-10”.
    inner exception: Syntax error at position 13 in ‘Reminder Date eq ‘2023-37-10”.
    clientRequestId: a9f74c1b-fe21-4e4b-a2ad-1445c2b04416

    Reply
    • Omkar

      January 10, 2023 at 10:25 pm

      This is resolved by referring other comments below, thanks!!!! However, flow is running successfully but not getting the mail, please help!

      Reply
      • Ann

        January 11, 2023 at 2:11 am

        This comment did you refer to? I’m getting the same error.

        Reply
      • Omkar

        January 12, 2023 at 4:30 am

        Hello Mynda,

        Could you please help with this?

        Thanks

        Reply
        • Mynda Treacy

          January 24, 2023 at 2:38 pm

          I’m not a Power Automate expert, sorry. You’re best to post your question in the Power Automate support forum: https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

          Reply
    • Harsh Sharma

      January 18, 2023 at 7:14 pm

      I am having the same issue…..

      Reply
  6. Lina

    January 9, 2023 at 11:42 am

    Hi Mynda,
    I followed your instruction to create a flow to send out reminder emails to providers based on the reminder dates, it worked really well until two providers have the same reminder date. If two providers have the same reminder date, the flow will send 4 emails out, 2 are correct, 2 are incorrect with mismatch information of the other provider.
    For example:
    Provider A, reminder date: 09/10/2023, Provider A@hotmail.com;
    Provider B, reminder date: 09/10/2023, Provider B@hotmail.com;
    on the reminder date:
    Provider A receives two emails one with correct information, one with information of Provider B

    I feel that this is should be an easy fix?

    It would be great if you knew how to fix this, if not I will go to the power automate forum.

    Thank you very much for creating this page, it has helped me a lot with my work.

    Reply
    • Mynda Treacy

      January 10, 2023 at 1:40 am

      Hi Lina,

      I’m not a Power Automate expert, sorry. You’re best to post your question in the Power Automate support forum: https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

      Mynda

      Reply
  7. Susie

    January 6, 2023 at 9:27 am

    I need something far simpler.
    Excel data columns:
    Project Name, Company, Contact Person, Contact Email, Date Entered, Follow up date.

    I need an email sent to me, on the follow up date, to tell me to contact the Contact person, at contact email, regarding the Project, when the followup date column is “today.”

    I’m doing-
    Recurrence- every day,
    List Rows present in a table
    (have tried all the different reformatting of dates)
    And even though I KNOW I have 2 that I need to get this email on, I get ALL false results!
    I don’t know what I’m missing and I’ve tried about 17 different people’s helps on this site and many others.

    Reply
    • Mynda Treacy

      January 6, 2023 at 5:58 pm

      Hi Susie,

      I’m not a Power Automate expert, sorry. You’re best to post your questions on the Power Automate support forum: https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

      Reply
  8. Cendy

    January 5, 2023 at 5:40 pm

    What if I want to send an email with attachments for each person according to the list

    Reply
    • Mynda Treacy

      January 6, 2023 at 5:59 pm

      Hi Cendy,

      I’m not a Power Automate expert, sorry. You’re best to post your questions on the Power Automate support forum: https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

      Reply
  9. Gabriela

    December 31, 2022 at 1:33 am

    Hi Mynda,

    Thank you so much for this detailed tutorial! I followed it and was able to successfully set up the flow (after some trial and errors that I was able to troubleshoot via comments here); however, I’m very inexperienced with expressions so I just want to make sure I understand what I’m filtering for in Step 8. Is it simply asking it to send the email to that person on that date that I have entered in the Reminder Date column?

    Also, I’m not sure what I should set my recurrence to. If I do ‘daily’ will it send the email every day or just on the date listed under ‘Reminder Date’? If I do weekly, will it pick up all the dates within that week or just the date that the flow is running? For example, if I have the dates listed of 2/19 and 2/21 and I run the flow on 2/20, will it send it to both?

    Thank you so much!

    Reply
    • Mynda Treacy

      January 24, 2023 at 2:41 pm

      Hi Gabriela,

      Sorry for the slow reply. I’ve been on vacation.

      In step 8 it is filtering the spreadsheet to only include dates that are = to today’s date (i.e. utcNow() returns today’s date). In terms of your other question, I’m not a Power Automate expert, sorry. You’re best to post your question in the Power Automate support forum: https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

      Mynda

      Reply
  10. M. Kanai

    December 29, 2022 at 6:27 am

    Hi, this looks like exactly what I need, but I’m getting an error I can’t seem to fix. The flow is failing in the Apply to Each phase with the following exceptions:

    The execution of template action ‘Apply_to_each’ failed: the result of the evaluation of ‘foreach’ expression ‘@outputs(‘Compose’)’ is of type ‘String’. The result must be a valid array.

    It looks like I need to change a String to an array, but I’m not sure how. Any thoughts? Thanks!

    Reply
    • Mynda Treacy

      January 10, 2023 at 1:41 am

      I’m not a Power Automate expert, sorry. You’re best to post your question in the Power Automate support forum: https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

      Reply
      • Serene

        January 15, 2023 at 4:56 am

        Followed the tutorial but kept getting this error message.

        There is an unterminated literal at position 26 in ‘ReminderDate eq’20231-01-14’.

        Double checked the expression, everything looks right. Not sure how to address this error. Pls assist.

        Reply
        • Mynda Treacy

          January 24, 2023 at 2:38 pm

          I’m not a Power Automate expert, sorry. You’re best to post your question in the Power Automate support forum: https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

          Reply
  11. Lim Wee Siang

    December 22, 2022 at 3:17 pm

    Thanks for your guidance, however i received below error message. Appreciate if can help.

    Action ‘List_rows_present_in_a_table’ failed

    Syntax error: character ‘‘’ is not valid at position 16 in ‘ReminderDate eq ‘2022-12-22’.
    inner exception: Syntax error: character ‘‘’ is not valid at position 16 in ‘ReminderDate eq ‘2022-12-22’.
    clientRequestId: d5e5b7a1-a63b-480e-be03-fbf7376a87d9

    Reply
    • Mynda Treacy

      December 22, 2022 at 3:44 pm

      Hi Lim,

      The error is telling you that you have a single quote in the wrong place or missing. Remember, you have to close the expression with a single quote. See the example image in the tutorial above.

      Mynda

      Reply
  12. justice

    December 22, 2022 at 12:55 am

    hello Mynda,
    Great tutorial, I have been able to replicate the flow however, i keep getting this error :
    Action ‘List_rows_present_in_a_table’ failed

    Invalid filter clause: cannot find the ‘ReminderDate’ column.

    clientRequestId: 007f7eab-cd0a-419f-b81e-a284284fdf1c

    serviceRequestId: 45445e0b-188a-4d4d-9d82-de8f6b89603d;8b3fa538-f1e5-44a4-9def-c51e767af1ed;bf61f0bd-eb46-42fa-ab7c-b648ec886d11

    please help.

    Reply
    • Mynda Treacy

      December 22, 2022 at 6:41 am

      Hi Justice,

      The clue is in the error message. It says it cannot find the ‘ReminderDate’ column. I suspect you don’t have a column with this name in your Excel file.

      Mynda

      Reply
  13. Hermes Emanuel Chavez Marin

    December 21, 2022 at 10:05 pm

    i tried this exactly but it did not work it seems like it does not pull the email at all because when i check the json for select it shows nothing

    Reply
    • Mynda Treacy

      December 22, 2022 at 12:44 pm

      There must be something different between my set up and yours. It may be a regional variation.

      Reply
  14. Mark

    December 7, 2022 at 8:25 am

    Thank you for this tutorial! Super helpful and detailed!

    I can successfully run my flow but am not receiving an email? I’ve mirrored your table at the start of the video, but when the flow runs successfully, I do not get one. I’ve also double checked spelling.

    Any advice to troubleshoot would be much appreciated.

    Reply
    • Mynda Treacy

      December 7, 2022 at 9:25 am

      If it’s identical in every way, then I’d say it has to do with the dates in the file. Note: you cannot use the TODAY() function to return a date relied upon by Power Automate.

      Reply
  15. Ellen

    December 1, 2022 at 7:07 pm

    Hi Mynda,
    this instruction is awesome! Thank you so much!
    Is there a way to get a reminder for all items that are either due today or in the past if the status is not “completed” or “cancelled” in my Excel table?
    Also, I added a link to some text in the email, but when I receive the email, there is no link. When I go back to the flow in edit mode, the link isn’t there anymore either. I have added the link and saved the flow again several times, but it does not work. Would you have any idea why that is?
    Thank you!
    Ellen

    Reply
    • Mynda Treacy

      December 2, 2022 at 9:54 am

      Hi Ellen,

      I’m sure you can do this, but it’s beyond my Power Automate expertise. You’re best to post your question in the Power Automate support forum: https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

      Reply
  16. Priyansh Sharma

    December 1, 2022 at 3:46 am

    Hi, thanks for such an illustrative demo. After lot of attempts i could finally run my flow successfully however am not getting any emails yet. Any suggestions?

    Reply
    • Mynda Treacy

      December 1, 2022 at 9:06 am

      Hi Priyansh, it’s difficult to troubleshoot when I can’t see your side of things. Try checking the dates are correct and keep in mind the time zone of the Power Automate server might be GMT. If that doesn’t help, post your question in the Power Automate support forum: https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

      Reply
      • Priyansh Sharma

        December 1, 2022 at 6:49 pm

        I have used UTC as suggested, for GMT do in need to do something different

        I am getting [ ] in Select and Compose

        Below is the output for List Row Below Table

        {“statusCode”:200,”headers”:{“Pragma”:”no-cache”,”Transfer-Encoding”:”chunked”,”Vary”:”Accept-Encoding”,”x-ms-request-id”:”ec391189-2b21-4cfd-8bdf-33899178a677;5148f7f1-8283-4a0a-86fc-cea7e673cae7;14229e19-27fb-4385-9f97-9a3da01cca72;c314e42e-8205-490b-9b46-68833df41344;40e4e0b5-4689-408d-a7d1-61e9938d006f;f9c19cb0-693d-447d-af4d-e39671fe6238″,”OData-Version”:”4.0″,”Strict-Transport-Security”:”max-age=31536000; includeSubDomains”,”X-Content-Type-Options”:”nosniff”,”X-Frame-Options”:”DENY”,”Timing-Allow-Origin”:”*”,”x-ms-apihub-cached-response”:”true”,”x-ms-apihub-obo”:”false”,”Cache-Control”:”no-store, no-cache”,”Date”:”Thu, 01 Dec 2022 06:50:57 GMT”,”Content-Type”:”application/json; odata.metadata=minimal; odata.streaming=true”,”Expires”:”-1″,”Content-Length”:”294″},”body”:{“@odata.context”:”https://excelonline-wus.azconn-wus.p.azurewebsites.net/$metadata#drives(‘b%21sg-WwmD4-0C9qW-1_tkvzZXC-MOYeS9Ogt7ERGhDfmezJR_hANSxSYylZ-MZZpt_’)/Files(‘014WKUSOSWGYOY6FQKIFBYZ7YFCLGH2OL3’)/Tables(‘%7B20F2C41C-9DA1-412F-9375-9AAD3A587827%7D’)/items”,”value”:[]}}

        Reply
        • Mynda Treacy

          December 1, 2022 at 7:02 pm

          I didn’t suggest to change the time zone, merely that the Power Automate server may use a different time zone to you which may explain why you haven’t received an email yet. Please post your question in the Power Automate forum, as you’ll find more experts there that should be able to help.

          Reply
        • Carl Reyes

          January 10, 2023 at 1:37 am

          Hello Priya, any chance you have made this work already? I’m getting the same error. Flow is successful however there is no email received yet. I am getting [] in compose and select also.

          Reply
  17. Victoria

    November 18, 2022 at 1:45 am

    Is there a way to add a recurrence to an existing flow?

    Reply
    • Mynda Treacy

      November 18, 2022 at 8:59 am

      I expect so, but I’m not a Power Automate expert, so you’re best to post your question in the Power Automate support forum: https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

      Reply
  18. Kamal

    November 4, 2022 at 11:02 pm

    Great job on this flow, very helpful. Thanks

    Reply
    • Mynda Treacy

      November 5, 2022 at 9:38 am

      Great to hear, Kamal!

      Reply
  19. TSTZ

    November 2, 2022 at 5:55 pm

    Thanks for the tutorial and it was a great help.

    But I keep having errors which stated as follows,

    InvalidTemplate. Unable to process template language expressions in action ‘List_rows_present_in_a_table’ inputs at line ‘0’ and column ‘0’: ‘In the template language function ‘convertFromUTC’, the value provided for the time zone id ‘E. Myanmar Standard Time’ was not valid.

    My Input formula is as follows,
    formatDateTime(convertFromUTC(utcNow(), ‘E. Myanmar Standard Time’), ‘yyyy-MM-dd’) Is it because of the Time Zone? or my formula?

    Reply
    • Mynda Treacy

      November 2, 2022 at 6:16 pm

      Hi,

      There’s no such time zone ID as “E. Myanmar Standard Time”. Your time zone is just “Myanmar Standard Time” as per the link to the list of time zone names linked to in the post above. Therefore, your code should be:

      formatDateTime(convertFromUTC(utcNow(), 'Myanmar Standard Time'), 'yyyy-MM-dd') 

      Hope that helps.

      Reply
      • TSTZ

        November 3, 2022 at 2:41 pm

        Thanks for the help!!

        I changed the Time Zone as per your instructions and the error changes as follows.

        Syntax error: character ‘‘’ is not valid at position 16 in ‘ReminderDate eq ‘2022-11-03”.
        inner exception: Syntax error: character ‘‘’ is not valid at position 16 in ‘ReminderDate eq ‘2022-11-03”.
        clientRequestId: b0aad91b-b126-4671-8c69-29c0039627dd

        My Input formula changes into :
        formatDateTime(convertFromUTC(utcNow(), ‘Myanmar Standard Time’), ‘yyyy-MM-dd’)

        Another issue is when I try to build a new flow, ‘Add dynamic content’ Tab didn’t show up and I cannot input formula anymore.

        Reply
        • Mynda Treacy

          November 3, 2022 at 9:24 pm

          The error is telling you that you have a single quote, or maybe it’s a double quote, in the wrong place. As for your other question, you’re best to post your question in the Power Automate support forum: https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

          Reply
  20. Lily Zhang

    October 27, 2022 at 4:03 pm

    It’s great and it helps me a lot, thank you.
    I still have an issue that I set up the reminder date as a formular according to the approval status, the reminder date always stays as TODAY so that I can receive the reminder every day until it is approved. but now I didn’t receive any reminder even the reminder date has changed to Today automatically, is it because of the formular template on the reminder date? could you help me on this? much appreciate !

    Reply
    • Mynda Treacy

      October 27, 2022 at 5:51 pm

      Hi Lily,

      The TODAY function only recalculates in the Excel file if the file is opened. Power Automate will only know if the the date has been updated if you open the file and save it again.

      Mynda

      Reply
      • Lily

        November 4, 2022 at 6:22 pm

        Hi Mynda,

        Thanks a lot for your reply, I tried to opened the file and saved it before the flow running time (I set up the running time as 10:00), and the reminder date has been changed to TODAY and I should receive the reminder at 10:00, but didn’t, can you help me on this?

        Reply
        • Mynda Treacy

          November 4, 2022 at 8:43 pm

          Hi Lily, I don’t advise using the TODAY function to return the date because it depends on the server date/time in the cloud when Power Automate runs the script. Best to put a proper date in.

          Reply
          • Lily

            November 7, 2022 at 6:59 pm

            Thanks a lot Mynda, I need the reminder date automatically changed according to the approval status, do you have any other better suggestion?

          • Mynda Treacy

            November 8, 2022 at 9:05 am

            Hi Lily, I’m not a Power Automate expert, so you’re best to post your question in the Power Automate support forum: https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

  21. Danelle Feuerbacher

    October 20, 2022 at 7:54 am

    Is there a way to recreate this on the desktop version of power automate?

    Reply
    • Mynda Treacy

      October 20, 2022 at 2:14 pm

      I’m not sure, Danelle. You’d have to give it a go. If you get stuck reach out to the Power Automate support forum: https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

      Reply
  22. jack

    October 17, 2022 at 8:07 pm

    Syntax error: character ‘‘’ is not valid at position 15 in ‘ ReviewDate eq ‘ 2022-10-17 ”.
    inner exception: Syntax error: character ‘‘’ is not valid at position 15 in ‘ ReviewDate eq ‘ 2022-10-17 ”.
    clientRequestId: c6edc547-3953-43e6-b618-d4684f723f3e

    Reply
    • Mynda Treacy

      October 18, 2022 at 8:02 am

      Hi Jack,

      The clue is in the error message. The single quote is not in the right position. Maybe there’s a space before/after it, maybe you copied the character from somewhere else and it’s not recognised. Try typing it in again.

      Mynda

      Reply
  23. Andy

    September 28, 2022 at 9:55 pm

    Is this also possible in Power bi?

    Reply
    • Mynda Treacy

      September 29, 2022 at 9:13 am

      Not sure, Andy. I don’t think there are Power BI connectors like this in Power Automate, but you’d have to check.

      Reply
  24. Stephanie

    September 27, 2022 at 1:19 am

    I have modified my dates yet this still won’t work.

    ‘Note that date fields need to be wrapped in the formatDateTime function otherwise they will appear as a date serial number in the email.’

    What do you mean by the above statement? That my excel should be formatted to what?

    Reply
    • Mynda Treacy

      September 27, 2022 at 9:05 am

      In the Create HTML Table dialog shown in step 13 I am formatting how the information in the email will appear. Dates in Excel are actually stored as date serial numbers, not dd/mm/yyyy or mm/dd/yyyy. If you want to see them in the email correctly formatted, then you need to use the formatDateTime function, as shown in the this image:

      Reply
      • Resham Mal-Rushforth

        October 8, 2022 at 12:39 am

        I have created the flow but on the email it is only pulling the headers through and not the value, can you advise please?

        Reply
        • Mynda Treacy

          October 8, 2022 at 7:58 am

          It’s very difficult to diagnose. You’re best to post your question on the Power Automate support forum: https://powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity

          Reply
        • kang

          November 11, 2022 at 12:18 am

          Hi Resham, were you able to get the solution, i am also getting the same output. Flow runs without error but i get only headers in the email and no value ?

          Reply
    • Stephanie Grace

      September 27, 2022 at 5:04 pm

      This is the error, I keep getting
      Syntax error at position 27 in ‘ReminderDate eq’2022-09-27”.
      inner exception: Syntax error at position 27 in ‘ReminderDate eq’2022-09-27”.
      clientRequestId: 7e122428-36ed-4602-ade8-83031e060ccf

      Any help would be greatly appreciated.
      My Column is called ReminderDate on my excel.

      Reply
      • Mynda Treacy

        September 27, 2022 at 7:26 pm

        This usually means you haven’t entered the final single quote after the formatDateTime function.

        Reply
  25. Connie Young

    September 14, 2022 at 6:34 am

    I continue to get an error message for ‘List rows present in a table’ failed. It states “Syntax error at position 27 in ‘ReminderDate eq’2022-09-13”.
    inner exception: Syntax error at position 27 in ‘ReminderDate eq’2022-09-13”.”
    Am I to use the name of the column name on my

    Reply
    • Mynda Treacy

      September 14, 2022 at 8:29 am

      Hi Connie,

      “ReminderDate” in the formula should be the name of the column containing your reminder date in your file. Note that this column name should not have any spaces in it.

      Reply
  26. J

    September 8, 2022 at 12:24 am

    I’m getting the following error details when I run my test:

    A digit was expected at position 5 in ‘2022ExpirationDate eq 2022-09-07’.
    inner exception: A digit was expected at position 5 in ‘2022ExpirationDate eq 2022-09-07’.
    clientRequestId: a2c3c2ad-e606-4196-af97-4777cd4306cb

    Here’s the formula I’m using:

    2022ExpirationDate eq ‘formatDateTime(convertFromUTC(utcNow(), ‘Eastern Standard Time’), ‘yyyy-MM-dd’)’

    Help is greatly appreciated!

    Reply
    • Mynda Treacy

      September 8, 2022 at 7:52 pm

      Make sure you don’t have any empty cells in the date column. Also, change the date format from yyyy-MM-dd to MMM d, yyyy. This is not the date format of your file, it’s the date format Power Automate requires.

      Reply
  27. Garrett Duplant

    August 3, 2022 at 4:15 am

    Is there a way to format the HTML table that is displayed in the email?

    Reply
    • Mynda Treacy

      August 3, 2022 at 9:28 am

      Yes, in the ‘Send an email (V2)’ dialog box shown below you can use the formatting icons, or if you know HTML, you can code the formatting.

      Reply
      • Garrett

        August 4, 2022 at 5:24 am

        Do you have any examples on how to format the html table in an excel type format for coding?

        Reply
        • Mynda Treacy

          August 4, 2022 at 11:00 am

          No, sorry.

          Reply
      • Fahmi Dicki Risandi

        September 15, 2022 at 9:39 am

        My mail was rejected by email provider, how could it be?
        What should i do?

        Reply
        • Philip Treacy

          September 15, 2022 at 12:15 pm

          Hi Fahmi,

          What was the reason for the rejection?

          Regards

          Phil

          Reply
  28. pranav

    July 14, 2022 at 10:39 pm

    Hello,

    My flow test is successful. But the test output shows empty brackets [] for the ‘Select’ step. What could be the reason ?

    Reply
    • Philip Treacy

      July 18, 2022 at 9:17 am

      Hi Pranav,

      Hard to say without seeing your data and flow. What does your data consist of? What is the output from the ‘List rows present in table’ step?

      Regards

      Phil

      Reply
      • Liv Wilson

        August 16, 2022 at 12:11 pm

        Hi,
        Jumping on this comment as I’ve experienced the same thing. No error message, just empty brackets (and I’ve popped myself in the spreadsheet and aren’t getting the email). Here is the output of the ‘List rows present in table’ step:

        {“statusCode”:200,”headers”:{“Pragma”:”no-cache”,”Transfer-Encoding”:”chunked”,”Vary”:”Accept-Encoding”,”x-ms-request-id”:”0617f38e-a1be-463d-aff9-3851db18be19;eb9197d9-55ab-429a-8d62-8db303f560ca;c9474724-c315-4980-84a5-8d9ca1c8671e;49d99eb9-0cde-412d-bd5d-8dd4521ab6e3;8513c8e4-4068-4937-a00d-76fae8398ef3;2d8a4e3b-9610-432c-afe6-5a3e20432d63;a287d6bb-4de2-4855-a870-1b53e4493abf”,”OData-Version”:”4.0″,”Strict-Transport-Security”:”max-age=31536000; includeSubDomains”,”X-Content-Type-Options”:”nosniff”,”X-Frame-Options”:”DENY”,”Timing-Allow-Origin”:”*”,”x-ms-apihub-cached-response”:”false”,”x-ms-apihub-obo”:”true”,”Cache-Control”:”no-store, no-cache”,”Date”:”Tue, 16 Aug 2022 02:03:35 GMT”,”Content-Type”:”application/json; odata.metadata=minimal; odata.streaming=true”,”Expires”:”-1″,”Content-Length”:”294″},”body”:{“@odata.context”:”https://excelonline-ase.azconn-ase.p.azurewebsites.net/$metadata#drives(‘b%21-62Pkm2gmEujXOdrUjVl6V9c9m2RwSdLotBh6yu_UAlaHohNICggSbFzQUqtwi5U’)/Files(’01JUJWZXJHMRX2QBQM7VC3JHGPHTCOLGPI’)/Tables(‘%7BA143009E-1774-4BB5-BFF0-231164296B20%7D’)/items”,”value”:[]}}

        Reply
        • Mynda Treacy

          August 16, 2022 at 1:22 pm

          Like Phil said, it’s hard to say without seeing your data and flow. Make sure none of the column headers in Excel have spaces in them. Power Automate doesn’t like spaces!

          Reply
  29. manikishore

    July 9, 2022 at 2:07 pm

    i have two column with email ids of
    in To mail as per your procedure we can send

    but in cc mail how to send?

    Reply
    • Mynda Treacy

      July 9, 2022 at 5:21 pm

      Not sure, sorry. Best to ask in the Microsoft Power Automate community forum where someone can help you.

      Reply
  30. El Conquistador

    July 9, 2022 at 5:45 am

    Will this method work if you are using it to send email to email addresses that are outside of your organization?

    Reply
    • Mynda Treacy

      July 9, 2022 at 5:19 pm

      Yes.

      Reply
  31. Spring

    June 29, 2022 at 6:33 am

    Why you use ‘MMM d,yyyy’ after formatdatetime? not ‘MMM dd,yyyy’?

    It didn’t work for me, failed test, not sure where went wrong.

    Reply
    • Spring

      June 29, 2022 at 7:28 am

      The execution of template action ‘Create_HTML_table’ failed. The column values could not be evaluated: ‘In function ‘formatDateTime’, the value provided for date time string ‘44740’ was not valid. The datetime string must match ISO 8601 format.’.

      Here is error message. I tried all sort of format I think went wrong. but still same error message.

      I am on Eastern standard time zone.

      Thank you for your help!

      Reply
    • Mynda Treacy

      June 29, 2022 at 5:21 pm

      It’s not clear whether you used MMM d, yyyy or MMM dd, yyyy, but you should use MMM d, yyyy. Also, ensure the dates in your Excel file are formatted with your local date format.

      Reply
    • varun gupta

      September 8, 2022 at 5:53 am

      I faced the same issue. Found out that, In excel file if you are leaving any cell blank in DueDate or ReminderDate columns then it throws this error. The “formatdatetime” function does not understand the empty cell. So, you can add any date or any text in empty cells in excel file to resolve this. It worked for me.

      Reply
      • Mynda Treacy

        September 8, 2022 at 7:49 pm

        Thanks for sharing, Varun.

        Reply
  32. Danny

    June 26, 2022 at 10:38 pm

    thanks for this flow. Please provide information on how can we format hyperlinks within the table if one of the column has a hyperlink.

    Reply
    • Mynda Treacy

      June 27, 2022 at 9:42 am

      Hi Dany,

      I’m not sure, sorry. Best to ask on a Power Automate support forum.

      Mynda

      Reply
  33. Keith

    June 22, 2022 at 4:52 am

    Hi Mindy, this is a great tutorial. I was able to create the flow exactly as you described. But I have one issue, the email goes out to every email address that have the same reminder date.
    The only difference between your setup and the flow I created is that I am using and expression on my “due date” filter query to calculate the date the email is to be sent out. duedate eq ‘addDays(utcNow(), 2, ‘MMMM dd, yyyy’)’. Do you think that’s the reason it’s not filter the emails correctly?

    Reply
    • Mynda Treacy

      June 22, 2022 at 9:05 am

      Hi Keith, I’m not following the issue. The purpose of the flow is to send emails to the addresses that has the matching reminder date. You might be better off posting your question and sample Excel file on our forum where we can see what you mean: https://www.myonlinetraininghub.com/excel-forum

      Reply
    • Ceacila Guzzetti

      August 19, 2022 at 6:32 am

      Keith,
      I am having the same issue where each person with the same remind date is getting all emails for that remind date instead of only getting their specific email. Did you find a fix for this?

      Reply
      • Conor

        September 15, 2022 at 7:58 pm

        I am having the same issue also if anyone can shed some light please?

        Reply
        • Mynda Treacy

          September 15, 2022 at 8:42 pm

          Hi Conor, the best place for Power Automate help is in the official Power Automate community forum.

          Reply
  34. Sarah

    June 18, 2022 at 5:56 am

    Is it possible to add personalized attachments?

    Reply
    • Mynda Treacy

      June 18, 2022 at 8:59 am

      Possibly/probably. I don’t have any tutorials on that though.

      Reply
  35. Sarah

    June 18, 2022 at 5:39 am

    What if there are multiple rows that need to be sent individually to the same email? Wouldn’t this prevent that? Why would you only want to send 1 email per email address? That doesn’t really make sense….

    Reply
    • Mynda Treacy

      June 18, 2022 at 9:00 am

      If there are multiple lines that apply to the same email address they would be included in the one email.

      Reply
  36. Igor

    June 18, 2022 at 1:32 am

    Hi i’m trying to use it for a spreadsheet at work bu there’s something going on with the date time.

    Syntax error at position 11 in ‘Expire date eq ”17-06-2022’.
    inner exception: Syntax error at position 11 in ‘Expire date eq ”17-06-2022’.
    clientRequestId: cd59dc6b-c427-46e2-b068-76d7ee9524db

    The days are in front of the months because it’s a South America pattern.

    As for the formula:

    formatDateTime(convertFromUTC(utcNow(), ‘E. South America Standard Time’), ‘dd-MM-yyyy’)

    I’d like some help as soon as possible.

    Reply
    • Mynda Treacy

      June 18, 2022 at 9:09 am

      Hi Igor,

      Don’t worry about matching the expression to your date format. You’ll notice mine are also dd/mm/yyyy in my Excel file, but in my formatDateTime expression I have used yyyy-MM-dd. It’s only later when constructing the email html that you want to format to match your region.

      Mynda

      Reply
      • Igor

        June 20, 2022 at 8:54 pm

        Ok, no problem. I corrected that but it seems to have happened again. Trying to understand what happened.

        Syntax error at position 11 in ‘Expire date eq ‘2022-06-20”.
        inner exception: Syntax error at position 11 in ‘Expire date eq ‘2022-06-20”.
        clientRequestId: 23db5eb8-2b63-4531-bb9e-d38937b6ad58

        Reply
        • Mynda Treacy

          June 21, 2022 at 9:31 am

          I can’t tell you much more than the error you’re getting, which is there is a syntax error. This means the expression/formula is not correct. Check the expression. Check the header names in your file match those you’re referencing in your expression. Check you have the single quotes around the expression in the Filter Query field. Make a smaller sample file to see if you can narrow down the issue. Good luck.

          Reply
  37. Wessel

    June 16, 2022 at 6:58 pm

    Good day

    Please could you assist with following error – I tried everthing

    Syntax error: character ‘‘’ is not valid at position 18 in ‘ ReminderDate eq ‘2022-06-16’.
    inner exception: Syntax error: character ‘‘’ is not valid at position 18 in ‘ ReminderDate eq ‘2022-06-16’.
    clientRequestId: 44fae884-154f-4530-927c-b5d6a89a39c1

    I dont know wheter it is to do that when I start typing ReminderDate eq it doesnt give options:
    My data is as below:

    ReminderDate eq ‘@{formatDateTime(convertFromUTC(utcNow(), ‘E. Australia Standard Time’), ‘yyyy-MM-dd’)}

    Kind regards
    Wessel

    Reply
    • Mynda Treacy

      June 16, 2022 at 8:31 pm

      Hi Wessel,

      It looks like there’s a single quote in the wrong place or missing.

      Mynda

      Reply
      • Wessel

        June 16, 2022 at 9:26 pm

        Thanks Mynda, I tried spotting it before I posted, but can’t seem to find where Im missing the quote

        I thought its at the back, but the original post also doesn’t have one there.

        Kind regards

        Reply
      • Wessel

        June 17, 2022 at 12:00 am

        Sorry to post again:

        My exact code for that line is:

        “$filter”: “ASSIGNEDDATE eq ‘@{formatDateTime(convertFromUTC(utcNow(), ‘South Africa Standard Time’), ‘yyyy-MM-dd’)}”,

        Error code
        There is an unterminated string literal at position 27 in ‘ASSIGNEDDATE eq ‘2022-06-16’.
        inner exception: There is an unterminated string literal at position 27 in ‘ASSIGNEDDATE eq ‘2022-06-16’.
        clientRequestId: b083e4a5-c61f-4a1f-924d-a179ed890b5f

        Im also not making use a due date and reminder date, but only one colun ASSIGNEDDATE

        Thank you so much

        Regards

        Wessel

        Reply
        • Mynda Treacy

          June 17, 2022 at 10:08 am

          Hi Wessel,

          Have you checked the two single quotes are in place around the function as shown in this image:

          If so, I would go back to your file and make sure there are no discrepancies/typos in the column names and date fields etc. Lastly, (I’m out of ideas after this), check the UTC time is actually the current date in South Africa. i.e. you’re 2 hours ahead of UTC, so if it’s not 16th June in UTC time when you run the flow, you’ll get an erroneous error.

          Mynda

          Reply
  38. Shir Nixon

    June 13, 2022 at 9:45 pm

    First I want to thank you for the good and detailed explanation, both in the video and in the document you attached.

    I would appreciate your help:

    I Created my work flow and saved correctly. After running I get the following error message:

    There is an unterminated string literal at position 27 in ‘ReminderDate eq ‘2022-06-13’.
    inner exception: There is an unterminated string literal at position 27 in ‘ReminderDate eq ‘2022-06-13’.
    clientRequestId: aa6a7a51-3582-4263-8c67-7871be11ac82

    Reply
    • Mynda Treacy

      June 14, 2022 at 8:49 am

      Hi Shir,

      Glad the tutorial was helpful. Position 27 is the 3 in the date string. I suspect you haven’t entered the correct double/single quotes to finish the expression.

      Mynda

      Reply
  39. Jermie

    June 4, 2022 at 12:26 pm

    Created my work flow and saved correctly. After running I get the following error message:

    The ‘inputs.parameters’ of workflow operation ‘Send_an_email_(V2)’ of type ‘OpenApiConnection’ is not valid. Error details: Input parameter ’emailMessage/To’ is required to be of type ‘String/email’. The source type/format ‘Object’ of the value ‘{“jermie.arnold@csulb.edu”:””}’ is not convertible to type/format ‘String/email’.

    Did I miss something? Thank you for your help.

    Reply
    • Mynda Treacy

      June 4, 2022 at 12:28 pm

      Hi Jermie,

      the colon after the email address looks odd to me. Maybe that’s what’s causing the issue.

      Mynda

      Reply
      • Jermie

        June 4, 2022 at 1:19 pm

        Any idea how that would get there? I don’t think I added it. Where would I check that?

        Reply
        • Mynda Treacy

          June 4, 2022 at 2:25 pm

          No, sorry. Maybe it’s a blank cell in your range? I’m just guessing.

          Reply
  40. Annie S

    May 6, 2022 at 11:15 pm

    I’m setting up my very first flow following your very helpful steps. When I clicked save at the end I received this error: Flow save failed with code ‘OpenApiOperationParameterValidationFailed’ and message ‘Input parameter ’emailMessage’ validation failed in workflow operation ‘Send_an_email_(V2)’: The parameter with value ‘”@items(‘Apply_to_each_2’)”‘ in path ’emailMessage/To’ with type/format ‘Object’ is not convertible to type/format ‘String/email’.’.

    Any thoughts on what I might have done wrong? Thank you!

    Reply
    • Annie S

      May 6, 2022 at 11:31 pm

      I realized I needed to change Apply_to_each_2 to the Apply_to_each. I was able to successfully set up the flow but when I run it it fails.

      Reply
      • Mynda Treacy

        May 7, 2022 at 9:29 am

        Great to hear you’re making progress. Keep plugging away and troubleshooting. I’m sure you’ll get there.

        Reply
  41. Neil Small

    April 30, 2022 at 2:44 am

    Hi
    I am very new to this system and just trying out my first Automate flow and setting up is straight forward thanks to your helpful site but on running my flow I am hitting a wall with the required date error as below any I am stuck and need some guidance on what I am doing wrong.

    Syntax error at position 15 in ‘Calibration due date eq ‘29.38.2022”.
    inner exception: Syntax error at position 15 in ‘Calibration due date eq ‘29.38.2022”.
    clientRequestId: f4fb03de-02c0-4d34-90ed-9505228b8679.

    Many thanks
    Neil

    Reply
    • Mynda Treacy

      April 30, 2022 at 9:43 am

      Hi Neil,

      Looks like the date is not possible as there aren’t 38 months.

      Mynda

      Reply
      • Neil

        May 3, 2022 at 6:14 pm

        Hi
        Yes agree the dates in the spreadsheet don’t read like that, I Just cant work out what I have done wrong.

        I have checked what is written and it all seems fine, can you explain what I might be looking for when the error says inner exception and Position 15?

        Syntax error at position 15 in ‘Calibration due date eq’02.43.2022”.
        inner exception: Syntax error at position 15 in ‘Calibration due date eq’02.43.2022”.
        clientRequestId: c30ddf4b-1f42-4814-83b1-94b10b1bb2a0

        Any help would be much appreciated.
        Neil

        Reply
        • Mynda Treacy

          May 3, 2022 at 7:47 pm

          Check what is in position 15 in your expression for that step. You might be missing a comma or closing bracket.

          Reply
          • Neil Small

            May 3, 2022 at 11:09 pm

            Hi
            Ok had a breakthrough another set of eyes saw a simple spelling mistake in my spreadsheet so the code was fine, its running now so will see what the output is tomorrow.

            I am sure I’ll have more questions then…..

            thanks for your help.
            Neil

          • Mynda Treacy

            May 4, 2022 at 8:47 am

            Great to hear, Neil!

  42. Alex

    April 13, 2022 at 4:55 pm

    Hi,
    Thanks for a very helpful tutorial.
    I would like to know if there’s a way to set this up with reminders going to the same person every time, so no need for an email column and the steps that require selecting email addresses. Which part do I need to cut out?
    Thanks again

    Reply
    • Mynda Treacy

      April 13, 2022 at 8:47 pm

      Hi Alex,

      Yes, I’m sure you can, but it’s not something I can easily explain here. There’s a Power Automate template here you can use to get started.

      Reply
  43. Andrea

    March 22, 2022 at 3:35 am

    How can I troubleshoot why I am not receiving an email, I have tested the power automation and get a message it was successful. However, I am not getting an email. I have confirmed my email address is correct.

    Reply
    • Mynda Treacy

      March 22, 2022 at 10:26 am

      Hi Andrea, it may have gone to your junk folder. You can check the sent items folder to see that the email was actually sent.

      Reply
  44. Peter Pejavi

    March 17, 2022 at 9:35 pm

    Thanks for the nice tutorial, I have tried to follow it through step by step but it’s failing to send the email. Somehow the SELECT stage is showing empty results when I review the results from a test run.

    Reply
    • Mynda Treacy

      March 17, 2022 at 10:08 pm

      Hi Peter, I’d say you don’t have any dates in your Excel file that match the filter. Also keep in mind that if you’re using the TODAY function that it will evaluate based on the Power Automate server location, not necessarily your location. I had this problem in testing myself.

      Reply
      • M Sima

        September 27, 2022 at 4:07 am

        I am wonering if anyone knows a solution for no email showing up in the list for step 9 and on?

        Reply
        • Mynda Treacy

          September 27, 2022 at 9:02 am

          If you don’t have the Email field appear in the list of dynamic content when you search then it suggests that you don’t have a column in your Excel table called ‘Email’.

          Reply
  45. Thomas

    March 4, 2022 at 11:58 pm

    Very nice flow! I’m wondering how it would be possible to filter the excel list on all task equal or less than current date (to receive the overdue tasks as well in the html table)?

    Reply
    • Mynda Treacy

      March 5, 2022 at 10:07 am

      Thanks, Thomas.

      You can substitute eq for equals with lt for less than, or le for less than or equal to. Obviously with lt you’d have to add 1 to today’s date e.g. utcNOW()+1

      Mynda

      Reply
      • Milena

        June 2, 2022 at 10:09 pm

        Hi Mynda, I am trying to set the reminder for 3 and 7 days ahead of deadline but expression formatDateTime(convertFromUtc(utcNow()+3, ‘Central Europe Standard Time’), ‘yyyy-MM-dd’) is set as invalid, can you help me, please?
        Also if I want to combine conditions (the date condition and the cell value from “Status_Code” is either 1 or 2, how should I manage to list the correct rows?

        Thanks a lot, the flow works perfectly otherwise :-),
        Milena

        Reply
        • Mynda Treacy

          June 3, 2022 at 9:13 am

          I don’t think you can put +3 on the utcNow() function. The purpose of that function is to perform the +3 based on the locale you specific in the next argument, i.e. ‘Central Europe Standard Time’

          Reply
  46. Robert Berwick

    February 24, 2022 at 10:31 pm

    What a pity this does not work on One Drive personal

    Reply
    • Mynda Treacy

      February 25, 2022 at 9:09 am

      Yeah, I guess it’s considered a business product.

      Reply

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Current ye@r *

Leave this field empty

Sidebar

More results...

Shopping Cart

mynda treacy microsoft mvpHi, I'm Mynda Treacy and I run MOTH with my husband, Phil. Through our blog, webinars, YouTube channel and courses we hope we can help you learn Excel, Power Pivot and DAX, Power Query, Power BI, and Excel Dashboards.

Subscribe to Our Newsletter

Receive weekly tutorials on Excel, Power Query, Power Pivot, Power BI and More.

We respect your email privacy

Guides and Resources

  • Excel Keyboard Shortcuts
  • Excel Functions
  • Excel Formulas
  • Excel Custom Number Formatting
  • ALT Codes
  • Pivot Tables
  • VLOOKUP
  • VBA
  • Excel Userforms
  • Free Downloads

239 Excel Keyboard Shortcuts

Download Free PDF

Free Webinars

Excel Dashboards Webinar

Watch our free webinars and learn to create Interactive Dashboard Reports in Excel or Power BI

Click Here to Watch Now
  • Excel
  • Excel Charts
  • Excel Dashboard
  • Excel Formulas
  • Excel PivotTables
  • Excel Shortcuts
  • Excel VBA
  • General Tips
  • Online Training
  • Outlook
  • Power Apps
  • Power Automate
  • Power BI
  • Power Pivot
  • Power Query
 
  • About My Online Training Hub
  • Contact
  • Disclosure Statement
  • Frequently Asked Questions
  • Guarantee
  • Privacy Policy
  • Terms & Conditions
  • Testimonials
  • Become an Affiliate

Copyright © 2023 · My Online Training Hub · All Rights Reserved

Microsoft and the Microsoft Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries. Product names, logos, brands, and other trademarks featured or referred to within this website are the property of their respective trademark holders.

Download A Free Copy of 100 Excel Tips & Tricks

excel tips and tricks ebook

We respect your privacy. We won’t spam you.

x