Formatting MS Forms response to be used later in the flow

[JPey]

Hello everyone,

Somewhat new to Power Automate, but really appreciate the potential I am seeing. 

Background:

I have a long text question I am asking in an MS form: 

"Enter 10-digit phone number, if you have multiple numbers please separate them with a comma

ex1: 5555555555   |    ex2: 5555555555,1111111111,2222222222"

The problem is most people are coping numbers from an excel spreadsheet and pasting them in the form answer box causing the answer to look like this:

1111111111

2222222222

3333333333

4444444444

In order to use the numbers in the next part of the flow, I need them in the format of:

1111111111,2222222222,3333333333,4444444444

Question:

Is there a method in power automate to check if there is a comma every 10 digits, and if not add one?

Is there a better way to solve my problem, than the question above? 

Any guidance you can provide is greatly appreciated. Thanks in advance!

[JPey]

Any ideas? Maybe it is not possible, but it seems like it should (in my head at least) 🙂

[v-yujincui-msft]

Hi @JPey ,

I have made a simple test for your reference.

1. Here is my Form.

2. Here is my Flow.

replace(replace(outputs('Compose'),' ',''),',','')

range(1,div(length(outputs('Compose_2')),10))

substring(outputs('Compose_2'), add(mul(item(), 10), -10), 10)

substring(variables('phonenumber'),0,add(length(variables('phonenumber')),-1))

Result Screenshot:

Best Regards,
Charlie Choi

[JPey]

Thanks, I'll try this out today and report back. 

[JPey]

@v-yujincui-msft when I try your flow, I enter the phone numbers copy and pasted from excel, into my long answer phone number question it looks like this

1111111111

2222222222

3333333333

The flow says it ran successful, but when I look at the compose 3 result, I get: 

1111111111\n2222222222\n3333333333

What I need compose3 to reflect is:

1111111111,2222222222,3333333333

Any idea on what I am missing?

[v-yujincui-msft]

Hi @JPey ,

Maybe you could try the following expression:

replace(replace(replace(outputs('Compose'),' ',''),',',''),decodeUriComponent('%0A'),'')

Result Screenshot:

Best Regards,
Charlie Choi

[JPey]

@v-yujincui-msft This is very close! When I enter the phone numbers question with:

1111111111

2222222222

I get the result: 1111111111222222222

I need the result: 1111111111,2222222222

The /n is gone, but there is no comma separation between the two numbers and the last numbers is missing a digit. I enter 10 digits for the second number, but the last digit is lost on the last phone number?

Any ideas?

[v-yujincui-msft · Accepted solution]

Hi @JPey ,

Sorry i didn't reproduce this problem, it seems that works fine on my side.

Result Screenshot:

Maybe you could consider checking the run history and expressions(Note the name of the dynamic content in the expression).

replace(replace(replace(outputs('Compose'),' ',''),',',''),decodeUriComponent('%0A'),'')

range(1,div(length(outputs('Compose_2')),10))

substring(outputs('Compose_2'), add(mul(item(), 10), -10), 10)

substring(variables('phonenumber'),0,add(length(variables('phonenumber')),-1))

Best Regards,
Charlie Choi