You’re offline. This is a read only version of the page.
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.
@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.
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.
@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.
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
17
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
