Power Platform Community Forum Thread Details

Hi, have a column of data from Excel however I'm having a tough time formatting it.

Input:

123

456

789

I add the data to a variable however it ends up looking like this: "123,456,789,"

Notice quotes are missing from each batch of data and there's a comma at the very end that shouldn't be there.

Here's the formula I'm currently using: Set(abcList,Concat(Split(TextInput1.Text,""),If(IsMatch(Value,"\n"),",",Value)))

This is the variable output I desire: "123","456","789" because I'm sending it over to a Power Automate flow.

Any ideas?

Categories:

Formatting data pasted from Excel into a text box to a variable