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

Categories:

Building flows

All responses (6)

Answers (1)

Sort by

manuelstgomes 6,643 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

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

Rob_CTL on at

Like
a
(0)

Report
Copy link

Link copied!

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

Like
a
(1)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!
Hello,
You can alternatively put an expression:
if(not(empty(yourFormObj),length(json(yourFormObj)),0)