cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TKS0001
Regular Visitor

Help with Concat in Compose (data operation)

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

pic11.jpg

 

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

1 ACCEPTED SOLUTION

Accepted Solutions

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

DiegoPeres_1-1633374252390.png

 

DiegoPeres_0-1633374227028.png

 

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:

DiegoPeres_3-1633374428687.png

 

DiegoPeres_2-1633374370652.png

 


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

 

View solution in original post

7 REPLIES 7
DiegoPeres
Resolver II
Resolver II

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

 

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

SP1.jpg

 

Here is the screenshot of result:

Result1.jpg

 

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!

 

 

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

DiegoPeres_1-1633374252390.png

 

DiegoPeres_0-1633374227028.png

 

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:

DiegoPeres_3-1633374428687.png

 

DiegoPeres_2-1633374370652.png

 


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

 

View solution in original post

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:

 Result1.jpg

 

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:

 

 

Result2.jpg

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!

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

TKS0001
Regular Visitor

No worries! Please take your time @DiegoPeres  

Thank you again and have a nice remaining day!

 

 

 

DiegoPeres
Resolver II
Resolver II

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"
]
DiegoPeres_1-1633381747163.png

 


DiegoPeres_0-1633381717474.png

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

Helpful resources

Announcements
Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

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.

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.

Center-of-Excellence-Starter-Kit-cropped 768x460.png

The Total Economic Impact™ of Power Virtual Agents

Read this 2021 commissioned study, conducted by Forrester Consulting.

Top Solution Authors
Users online (2,422)