A response from MS Forms to a choice(s) column in dataverse

[Robin1988]

I'm struggling whole day with in my opion a very simple action. I just want the answer of a MS Forms multi select check box in a dataverse choices column. A choice single select also no working. I've tried a lot with the explaining video's online but all are related to Sharepoint. Maybe Dataverse is different I can't figure out what to do to make this work. I tried the replace replace replace or join till its like :  answer 1, awnser2, awnser3  (not working  so far)

Please anyone? 🙂 

I have a screenshot of only one I tried. 

[Robin1988]

Morning @Pstork1 here I made a new post, hope you have a few minutes to help me out.

In this last example my dynamic content output of select not showing up.

[takolota · Accepted solution]

I have to enter possible multiple choice meal time options in to my Dataverse table and I just use the following expression to create my string of numbers matching the choices:

replace(trim(concat(if(contains(triggerOutputs()?['body/28 - Service Times Offered'],'Breakfast'),'759090000 ',''), if(contains(triggerOutputs()?['body/28 - Service Times Offered'],'Lunch'),'759090001 ',''), if(contains(triggerOutputs()?['body/28 - Service Times Offered'],'Dinner'),'759090002 ',''))), ' ', ',')

The field is mandatory so I don't have to worry about null values in a replace function, but even if it wasn't mandatory I would just use a if(empty(InsertOutput), '', Replace(InsertOtherFunctions))

to avoid the null values in replace function issues.

All the integer values are available if you go to the table, go to the choices column you are using, go to edit choices, click the three dots ... and select view more.

[Robin1988]

Thx @takolota I had it already found out by my self. But this does the trick 🙂 

[takolota]

Yeah I was working on this yesterday, went to the forums to see if there was a quick solution, and only found a single post involving xml and thought “How could no one have posted a simpler answer to this yet?”

[Robin1988]

Don't know! I was wondering the same. Even MS Support wasn't able to give me an right answer. I thought lots of people need this.

Now I use the value number more often, works perfect in lookups fields to.

[dcastillo1]

Hey Robin!

I am having this same issue and was wondering if you could show photos of your compose and select action expressions for further detail? 

I would greatly appreciate it!

Thanks,

Dillion

[Robin1988]

Hi @dcastillo1 it's more easy then you think.

First find the value you need in Dataverse by open up the settings of the choices column. See above.
Then just replace the awnser form MS Form with the value and paste the output there where you want to update Dataverse.

Compose expression:

replace(replace(outputs('Get_response_details_2')?['body/r2a955ff793174deba029cbce4d68a039'],'Option 1','614100000'),'Option 2','614100001')

[dcastillo1]

Thank you so much! This worked BUT it only worked for the first 3 choices of my choice field. I have 8 total. 

This is what is working so far: 

replace(replace(replace(outputs('Get_response_details')?['body/rd5117fcd2654411ba82921c030ffd4c9'],'Sole Proprietorship','124270000'),'Partnership','124270001'),'S Corporation','124270002')

This is what I need to work: 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')

[Robin1988]

For each put a replace in front:

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')

Accept as Solution if it works 🙂

[dcastillo1]

Awesome! Thanks Robin.

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!

[Robin1988]

@dcastillo1 sorry I missed the notification, did you allready solve this problem?

[dcastillo1]

No problem but I did not. Any thoughts?

[WendyLumsden]

Hi to everyone who contributed/responded to the post  @Robin1988 @dcastillo1 @takolota 

I followed the suggested solutions and replaced the Form Response Input with the corresponding numbers for the Dataverse Choice field.  However I got an error message as follows:

The optionset values sent ["948170000","948170001","948170002","948170003","948170004","948170005","948170006","948170008"] are not valid integers.

How do I change the output array to integers?  Should I replace all the inverteged commas with nothing ("")

[takolota]

@WendyLumsden 

You can try using the int( ) expression in the formula

[WendyLumsden]

Thank you for the prompt reply!  Will give that a try

[dcastillo1]

Did that work for you? 

[WendyLumsden]

Hi @takolota,  @Robin1988, @dcastillo1 the int() funtion did not work since replace function needs a string to be replaced with a string.
I have tried numerous other approaches using arrays, HTML tables .... but as yet not successful.
Will post as soon as I get it working!

[WendyLumsden]

@Robin1988  - you mentioned that "this did the trick" but were you able to update the Dataverse field?  I keep getting a message that the optionset are not valid integers.  Even if I try to update the Dataverse field with an array which was created using int() for all the option values. 

[WendyLumsden]

Hi @takolota , @Robin1988 , @dcastillo1,

I created an array of the codes (using output of the replace function).  I then looped through this array to create an array of integers using int().

However Dataverse will still not accept the array of integers nor the output from a compose function to join the integer-array seperated by commas.

Has anyone been able to update a multi choice Dataverse field?