Hello all,
This is my first post on here, so please bear with me.
I am trying to create a flow that is triggered from the submission of responses from a Form for an IT ticketing system. I have built a flow that transfers the responses into Planner. This flow also creates an item in SharePoint the replicates the response details provided - this works perfectly.
I have two issues:
I have tried numerous actions/triggers, however Planner/Flow seems to send every respondent an email if any one task is marked as complete; not the specific tasks respondent. Each respondent is different with each submission. And similarly on the SharePoint list, if you complete one task (via Planner) it marks all items submitted as complete (in SharePoint).
Flow:
I hope i have explained this in a comprehensive manner.
Thank you.
Evan.
Hi @7he_7empest ,
Please take a try to:
1.Add a submitter Email column in the sharepoint list.
2. Delete the Update item action in your first flow and add it gain, the submitter Email column would appear, update the submitter Email column with the submitter email.
3. And in the second flow, you could get the submitter Email column in the special item in the sharepoint list, and send the email to the special submitter in that item.
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.
Thanks for your response!
Apologies, i am new to this - what would the flow look like for this incorporating your steps above?
Thanks again.
Hi @7he_7empest ,
Sorry for misunderstand you on the first question.
Do you want to send the email to the submitter when the task is completed?
If yes, you could add a submitter Email field in the sharepoint list, every time when a response is received, create the item in the list with the submitter Email.
And in the second flow, you could get the special item in the sharepoint list, and send the email to the special submitter in that item.
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.
Hello @v-alzhan-msft
Thank you for responding.
The first solution is still sending an email to all the response submitters as oppose to the submitter relating to the completed task.
The second solution worked like a charm - thank you!
Perhaps i will incorporate a list column for submitter email address and use the same convention as below; swap it out for send email action - would this work in theory?
Thank you!
Best regards,
Evan
Hi @7he_7empest ,
For the first issue, you could add a Send an email action to send the email to the response submitor.
For the second issue, you could create another flow that would trigger when an task is completed, the screenshot of the flow should as below:
Please make sure that the Title would be same with the task Title when create the item, and the task Title is unique for identify a task.
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.
WarrenBelz
146,751
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional