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?
