Building flow to send an email once reminder date = today date

[Chua92]

HI, i want to build a flow that send an email once the date column is equal to today date.

The excel file is stored in onedrive. 

There will be 4 columns in the excel file - Name, DueDate, ReminderDate and Email. 

DueDate and ReminderDate are in short date format in yyyy-MM-dd

The workflows:

1. The flow will run monthly - I have used "Recurrence" (Done)

2. Link the excel file - i have used the "List Row present in a table" (Done)

3. Compare dates between ReminderDate to Today Date (not done)

4. If #3 is yes, send an email with the row information. If no, dont have to do anything (not done)

Appreciate your help as i am stuck in Number 3.

[v-alzhan-msft]

Hi @Chua92 ,

You could refer to screenshot below to create the flow:

The expression for current date:

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

The expression for DueDate in excel table:

formatDateTime(addDays('1900-01-01',add(int(items('Apply_to_each')?['DueDate']),-2)),'yyyy-MM-dd')

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Chua92]

HI Alice,

i have tried and saw this message in the "send an email" portion, is it something went wrong?

Inaddition, can i include the result that meet the condition in the email body?

For example, this is how the excel table look like

Row 4 (test 3) meet the condition, therefore the email body will indicate row 1 (individual column name) and row 4 (the row that meet the condition)

Thanks

[v-alzhan-msft · Accepted solution]

Hi @Chua92 ,

You should check from the loop of the Apply to each in the flow run history, and there would be a loop would run into the if yes branch of the Condition.

And if you want to send the send the row data in the email, I suggest that you could add a Filter array action inside the If yes branch for find the special rows, then create html table to the rows then send it in the email.

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.