cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rob_CTL
Helper V
Helper V

Counting the number of values within a Form multiple answers box

Hi,


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

 

flow-1.png

 

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.

 

flow-2.png

 

Any thoughts gratefully received.

 

Cheers

Rob

1 ACCEPTED SOLUTION

Accepted Solutions

@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

 

flow-10.png

 

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

 

Flow-11.png

 

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

 

Flow-12.png

 

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

 

Flow-13.png

 

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

 

Cheers
Rob

 

View solution in original post

5 REPLIES 5
manuelstgomes
Super User II
Super User II

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

Hi @manuelstgomes 

 

Thanks for the link.

 

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

 

flow-3.png

 

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

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

@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

 

flow-10.png

 

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

 

Flow-11.png

 

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

 

Flow-12.png

 

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

 

Flow-13.png

 

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

 

Cheers
Rob

 

View solution in original post

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

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (847)