Answered

Excel dates to email notification

Like (0) Share

Report

Posted on 4 Mar 2022 19:44:46 by Community Power Pla...

I am looking to get email notifications when it is the date listen in a column in my excel spreadsheet, I have 2 columns, "6 month follow up" and "1 year follow up" and am wondering how to begin to create a flow that would send me an email notification when the date in the column is the current date.

I am new to flows and would appreciate any help,

sorry if the question has already been answered elsewhere.

I have the same question (0)

All responses (2)

Answers (1)

dimitrisval 17 on 17 May 2022 at 15:24:56

Like (0)

Report

Re: Excel dates to email notification

Hi I have followed the instructions but I get the following error:
Syntax error at position 13 in 'Reminder Date eq '2022-05-17''.
inner exception: Syntax error at position 13 in 'Reminder Date eq '2022-05-17''.
clientRequestId: 48f6a448-8a7f-4f38-8c72-28f215545c42

My Excel table1 is like this
Can you please help. Thanks in Advance

Was this reply helpful? Yes No
Verified answer

ScottShearer 25,236 Most Valuable Professional on 04 Mar 2022 at 21:17:38

Like (1)

Report

Re: Excel dates to email notification

@Anonymous

See my example below and note the following:

Date/Time format set to ISO8601

Single quotes around the expression in my filter

The expression that I used can be seen in the notes for the list items in a table action

My date column is called Date1 - yours will be different

The data MUST be in a table

Let me know if you have additional questions

Was this reply helpful? Yes No