I am a Flow noobie and I am running into two issues:
1. Is there a way to parse the data that Forms kicks out, specifically removing the [" "] around each item for a checkbox question? I would like to be able to handle the data in future steps without any formatting. I have tried playing around with the various Data Operations but so far cannot figure out how to parse that data. Example:
Cell Phone: ["Android"]
2. Similar to the above question, I am taking the output of that question and checking it against an excel spreadsheet to see who the data owner is. I can't figure out how to take each answer from that question and make it its own data point. For example, if the form was filled out and 5 checkboxes were checked on this question. I want to be able to have flow check each of the 5 data points against my excel spreadsheet and start an approval on the appropriate person that is assigned there. Example:
Required Systems: ["Adobe Acrobat Professional","Visio"]
Any help is greatly appreciated!
About #1, how is the checkbox question field created in Microsoft Forms? I assume that it should be of Choice type field, and the value for selections are of format [“Android”], am I right?
Then I made a simple test on my side likes below. In the Compose2, use the following code to remove the [“”] around the item.
Please check the following screenshot for a reference:
About #2, do you want to get the appropriate person’s email address depends on the response of the forms?
Please try to use the Excel action Get rows, then use a Condition to check if they have the common value, if yes, send an email to the person.
Please feel free post back if you need more help.
Regarding to #1, I was successfully remove [""] by using the following code but it doesn't work if multiple checkboxed are checked from the form.
["Android"],["Apple"] then uses the code to remove [""] = Android","Apple
Is there another code that I will need to remove those quotes? I am trying to implementing it with send email with options so the quotes is throwing it off.
Try using the replace expression.
After the first comma, I have a double quote wrapped in two single quotes.
After the second comma, I have two single quotes with nothing in between.
I haven't tested this but it should work for you.
It could go in the email action - it's up to you. You can also use a variable or compose action and reference either of those in the email instead - your choice.
The following is convoluted but works for me...
I would consider this solved.
Check out how to claim yours today!
Check out new user group experience and if you are a leader please create your group
Test your skills now with the Cloud Skill Challenge.