Help with Concat in Compose (data operation)

(0) Share

Report

Posted on by TKS0001

Can someone please help me in understanding what's the issue with Concat expression in the below picture:

I hope it is clear from the above picture. But, please do ask any further questions needed to find the error. Thanks!

Categories:

General topics

I have the same question (0)

All responses (7)

Answers (1)

DiegoPeres 327 on at

Like (0)

Report

Hi @TKS0001
can you post the error that is occurring when processing the function? If possible also post the header of your Sharepoint list.

Was this reply helpful? Yes No
TKS0001 14 on at

Like (0)

Report

Hi @DiegoPeres Thanks for looking into it. Much appreciated!

As requested, here's the SharePoint list & error detail. Though there is no error as such, it just does not show the concated information

SharePoint List - with Columns as:
Title – Single line of text
Product1 – Single line of text
Product2 – Single line of text
Remarks – Multiple line of text

Here is the screenshot of result:

As highlighted above, it just shows the 'Title' field only and not other concated fields:
Concat(item()?['Title'],item()?['Product1'],item()?['Product2'],item()?['Remarks'])

I hope this helps in understanding the issue!

Was this reply helpful? Yes No
Verified answer

DiegoPeres 327 on at

Like (1)

Report

Hi,@TKS0001 I made a simulation in your scenario:

Where the user reports a data, which is in the Title column, I did the concat this way:
concat(items('Apply_to_each')?['Title'], ': ',items('Apply_to_each')?['Product1'], ',',items('Apply_to_each')?['Product2'], ',',items('Apply_to_each')?['Remarks'])

And the result was: Fruits: Apple,Orange,I love Juice

Look at the prints:

Did I answer your question?😉
Please consider accepting it as the solution to help other members find you faster.

Like my answer?

Like it! 👍

Thanks!
Diego Peres,
Connect with me: Linkedin

Was this reply helpful? Yes No
TKS0001 14 on at

Like (0)

Report

Hey @DiegoPeres This is so great! Your concat expression worked like charm
concat(items('Apply_to_each')?['Title'], ': ',items('Apply_to_each')?['Product1'], ',',items('Apply_to_each')?['Product2'], ',',items('Apply_to_each')?['Remarks'])

I can see the output like this:

I was going to mark your reply as 'Accept as Solution' however then thought to check with you if you somehow also know and help me in outputting the result as shown below:

i.e. each field in a separate line and also if the multiline field can show as multiline instead of showing in 1 line.

Please let me know if this takes time and is not an easy solution. I can mark your reply as the solution and maybe open a new thread.

In any case, THANK YOU! again!

Was this reply helpful? Yes No
DiegoPeres 327 on at

Like (0)

Report

Good, Very good!!!
I'm glad it worked for you!!!
I will create a scenario like you showed below, but I won't be able to do it today, but I can do it tomorrow

Was this reply helpful? Yes No
TKS0001 14 on at

Like (0)

Report

No worries! Please take your time @DiegoPeres
Thank you again and have a nice remaining day!

Was this reply helpful? Yes No
DiegoPeres 327 on at

Like (0)

Report

I had a little time and made the line break:
For this it was necessary to use the Split function, the code looked like this:
Split(concat(items('Apply_to_each')?['Title'], ': ',
items('Apply_to_each')?['Product1'], ', ',
items('Apply_to_each')?['Product2'], ', ',
items('Apply_to_each')?['Remarks']),',',')

The result looks like this:
[
  "Fruits: Apple",
  " Orange",
  " I love juice!!! My favorite juice is mango but I like all fruits\neven the most exotic i like jabuticaba"
]

Did I answer your question?😉
Please consider accepting it as the solution to help other members find you faster.

Like my answer?

Like it! 👍

Thanks!
Diego Peres,
Connect with me: Linkedin

Was this reply helpful? Yes No