cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PRAVAKARPANTA
Frequent Visitor

Dataverse Choice - get actual data

Hi,

I am new to using dataverse into powerautomate. I am trying to populate word document using columns from custom dataverse table. The table is populated from portal that i have created. 

 

The problem is with choice column. In the place holder of word file when I try to use choice columns it comes with the value instead of label. 

 

How can i get the label, not the value? 

 

PRAVAKARPANTA_0-1660104911494.png

 

I want full time when the user selects full time not value.

 

PRAVAKARPANTA_0-1660105393817.png

 

I have used following dynamic content in powerautomate

 

PRAVAKARPANTA_0-1660106508546.png

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
rampprakash
Super User
Super User

Hi,

 

You can simply use the code in Expression like below

 

EmployeeTypeLogicalName@OData.Community.Display.V1.FormattedValue

 

Note : EmployeeTypeLogicalName: Is the Logical name of the Choice Field like new_ or creadf_

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Follow me on Twitter : @rampprakashd
Blog : https://microsoftcrmtechie.blogspot.com

View solution in original post

dpoggemann
Super User
Super User

Hi @PRAVAKARPANTA,

 

This video walks through detailed example of this approach.  https://youtu.be/bJlaAYx-AmE to pull the right values for the text vs. the values...

 

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew

View solution in original post

4 REPLIES 4
rampprakash
Super User
Super User

Hi,

 

You can simply use the code in Expression like below

 

EmployeeTypeLogicalName@OData.Community.Display.V1.FormattedValue

 

Note : EmployeeTypeLogicalName: Is the Logical name of the Choice Field like new_ or creadf_

 

Please mark as Answer if it is helpful and provide Kudos


Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Follow me on Twitter : @rampprakashd
Blog : https://microsoftcrmtechie.blogspot.com

dpoggemann
Super User
Super User

Hi @PRAVAKARPANTA,

 

This video walks through detailed example of this approach.  https://youtu.be/bJlaAYx-AmE to pull the right values for the text vs. the values...

 

Hope this helps. Please accept if answers your question or Like if helps in any way.
Thanks,
Drew

Thank you it helped.

 

Thank you. The video makes it lots more clearer for beginners like me. 

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (3,697)