I want to use STRING_AGG in Power Automate Desktop.
But I can’t make it.
Anyone tell me what’s wrong with Power Automate Desktop with SQL ?
I want to make this table.
| ID | Num |
|---|---|
| 1 | 1;2;3 |
| 2 | 1;2 |
From this table
| ID | Num |
|---|---|
| 1 | 1 |
| 1 | 2 |
| 1 | 3 |
| 2 | 1 |
| 2 | 2 |
I mean , I want to concatenate text each row with same ID.
I tried STRING_AGG cuz I think powerautomate desktop sql is sql server.
best regards,
New contributor
John Reese is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
1