How do you dynamically set choice fields for dataverse?

(0) Share

Report

Posted on by Mgodby

357

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.

All responses (1)

Answers (0)

Expiscornovus 31,139 on at

Like (0)

Report
Re: How do you dynamically set choice fields for dataverse?

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)