I was trying to create a flow that copy Microsoft Forms response to Dataverse entity. I encountered some trouble when attempting to fill in option set field in Dataverse. For example, in the Forms query there is a field named "Sex" with two options Male/Female. There is also an identical field in Dataverse entity. However, in the flow designer, I could not fill in an option set field with dynamic content I obtained from Forms response. The only way I achieve this seems to be changing the data type of the "Sex" field to text... Is there any way to maintain the field type of "option set" while having the flow work?
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:
Hi @randypan ,
Please check out the following article to set the Choice column based on a String value from the text field.
Updating Dataverse Optionset/Choice from Text dynamically using Power Automate (d365geek.co.uk)
Hope this helps!
Thanks,
Drew
WarrenBelz
146,745
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional