web

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

News and Announcements icon

Power Platform CommunityForums Power Apps If statement with "cho...

Power Apps

Answered

If statement with "choice" columnn

(0) Share

Report

Report

Posted on by Lonsdejlit

57

I try to create a column in a Dataverse (table) and make simple if- function but it does not work.

The column named "Year" has data type choice.

I created two choices ("Sync with global choice": No) with label: "24", value "1" and label "25", value "2".

I created a new column named "test". Data type "Formula (Preview)". The formula is: "If( Text('Year'.Value)=1, 1, 0) but it does not work.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like (5)

Report
Copy link

Link copied!
Hi @Lonsdejlit ,

First of all, when creating an option-set, please do not modify default Value values as they are inner ids:

So, I assume the choices of Fx are 1&2:

FxText is the Choice column:

Formula column expression would be as follows:

If(ChoiceColumnName = OptionSetName.ChoiceValue, result1, result2)

Best regards

Was this reply helpful? Yes No
GrantBaker 6 on at

Like (0)

Report
Copy link

Link copied!

Thank you for this!

Was this reply helpful? Yes No
psantostriumph 6 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much @v-jefferni

Just want to add for people like myself who just found Dataverse 3 days ago.

To create the option set (1 step in the solution) you must have the "Sync with global choice" selected to Yes before you add the "New choice". I had it to "No" and was just not getting there, even if it was in the posted image.

Was this reply helpful? Yes No

Join the conversation