Showing results for 
Search instead for 
Did you mean: 
New Member

Setting dataverse option set from a Microsoft forms choice selection

Hi, I have an application form set up on Microsoft forms, and I am wanting each submission to create a record on a model driven app. For the most part this works fine, but where I am currently falling over is trying to set the option set values for the model driven record with the selections from the form.


The form’s choice selection pulls through as a text value and the “Add a new row” requires an integer to set the option set. 

I have around 15 different option sets with about 15 options each, so hard coding corresponding integer values will make this flow extremely fat,

so I’d like to know if there’s a far more dynamic way to set the option Set value from the text selection on the form submission.


If anybody knows how to dynamically get the corresponding integer attribute for the option set label then that would allow me to dynamically set it too. 



Helpful resources

2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (1,921)