Showing results for 
Search instead for 
Did you mean: 
Post Patron
Post Patron

How do you dynamically set choice fields for dataverse?

Is there a way dynamically set choice fields for dataverse?

I have a flow that takes text input fields:

And I'm wondering if there's a way to use that to set the choice field when I create a new dataverse record:



When I add the text input dynamic content, I get an error message. Is there any way to make the choice field dynamic based on the value they put when they run the flow.

Super User
Super User

Hi @Mgodby , 


Every choice field value has a related number. So, if you know the number of the value you can set it dynamically.


What you could do is add a dropdown list of your choice options to your trigger action. In that list you can match the numbers from your choice field options by putting the correct numbers in front of the label.


Below is an example of that approach.



In the dataverse field you could use the expression instead of the dynamic content field. 

That expression will return the first character of the option. In the case of '3. Microsoft Teams' that will be '3'. If your options are longer numbers you have the change the length of the substring function.



substring(triggerBody()['text'], 0, 1) 





Happy to help out! 🙂

Interested in more #PowerAutomate #SharePointOnline or #PowerVirtualAgents content?
Visit my blog, Subscribe to my YouTube channel or Follow me on Twitter

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,163)