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?