web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Pages How can I refer to a c...

Power Pages

Answered

How can I refer to a choice column from a dataverse formula column

(0) Share

Report

Report

Posted on by MJWhite

338

Hi there

I can refer to a text column from a dataverse formula column, but when I try to refer to a choice column, it gives an error (see screenshot below where Name Prefix is a choice column). It wants text and I suspect the error is because a choice is stored as a number, but I can't see how to refer to the text choice values and avoid the error.

Any suggestions?

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Verified answer

Jcook 7,781 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hello @MJWhite

Currently, Power fx columns in dataverse can’t use Choice (option set) columns in formula.

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/formula-columns?tabs=type-or-paste#data-types

what is the use case you are trying to do?

Was this reply helpful? Yes No
MJWhite 338 on at

Like (0)

Report
Copy link

Link copied!
Thanks for the link. Saves me looking further. I'll shortly accept your reply as a solution.

I frequently want to do two things:
Concatenate text from a text column with text from a choice column, as per the above example
Use text from a choice column in an IF statement, either as part of the conditional test, the true response or the false response
For the moment, I'll continue to use real-time workflows as they can do the above and:
Work on the Primary Name column
Refer to data in related tables
I was investigating the Power Fx column because I'm nervous that Microsoft might discontinue functionality which looks old but works (real-time workflows) with functionality that isn't yet fit for purpose but looks new (Power Fx column).

Was this reply helpful? Yes No

Join the conversation

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Power Pages

#1

#2

#3

oliver.rodrigues 29 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Solution to LinkedIn Authentication in Power Apps Portals

Welcome to the Power Pages forum!

Product updates

Microsoft Power Platform Community release plans