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
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,404)