You’re offline. This is a read only version of the page.
Announcements
Hello,
I have a microsoft form I am using to trigger an automation that generates a report and sends approval emails to the required personnel. One of the questions asks for the responder's managers.
The hope is to have the question use radio buttons and allow the responder to enter in multiple managers if needed, and then create a variable in power automate to cc the managers to the emails that are sent.
Here is my current flow:
2 initialized variables--
a. the email url-- "@company.com"
b. the selected managers. The format of the names comes in with brackets and quotes. E.G., John Smith and Karen Smith will come in displayed as ["John Smith","Karen Smith"]
The flow
1. takes entries from the question "Manager",
2. removes the quotes and brackets from the response details
3. adds a period for the email (i.e. creates the variable first.lastname),
4. concat to create email first.last@company.com
This solution works when only 1 name is selected, but when 2 are selected the dynamic output that generates in the email 'TO' field is something like: karen.smith,john.smith@company.com-- not all names get the @company.com url.
Any insights into what I can add to our flow so that each name gets formatted properly into an email address?
Hi , @amcmann
According to your description, in my understanding you want to convert ["John Smith","Karen Smith"] to karen.smith@company.com;john.smith@company.com right?
This is my test flow , you can refer to :
If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!
Best Regards,
Yueyun Zhang
Share
Report
All responses (
Answers (
522
