web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Struggling to fetch choice field labels from dataverse in flows

(0) ShareShare
ReportReport
Posted on by 18

Hi everybody!

I'm struggling to fetch the label(text) of a choice field in my flow. Check the screenshots below for more details:

 

GriffinMaree_0-1699591894381.png

I'm trying to get the "Quarter Day" text (Length Label) instead of the number. The field name should be "_cr1e2_length_label" right?
So, I wrote the following Odata expression: outputs('When a row is added, modified or deleted')?['body/_cr1e2_length_label']

 

When I place this expression in a initialize variable step and try to save, power automate gives me the following error...

 

GriffinMaree_1-1699592165595.png

 

"Flow save failed with code 'InvalidTemplate' and message 'The template validation failed: 'The action(s) 'When a row is added, modified or deleted' referenced by 'inputs' in action 'Initialize_variable' are not defined in the template"


Anybody got any ideas what's going on?

I have the same question (0)
  • Verified answer
    ManishSolanki Profile Picture
    15,089 Super User 2025 Season 2 on at
    Re: Struggling to fetch choice field labels from dataverse in flows

    Hi @Griffin-Maree 

     

    You need to write an expression to get the label of single choice field. Expression needs to be entered in the expression window as shown below in the below example:

    ManishSolanki_0-1699595095896.png

     

    The expression which you need to use in your flow is:

    triggerOutputs()?['body/_cr1e2_length_label']

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 659 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 386 Moderator

#3
chiaraalina Profile Picture

chiaraalina 290

Last 30 days Overall leaderboard