Skip to main content
Community site session details

Community site session details

Session Id : KaFMr/h/bF4li75Jp5vcEm
Power Apps - Microsoft Dataverse
Answered

PowerApps Canvas App - Want to access a dataverse choice value of a column

Like (0) ShareShare
ReportReport
Posted on 20 Jul 2022 19:58:31 by 4

I have a form in PowerApps that uses a dataverse table. The table has columns that are of type 'Choice'. In the form it shows the labels of each choice column but I need to be able to access the value of the choice fields to do some calculations?

 

Is that possible?

 

Here is what one of my choice columns looks like.  Drop down as an example shows 11-15 and when you submit the form it gets stored as 11-15 in the table.  I want to access the value (3) though in my PowerApps to do other calculations and then display and update a separate table field.

 

choices.jpg

Categories:
  • AhmedSalih Profile Picture
    6,678 Super User 2025 Season 1 on 21 Jul 2022 at 15:42:11
    Re: PowerApps Canvas App - Want to access a dataverse choice value of a column

    @wmickey , i think you are right. You can post this idea for Microsoft to consider it, check the link bellow:

    https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas

     

     

    Regards,
    Ahmed
    If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.

  • wmickey Profile Picture
    4 on 21 Jul 2022 at 13:43:06
    Re: PowerApps Canvas App - Want to access a dataverse choice value of a column

    Hello Ahmed!  I can't believe this isn't a capability that is present!   I appreciate your input.  I did create a flow that calculated what I need to do, the only issue there was the amount of time it took to kick off the flow and return.  I was looking for something more on the fly and responsive!  Again, Thank you for your response.  I wonder if they'll add this ability in the future!?  I couldn't access the values in PowerPages either and that is originally why I created the flow to retrieve the values and do my calcs.

  • Verified answer
    AhmedSalih Profile Picture
    6,678 Super User 2025 Season 1 on 21 Jul 2022 at 13:01:37
    Re: PowerApps Canvas App - Want to access a dataverse choice value of a column

    @wmickey , there is no way to do this from PowerApps (Canvas) but you can retrieve the values using Power Automate. Check this article and see if it can helps your use case: https://jamesyumnam.com/2022/01/12/using-values-from-dataverse-choice-and-choices-columns-in-power-automate-flow/

     

    An idea is to use Power Automate for your calculation and set the flow to return an output to your Canvas app.

     

     

     

     

    Regards,
    Ahmed
    If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.

     

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

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 1

Featured topics

Loading complete