cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mgodby
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:
softwareinvolved.png

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

Mgodby_0-1632953337767.png

 

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.



1 REPLY 1
Expiscornovus
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.

  dropdownlist_options.png

 

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) 

 

 

 

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,783)