Power Platform Community Forum Thread Details

Hey all - trying to convert data from a microsoft form response into an array that can then be used to loop through for an excel file.
The microsoft form requires the user to enter any amount of ten digit numbers, separated by new lines. This is b/c they'll be copying from an excel file column.

So, the response to the form will always look something like this:

3200632070
3200632071
3200632072
3200632073

My flow is currently using: get response details > initialize variable as string > using compose to process the variable. Supposedly, the compose function replaces line breaks, semicolons, and spaces with commas, then splits the string into an array. However, the output looks like this:
3200632070\n3200632071\n3200632072\n3200632073

As you can see, none of the line breaks (represented by \n) were replaced by commas, so it's still showing up as one large string. What this automation is trying to do is check for matches between the microsoft form and an excel file. This file has all of these values in a column, but my flow can't check for matches b/c it's not looking for 3200632070, then 3200632071, etc., it's looking for 3200632070\n3200632071\n3200632072\n3200632073.

Does anyone know how or what I can add to ensure that the response to the form comes out as an array that a loop can use to check a file for each individual ten digit value?

If it's needed, the code for the compose function I'm referencing looks like this -

{
  "type": "Compose",
  "inputs": "@\r\nsplit(\r\n    replace(\r\n        replace(\r\n            replace(\r\n                replace(\r\n                    replace(variables('var_rawIds'), '\\r\\n', ','),\r\n                '\\n', ','),\r\n            '\\r', ','),\r\n        ';', ','),\r\n    ' ', ''),\r\n',')\r\n",
  "runAfter": {
    "Initialize_variable": [
      "Succeeded"
    ]
  }
}