How to split and insert in a new line for each selected item in a multiline textbox

(0) Share

Report

Posted on by floxfloat

100

Hi All,

How do I split each values (links) from a SharePoint Multiline Column to a newline in Send Email Action?

Email looks like this when received. I need help to split each links to a new line

Power Automate Flow Send email action

This is the Combo Box & Multiline textbox in my power apps

The Combo box concatenates the selected values to a multi line textbox. the data from the multiline textbox is saved in a SharePoint List (Multiline Column).

SharePoint list column

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

Manish Solanki 15,169 Moderator on at

Like (2)

Report
Copy link

Link copied!
Hi @vicsaisan

Pls try replacing new line feed '\n' with tag using an expression. Expression needs to be added in the expression box:

replace(<dynamic additional folder value>,decodeUriComponent('%0A'),' ')

Pls pass the internal name of additional folders column from dynamic content window in the above expression.

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
floxfloat 100 on at

Like (0)

Report
Copy link

Link copied!

Hi @ManishSolanki ,

Thanks a lot for your help 🙂 I'm not sure if my implementation is right.

my expressions goes like this ...
replace(triggerOutputs()?['body/AdditionalFolder'],decodeUriComponent('%0A'),' ')

here's the result:

Was this reply helpful? Yes No
Manish Solanki 15,169 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi @vicsaisan

Pls check the internal name of column "Additional folders" and also check the value of same field in previous flow instance. It should have \n in between each links. If its different, then pls share with me by masking actual urls.

Below is the post where I have instructed the steps to get internal name of the column in SharePoint:

Solved: Filter Query for Get Items - anything due in 7-14 ... - Power Platform Community (microsoft.com)

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
floxfloat 100 on at

Like (0)

Report
Copy link

Link copied!

Hi @ManishSolanki ,

I've checked the internal column is correct as per below:

replace(triggerOutputs()?['body/AdditionalFolder'],decodeUriComponent('%0A'),' ')

As I checked the flow test result I cannot see \n from the flow instance output see below sample:

SharePoint folder: https://seviora.sharepoint.com/sites/ffmc/sh/FFMCGeneral/Forms/AllItems.aspx 
SharePoint folder access permission:Allow READ-ONLY and remove other permissions 
 
Additional SharePoint folders: 
https://seviora.sharepoint.com/sites/ffmc/0and%20Cash%20Management/Forms/AllItems.aspx
https://seviora.sharepoint.com/sites/ffmc/sh/General/Forms/AllItems.aspx
https://seviora.sharepoint.com/sites/ffmc/sh/tamped%20Documents/Forms/AllItems.aspx
https://seviora.sharepoint.com/sites/ffmc/sh/inaBD/Forms/AllItems.aspx 
 

Not sure if this will help @ManishSolanki ,
This is what I did in the textbox in power apps. this is linked to multiline column in my SharePoint list

below is the default formula for the textbox. returning the links based on the selected value in the ComboBox.

Was this reply helpful? Yes No
floxfloat 100 on at

Like (1)

Report
Copy link

Link copied!

Hi Manish,

I managed to resolved the issue. your solution really helps me a lot to address the issue.

Updated my textbox default formula as:
Concat(ddDummyAdditionalFolder_1.SelectedItems,'SharePoint Link'," ;" & Char(13))

use this expression instead:
replace(triggerOutputs()?['body/AdditionalFolder'],' ;',' ') 😄

Thanks a lot @ManishSolanki 🙂🙏

Was this reply helpful? Yes No