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.