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
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,636)