Unanswered

Power automate - notification to email acc. to Reminder Date

(0) Share

Report

Posted on by Valina

Hi all,

I have table with input data (table contains 40 rows of products with different End Date). Reminder date is set up as 30 days before End date. I set up power automate to notify me via email when Reminder Date is today at 10:00 am. By testing this power automate I received 40 emails with notification, where was text about 2 products in the body of the email. I would like to receive only one or so many email with notification as are the dates in Reminder Date column. Can you help me please? There is power automate what I set up:

Thank you for your help

Categories:

General topics

All responses (6)

Answers (0)

Sort by

VictorIvanidze 13,083 on at

Like
a
(0)

Report
Copy link

Link copied!

Modify "Filter array" - try to compare using ticks() instead of string dates.
Valina 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Can you show me how can I compare it, please. This is my first power automate. Thank you VictorIvanidze
VictorIvanidze 13,083 on at

Like
a
(0)

Report
Copy link

Link copied!

Search here for compare dates ticks.
Haritha222 113 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Valina

In list rows can you please add filter query using this mostly we will overcome to send mails for all records. like below image.

If needed more information please check below link.
https://www.myonlinetraininghub.com/automatically-email-reminders-from-excel-with-power-automate

If this solution is okay please mark it as verified.

Regards
Haritha
Valina 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Haritha

I know this page. I did everything what is there written, by I have problem in this point.

There is error: Syntax error at position 27 in 'ReminderDate eq'2023-02-23''.
inner exception: Syntax error at position 27 in 'ReminderDate eq'2023-02-23''.
clientRequestId: 3ae4ec9e-b2a0-4db7-bcbc-f79120a09660
or Error: Syntax error at position 13 in 'Reminder Date eq '2023-02-23''.
inner exception: Syntax error at position 13 in 'Reminder Date eq '2023-02-23''.
clientRequestId: c192bdc7-e379-48d9-aa83-09dcd39cf273

I tried more options to write ' in formula:
ReminderDate eq' formatDateTime(convertFromUTC(utcNow(), 'E. Australia Standard Time'), 'yyyy-MM-dd')' with and without spaces, but still not work. I don't know where I do something wrong.
Haritha222 113 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Valina,
ReminderDate eq 'utcNow('yyyy-MM-dd')

if still error coming means
step 1: Take compose action ,inputs mention Reminder date field
step 2: run and check compose reminder date format and what date is showing.

In my case i have found this solution.

Please try it once.

Regards
Haritha
'