cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sad3011
New Member

Send mail when task is completed to recepient who submitted a form

Hi!

I've created a flow which creates a task in planner when a form is submitted. This works fine.

Now I want to create a flow to send an email to the submitter of the form when the task is completed. The flow fails, because flow didn't know which FormID belongs to the completed task. 

Has anybody an idea?

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
SCTdan
Continued Contributor
Continued Contributor

Correct, just a simple 'Create Item' action.  I would just create 2 columns in your list-  TaskID, and SubmittersEmail.  Then, with your second flow, you just get all items from the list and filter it on the taskID of the completed task.  Once you have that item, you can grab the email.

View solution in original post

3 REPLIES 3
SCTdan
Continued Contributor
Continued Contributor

Since this has to be done as two separate flows, you need to store the form submittors name/email somewhere.  You could put that in the description of the planner task perhaps.  Or you could use an excel spreadsheet or sharepoint list to keep an active list of task ID <-> submittor email.

Sounds like a good solution. So the trigger for my second flow would be "When Task is completed" and I will fetch TaskId and responders E-Mail from Sharepointlist. 

In first flow i need to add a step where i insert values in sharepoint list right? How can I tell sharepoint list that he should create a dependency between taskid and Responders email? Or is flow inteligent enough to fetch task id from sharepoint list with responders Email?

SCTdan
Continued Contributor
Continued Contributor

Correct, just a simple 'Create Item' action.  I would just create 2 columns in your list-  TaskID, and SubmittersEmail.  Then, with your second flow, you just get all items from the list and filter it on the taskID of the completed task.  Once you have that item, you can grab the email.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (1,648)