Counting the number of values within a Form multiple answers box

[Rob_CTL]

Hi,

I have a MS Form that has a multiple answers box like the one below:

What I'd like to do is could the number of answers that is submitted and output the result as a numeric value I can use later within the flow.  I can see that within Flow the values are separated out and I thought I could use length to calculate but that doesn't appear to be working.

Any thoughts gratefully received.

Cheers

Rob

[manuelstgomes]

Hi @Rob_CTL 

Getting information from Forms is tricky because everything comes in string format. I provide more details in how to take care of these issues in this article I wrote.

https://manueltgomes.com/microsoft/forms/format-submitted-data/

Can you please check if and let me know if you have any questions?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[Rob_CTL]

Hi @manuelstgomes 

Thanks for the link.

I can see that the output is formatted in both JSON and a string

I am thinking there must be a way I can manipulate this data into something that I can count, or maybe I am wishing to much 🙂

Cheers
Rob

[manuelstgomes]

Hi @Rob_CTL 

Try the parse JSON action..

But the issue is that everything is a string in Forms. It sucks I know but we need to deal with that 🙂

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[Rob_CTL · Accepted solution]

@manuelstgomes I think I've got a solution, it's not pretty but it works.

- I split the string using the comma as a delimiter

- I then use this output and initialise a variable to create an array

- Finally I use a length expression to count the number of items in the array

The resulting output from this I can then fire into a SharePoint column

If anyone has a more elegant solution it be great to see it.

Cheers
Rob

[manuelstgomes]

Hi @Rob_CTL 

BINGO!!! You did it! That's it. Well done!

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel