Get info from SharePoint LIST to email - column with more values

[Stenly]

Hello all,

I have following problem.

I have one SharePoint list. User is adding values by button NEW. In this form, there is field "Poznámka" which they are using.

On this list are three manually triggered flows and in each flow is the same field - "Poznámka" which they are also using.

Each flow is adding new information into one column and in list it looks great.

Column type is "plain text".

But when I am trying to get this information in the flow and send it in the email, I have everything in one row.

This is my flow for this field:

Any idea how I can break it to each line each new value in "Poznámka" and do not have empty lines there?

Thank you for advice!

Best regards, Stanisalv

[fchopo]

Hi @Stenly 

You could use the following expression instead of "poznámka": 

replace(variables('poznamka'),'<br/>')

As the email is formatted in HTML. With that expression we're replacing white spaces with a line return.

Hope this works for you!

Ferran

[Stenly]

Hello @fchopo ,

Thank you for advice. But where exactly should i use that expression? In the email?

If yes, I did that and now my "Sent email (V2)" looks like this:

But I had this error when test it:

Thank you for your help!

Best regards, Stanislav

[fchopo]

Hi @Stenly 

Sorry, I made a mistake when using the expression. Correct one should be the following:

replace(variables('poznamka'),' ','<br/>')

Hope that helps now!

Ferran

[Stenly]

Hi @fchopo ,

Thank you, it does look better but now the "enter" is  not where it should.

This is my "connect value to a string"

There is a "red line". That is the spot, where the break is add with your expression. But I need it before "WL:".

This is what I´ve got with your expression in my email: 

But I need it like this:

Poznámka: Test

WL: Test

-----------------

Any idea how I can do it?

Thanks a lot for your help!

Best regards, Stanislav

[fchopo]

Hi @Stenly 

Honestly, I'm a little bit confused on what you want and the actions you're doing in the workflow, probably because of the language, but I would recommend using replace and split functions to try to get desired output.

Best,

Ferran

Sorry for not being 

[Stenly]

Hello @fchopo

I did translate the web site, so maybe it will be more obvious and I will try explain it again :-).

I have SHP list where is one column called Note. This column is "multiple line of text" and format is "plain text".

When user creates new item in this list, he also fill out column "Note" with some text.
Then there are 3 flows, which user must trigger manually if he wants to use them. In each flow there is also field "Note" which is adding more text into the same column "Note".

After each manually triggered flow, my flow updates the item in the list. And each new "text" from each flow is add into same column "Note" and from each flow it is on the new line.

After creating new Item on the list and using all three flow, the column "Note" looks like this:

1. row = user created item on the list and add value "Create value" into field "Note"

2. row = user used first flow and add value "1. Flow" into filed "Note"

3. row = user used second flow and add value "2. Flow" into filed "Note"

4. row = user used third flow and add value "3. Flow" into filed "Note"

And so far, this is ok and exactly how i need it.

But now there is a problem.

I need all 4 rows put into email which is sent in the end of each manually triggered flow to me.

But unfortunately, I have all information in my email but it is in one row.

Like this:

This is part of my flow where I am working with "Note" column/field:

 WL here is the name of the manually triggered flow. It is for me, so I can recognize, which flow add which information into field "Note". In other two flow instead of WL there are letters ELV and ELŽ.

Here I used already your expression.

Your expression did this in email:

But I need it to looks like this in email:

I hope this is more specific and better understandable.

I am not sure how should I combine functions split and replace, so I would really appreciate your help!

Let me know if you need more information or anything.

Thank you very much!

Best regards, Stanislav Kvída

[Stenly · Accepted solution]

Hello to all,

I have final solution and want to thanks to @fchopo. I used his expression for that.

My flow for notes looks now like this:

In the body of "Send email (V2):

This will do two things.

First in SHP list it will add ";" after each previous note in manually triggered flow:

And each note from each flow will be in separate row in email:

Which is what I need :).

Thank you for help!