Is this possible in a basic workflow

(3) Share

Report

Posted on by DW-18081230-0

I have setup a simple flow for work for my colleagues to complete and for me to have access to / collate

I have a Microsoft Form with several options for them to complete.

I have an Excel file that will collect that date by adding a row into a table

I have an Outlook option to send an email to me with details from the form.

In the form, one of the options is 'Send to:' and I have listed all of our teams' email addresses as options.

What I would like to automate is, whatever is selected here in the 'Send to' part (it could be more than one person's email address), I would like to send an email to that person / those people selected, with the details of the form, otherwise I am going to have to forward the emails I receive multiple times a day.

Is it possible to do this? I can't find a way to add the field from the form into an email 'To' or into the 'CC' option on my Outlook option above.

Thank you any help offered.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Suggested answer

Nived_Nambiar 18,138 Super User 2026 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi,

for the demonstration, I have created a form , where user need to select the email id to whom details need to be sent as shown below

Now in the flow , i will explain how to add those email id selected in the form either in to or cc field of send email action in power automate, see below

1. Add the trigger and respective actions to capture form responses as shown below

2. Now in to field of send email action, use below expression which helps to concat indiviual email id selected in form response by delimiter ; , see below

Expression -

join(json(body('Get_response_details')?['re95b984f987c48d8a61c248374aaeaf3']),';')

the part body('Get_response_details')?['re95b984f987c48d8a61c248374aaeaf3'] may change in your case as it is dynamic content which contains email id selected as shown below

Hope it helps !

Thanks & Regards,
Nived N
LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel
Blog: Nived Nambiar's Blogs
Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you!

Was this reply helpful? Yes No
DW-18081230-0 16 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you for your help Nived. I will try it with colleagues at our meeting early next week and come back if I have any problems.

Much appreciated

Darren

Was this reply helpful? Yes No

DW-18081230-0

16 on at

Like (1)

Report

Copy link

Link copied!

Hi Nived

The flow failed with the additional piece you provided. I've tried to explain my understanding as below and hope you can help?

Thanks

Darren

The info below all came to me as I am on a separate email default in the first email part of the flow, that all forms completed just come to me, which was easy to set up in the flow. It is the additional email part of the flow that has failed – the piece you helped me with:

1 of your flow(s) have failed
The flow(s) listed failed in the past week and may need your attention.

1 Notification:

Flow name	Failure count
Track Microsoft Forms response in Excel and notify through Teams and email	1

When I go into the flow it shows:

When I select the item with the issue on the next page it says:
InvalidTemplate
Unable to process template language expressions in action 'Send_an_email_(V2)_1' inputs at line '0' and column '0': 'The template language function 'join' expects two parameters: the array of elements to join as the first parameter, and the element separator as the second parameter. The function was invoked with '1' parameter(s). Please see https://aka.ms/logicexpressions#join for usage details.'.
This is the detail code, that you helped me with for this part of the flow:

As the image is a little blurry above, I've typed the code bit exactly as it is

join(json(body('Get_response_details')?['XXXXXXX the id needed']))

I think it may be because for the part you helped with about sending an email of items from the form, to someone selected in the form – it may have failed because the person completing the form doesn't type the email address they want it sent to, they select from a multiple choice list question in the form that has all the key people they could send an email to, and also possibly it didn’t work because they chose 2 people from that list as well?

For the rest of the form it is as below which I’ve replicated from our test of the flow. In bold are the basic headers from the form
Name of site (this came through to me correct, one of our sites)
Name of person completing form (this came through to me correct, name of the person completing the form)
Date of completion - 2024-08-27

Who you want to send the detail to…
This is what I see on the email I received, exactly as I received it but with the email addresses changed but I wanted you to see exactly what I got
["xxxxx@xxx.co.uk","xxxxxxxxxx@xxx.co.uk"]

What the site visit was about – this came through to me with the punctation around it but from the options within the form
["XXXXXXXXX"]

Notes from visit – this came through to me
Next steps – this came through to me