MS Form Choice Field Defaulting To The Top Choice In Cloud Flow. MS Forms -> Cloud Flow -> Add New Row Into Dataverse.

[dcastillo1]

Hello!

I have a cloud flow built out to add a new row into a dataverse table. All the regular text fields flow into the table correctly but all of the choice fields automatically default to the top choice. Any thoughts? 

Thanks!

Dillion C.

[TheRobRush]

Gatehring Choice Columsn form a form is different than text fields etc. What is the Sharepoint list column types you will be storing them in?

[TheRobRush]

Let's say for example, you are dropping the forms choice column into a SHarePoint List column with a choice type (be sure to turn on allow custom and multiple) it would go like this

When Response submitted triggers flow,

get Response Details

WhatTimeisit(you can ignore that it is specific to my use)

Now Compose, in inputs you go to expression and put the following 

replace(replace(outputs('Get_response_details')?['body/ra306a75c628440d9911655134d39fa3e'],'[',''),']','')

to get the correct value to replace of your own for ra306a75c628440d9911655134d39fa3e you will need to run the flow with just the get results part, then look at its results, 

at the bottom, in body, look for the choice column and take its identifier

once you have this plug it into the expression above.

In the from of the Select, goto expression and type

json(body('Get_response_details')?['ra306a75c628440d9911655134d39fa3e'])

again replacing the code with your code

In the below section map Value to Item()

After that in your create item section your sharepoint choice column value will be 

body('Select')

[TheRobRush]

*Updated above, forgot to add replace into the compose step.

If the column you would like to store choices in is single line of text jus treference the compose output instead of select

[dcastillo1]

Hey Rob,

This is the error I am receiving. So once I parse the choice selected, I want to add it to a Dataverse table as a new row. 

Steps code:

Compose: 

replace(replace(outputs('Get_response_details')?['body/r58ae6d83109f48d3bfc817af41111ee8'],'[',''),']','')

Select: 

json(body('Get_response_details')?['r58ae6d83109f48d3bfc817af41111ee8'])

Map: Enter Key: Value

Enter Value: item()

Add a new row into Dataverse table:

body('Select')

Let me know. I appreciate the help!

[TheRobRush]

Did you ever get this fixed? somehow it didnt show me that you had responded. Need to see the result of that compose if possible. Maybe remove the select temporarily and have the flow email you a copy of what the compose output was so we can figure out why the error

[dcastillo1]

Hey no worries Rob. I actually found another route to get what I needed but ran into a couple other issues you may be able to help out with. So once again, I am taking a MS form response and wanting to add a row into Dataverse. Every regular single text field feeds correctly except the choice field questions. 

This is what I have in my Compose expression: 

replace(replace(replace(replace(replace(replace(outputs('Get_response_details')?['body/rd5117fcd2654411ba82921c030ffd4c9'],'Sole Proprietorship','124270000'),'Partnership','124270001'),'S Corporation','124270002'),'C Corporation','124270003'),'LLC Taxed as a Disregarded Entity','124270004'),'LLC Taxed as a Partnership','124270005'),'LLC taxed as an S Corporation','124270006'),'LLC Taxed as a C Corporation','124270007'),'Other','124270008')

So 'Sole Proprietorship','124270000'),'Partnership','124270001'),'S Corporation','124270002'),'C Corporation','124270003'),'LLC Taxed as a Disregarded Entity', and the last choice Other','124270008' work perfectly and the text is replaced with the integer correctly.

All other options that have a string that has been used in a prior choice are failing. The compose output looks like so :

The replace function is getting confused. How can I avoid this?

This is how it should look. This is the flow working when I choose the "other" option on the form. 

I appreciate all the help!

[TheRobRush]

can you place the images as attachments instead of pastign them into the reply? for some reason doing it that way makes impossible to zoom in on the details and I only get to see a blurry image that I can't really read 😞

[dcastillo1]

[TheRobRush]

Not sure how they looked before uploading but this is how those pictures are turning out (see attached) and this is them blown up as large as they get.