Choice Field - using dataverse Label rather than Value, in Flow expressions

(0) Share

Report

Posted on by ArtieLeech

In our order processing system, we have a Choice Field.

Additionally, our Orders table has a field which refers to this Choice Field.

When our flow processes Orders, currently we compare the Order's Order Status to the numeric Value above, which we don't like:

We'd prefer to use the Label instead, something like below (so we don't have to care about the underlying value in flows, just the Choice Field's Label)

How can we do this?

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sundeep_Malik 6,484 on at

Like (0)

Report
Copy link

Link copied!

Hey @ArtieLeech , can you share the flow above if possible? I might be able to provide a solution.

Was this reply helpful? Yes No
ArtieLeech 42 on at

Like (0)

Report
Copy link

Link copied!

Hi @Sundeep_Malik, I've added a screenshot of another flow which uses a similar pattern below.

In this one, in the Switch Equals clauses, we'd rather use the Labels that equate to the long integer values, i.e. New, In Progress, Fulfilled.

In other words, like an enum in C#.

Was this reply helpful? Yes No
Expiscornovus 33,501 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @ArtieLeech,

You could use the label part of the field, there should be a separate attribute for that.

To give you an example.

My choice field is called crca4_orderstatus. The label would be _crca4_orderstatus_label.

In an expression that would be:

triggerOutputs()?['body/_crca4_orderstatus_label']

Was this reply helpful? Yes No
ArtieLeech 42 on at

Like (0)

Report
Copy link

Link copied!
@Expiscornovus , thanks for this suggestion. How would this tie in with us having the OrderStatus passed into our Flow as its numeric value?

Is there a way we could have it so we can say something like

_crca4_orderstatus_label.New

so that the Flow Checker would detect an error if, say, we renamed New to Open?

Was this reply helpful? Yes No
GrantBaker 6 on at

Like (0)

Report
Copy link

Link copied!

I had the same problem and found the solution here: https://www.encorebusiness.com/blog/power-automate-get-choice-label-metadata/

Was this reply helpful? Yes No