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

Row separated text MS Form to Power automate email V2

Hi Community,

 

I wanted to extract a simple row-separated text from MS Form to my Power automated email. I am facing a problem with extracting output from the field. 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

Hi @brownguy5540 

Do you want to receive an email like this?

vLilyWmsft_6-1631151086290.png

You can take a try with the following steps.

This is my test Form

vLilyWmsft_1-1631150735033.png

Flow in details:

vLilyWmsft_0-1631150635760.png

Expression:encodeUriComponent(outputs('Compose'))

vLilyWmsft_2-1631150768907.png

Expression:replace(outputs('Compose_2'),'%0A','<br>')

vLilyWmsft_3-1631150815040.png

vLilyWmsft_4-1631150854281.png

When a Form is submitted like below, you will receive such an email.

vLilyWmsft_5-1631151065811.pngvLilyWmsft_6-1631151086290.png

For more info about functions of Power Automate, you can refer to this document:

Reference guide for functions in expressions - Azure Logic Apps | Microsoft Docs

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
eric-cheng
Solution Sage
Solution Sage

Hi @brownguy5540 ,

 

Can you please provide a bit more info about your requirements as well as some screenshots of what you have build so far.

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

In the MS Form, we want to type something like this :

 

brownguy5540_0-1630590897198.png

 

But in the Email ( Automated ), I receive something like this :

brownguy5540_2-1630591761645.png

 

Let me know if this helps?

 

 

 

Hi @brownguy5540 

Do you want to receive an email like this?

vLilyWmsft_6-1631151086290.png

You can take a try with the following steps.

This is my test Form

vLilyWmsft_1-1631150735033.png

Flow in details:

vLilyWmsft_0-1631150635760.png

Expression:encodeUriComponent(outputs('Compose'))

vLilyWmsft_2-1631150768907.png

Expression:replace(outputs('Compose_2'),'%0A','<br>')

vLilyWmsft_3-1631150815040.png

vLilyWmsft_4-1631150854281.png

When a Form is submitted like below, you will receive such an email.

vLilyWmsft_5-1631151065811.pngvLilyWmsft_6-1631151086290.png

For more info about functions of Power Automate, you can refer to this document:

Reference guide for functions in expressions - Azure Logic Apps | Microsoft Docs

Hope the content above may help you.

Best Regards

If my solution helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (2,020)