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.
Any chance you ever found a solution to remove the quotes? Dealing with the same issue. Unable to email out due to slashes.
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.
Speakers, submit your sessions now! Call for speakers ends Feb. 10!
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!