I can see how to send an email when a task is completed, but I also want to include some of the original MS Form details in the email from the completed task. I'm struggling how to do this, can anyone help?
Hi,
I've come back to this after being busy with my usual work and hit a couple of problems.....
1) Not all of the dynamic field names are available when I select 'Send an Email (V2)' and look at the list.
2) I can choose the ones that are available in the list and place them in the email, but then when the flow runs the email appears without the relevant fields (ie they're just blank)
Any suggestions?
Thank you so much for the help, that is working perfectly!
Hi @Barking_Mad1 ,
Based on the sample title you provided, this expression should work.
In addition, you could try nesting a replace() function on the original expression to remove extra spaces.
Share
Report
All responses (
Answers (
replace(last(split(triggerOutputs()?['body/title'],'-')),' ','')
Best Regards,
Charlie Choi
Hi,
Thanks for the reply and sorry for the delay in getting back to you.
I think this will work, the only issue I have is that the flow that creates the task, creates different planner tasks depending on the details entered in the MS Form. However thankfully all the 'Create a Task' options do so with the same Title (so I think this should be ok?):
'First Name' 'Surname' | 'Programme' | 'Cohort' - 'Response ID'
(they are divided by the '|' symbol)
However I'm not sure how I amend this in regard to the expression you wrote out below, any chance you could advise?
last(split(triggerOutputs()?['body/title'],'-'))
Hi @Barking_Mad1 ,
I guess you have two Flows, one to create a Planner Task based on the MS Forms' response, and the other to get the MS Forms' response details and send the mail when the task is complete. If so, you need to save the Response Id to the created Planner Task.
Flow 1:
I saved the Response Id to the Task's Title and used "-" as the delimiter.
Flow 2:
Extract Response Id from Title using expression.
last(split(triggerOutputs()?['body/title'],'-'))Result Screenshot:
Best Regards,
Charlie Choi
Unfortunately, that's the problem it doesn't appear anywhere in the dynamic list when I go to type it in. 😞 I've tried over a couple of days in case it was a PA issue, but no luck.
ok @Barking_Mad1 ,
in your “Get response details” action you have to put the Reaponse Id” instead of the task Id.
BR,
Marco
Hi Marco,
Yes, because in the main flow where I handle it being received I can select it from the dynamic content.
Hello @Barking_Mad1 ,
when you create the Planner task, are you storing also the Forms response Id?
BR,
Marco
Hi,
I know it's wrong, ( the get response details wont allow me to pick the Form, ID) but this is what I have. I cant work out how to get the correct form ID details. Maybe I should get them from the Excel document? Any help appreciated....
3,812