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
Solved! Go to 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
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
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
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
- 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
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
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
70 | |
22 | |
18 | |
17 | |
13 |
User | Count |
---|---|
126 | |
37 | |
30 | |
28 | |
26 |