cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
laz8592
Helper II
Helper II

Send an email reminder to the creator of the task in Microsoft List

Hi

 

I have a Microsoft List that has an existing flow that works with an assigned column (person/group) to send an email reminder a day before matched to a date column. 

 

Sometimes the creator (employee name category) of the task does not add an assigned user (as its not mandatory field), how can this flow still send an email to the creator  of the task as the flow has assigned email? If I add 'Employee Name Email' in the bcc section of outlook task, will the email still be sent to the creator? See below current flow, thank you. 

 

laz8592_0-1635142087029.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
OliverR-82
Responsive Resident
Responsive Resident

Hi @laz8592 ,

 

What @PowerMic suggests would look more like the following:

OliverR82_0-1635151505624.png

Check if the AssignedTo column is empty (check on the Email property). If it's empty, send an email to the CreatedBy Email. If assignee is not empty, then send the email to AssignedTo Email.

View solution in original post

9 REPLIES 9
PowerMic
Advocate I
Advocate I

Hi Iaz,

you may add a condition to check if the assignee is blank, if so use the "Created By" column to get the profile mail and then use it as recipient.

Hi PowerMic

 

So under my flow I add a condition like this for 'Created by' to send an email to them?

 

 

laz8592_0-1635150947936.png

 

OliverR-82
Responsive Resident
Responsive Resident

Hi @laz8592 ,

 

What @PowerMic suggests would look more like the following:

OliverR82_0-1635151505624.png

Check if the AssignedTo column is empty (check on the Email property). If it's empty, send an email to the CreatedBy Email. If assignee is not empty, then send the email to AssignedTo Email.

PowerMic
Advocate I
Advocate I

Yes, by what I understood you may need to check "Assigned" equal to "null" (into condition),

 

if yes send to the Created By if not send to the Assignee

Sorry is it like this

 

Condition: Assigned item is equal 'to 'blank'

and send email to created by 

laz8592_1-1635151651674.png

 

 

Thanks guys will try that 

SO I do the necessary but I get an error message, see below

 

laz8592_0-1635157326288.png

 

It looks like you have selected the "Created By" dynamic content field in your 'Send an email to Creator of task' action. You need to use the "Created By Email" field instead.

It worked thanks very much! 

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Users online (2,773)