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!
Announcements
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!
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:
Did I answer your question?😉 Like my answer? Like it! 👍
|
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
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!
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?😉 Like my answer? Like it! 👍
|
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:
Hi @TKS0001
can you post the error that is occurring when processing the function? If possible also post the header of your Sharepoint list.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.