Answered

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

(0) Share

Report

Posted on by wmickey

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.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

AhmedSalih 6,678 Moderator on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
wmickey 4 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
AhmedSalih 6,678 Moderator on at

Like (0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No