Unanswered

Mail after 6 month

(0) Share

Report

Posted on by CU16101839-0

In excel i have a collum with different date i want to power automate to send me a mail every 6 month after that date. Is that possible?
I use Outlook.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Suggested answer

David_MA 12,966 Super User 2025 Season 2 on at

Like (0)

Report
Yes. Do the following:

In the above, Reminder represents the date field in your spreadsheet that you want to base the logic on. It is important to check the ISO 8601 date format in the Excel action, which is not selected by default. The filter query requires the use of ISO 8601 formatted dates.

The expression in the filter query is addDays(utcNow(),-180,'yyyy-MM-dd').

The condition checks to see if any items were found matching the filter query. The expression in the condition is length(outputs('List_rows_present_in_a_table')?['body/value']).

Then you would want to set your workflow as a scheduled flow that runs once per day at the time you want the e-mails to be sent.

Was this reply helpful? Yes No
CU16101839-0 4 on at

Like (0)

Report

Thank you for the response.

It says: Action ‘List_rows_present_in_a_table’ failed: Syntax error at position 5 in ‘21-17-2024’. Inner exception: Syntax error at position 5 in ‘21-17-2024’. ClientRequestId: [clientRequestId].

I don’t understand why it is showing that date.

Was this reply helpful? Yes No
CU16101839-0 4 on at

Like (0)

Report

I think one of my problems is that the date format is dd-mm-yyyy. Can you convert that to the standard format in Automate before using it?

Was this reply helpful? Yes No