Answered

Counting the number of values within a Form multiple answers box

(0) Share

Report

Posted on by 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

All responses (6)

Answers (1)

MPruszewicz 4 on at

Like (0)

Report
Re: Counting the number of values within a Form multiple answers box

Hello,
You can alternatively put an expression:
if(not(empty(yourFormObj),length(json(yourFormObj)),0)
manuelstgomes 6,625 on at

Like (1)

Report

Re: Counting the number of values within a Form multiple answers box

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
Verified answer

Rob_CTL on at

Like (0)

Report

Re: Counting the number of values within a Form multiple answers box

@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 6,625 on at

Like (0)

Report

Re: Counting the number of values within a Form multiple answers box

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 on at

Like (0)

Report

Re: Counting the number of values within a Form multiple answers box

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 6,625 on at

Like (0)

Report

Re: Counting the number of values within a Form multiple answers box

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