Concat 'Choices' and 'Single Line of Text'

(0) Share

Report

Posted on by luccamalucelli1

Hi,

I'm having trouble to concat 3 columns in a single line text one

My columns are:

- Evaluated Property: Single Line of Text (from a LookUp list)

- Matrix: Choice Field

- Category: Choice Field

My output / result column is a Single Line of Text

- Project Title: Multiple Line of Text

On Power Automate, this is the synthax I tried

concat(triggerBody()?['EvaluatedProperty'],triggerBody()?['Matrixx'],triggerBody()?['Category'])

My output on column Project Title is {"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":14,"Value":"Moisture"}{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":3,"Value":"Caramel"}{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":1,"Value":"Biscuit"}

I've run another test by changing Project Title type to Single Line of Text. Now, I am getting an error related to 255 characters exceeding count.

Any suggestions on how to achieve the concatenation of all columns? Am I missing something here?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

creativeopinion 10,504 Moderator on at

Like (0)

Report
Copy link

Link copied!

@luccamalucelli1 You need to ensure you are selecting the appropriate dynamic content. For your choice columns, you need to ensure you are selecting the value dynamic content to output the value.

Same goes for your look up column.

Tip: Use a Compose action to store the dynamic content to check the output in a test run. For more troubleshooting tips check out this YT Tutorial: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

IN THIS VIDEO:

✅ How to troubleshoot a false Condition action result

✅ How to get dynamic content when it isn’t selectable from the list of dynamic content

✅ How to troubleshoot an Apply to Each action that isn’t looping through

✅ How to troubleshoot a skipped Apply to Each action

✅ How to troubleshoot a Filter Query

✅ How to use a SharePoint yes/no column in a Filter Query

✅ How to use Compose actions to troubleshoot a Power Automate flow

✅ How to troubleshoot multiple emails being sent

✅ How to troubleshoot multiple Teams messages being sent

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram

Was this reply helpful? Yes No
luccamalucelli1 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @creativeopinion! Thanks for your reply!
For some reason, I can't find under Dynamic Content the options 'Single Choice Value' and 'LookUp Value' you mentioned, as you can see below.

I am not familiar with 'Compose' action .. how can I use the columns from my list to retrieve the concatenation of all three to render a new single line of text column?

Thanks!

Was this reply helpful? Yes No