Answered

If then PowerFx formula column based on choice column

(0) Share

Report

Posted on by Dorottya

I have a choice column in my Dataverse with following choices: "Active", "Inactiv", "Delete", and also with blank values. I want to create a formula column, which displays "No Status" for the blank values, otherwise it takes the values from the choice column.

This new formula column should optimally be a choice column as well.

I tried this formula, but it didn´t work out:

If( IsBlank([crd6c_status]), "Kein Status", [crd6c_status] )

I´m grateful for any inputs.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @Dorottya,

I think you need to be able to display as the text value for the output in this case. I did the following and it worked but had to evaluate all choices... I had a Breed which had 4 options...

Switch(Breed, Blank(),"No Breed", 'Breed (Cats)'.Siamese,"Siamese",'Breed (Cats)'.Bengal,"Bengal",'Breed (Cats)'.Sphinx, "Sphinx",'Breed (Cats)'.Tabby,"Tabby")

Note, you could also create a "No Status" option in your Choice field and default the value to this to save having to create a new field... This way it is a valid option in the choice list and defaulted if none selected...

Was this reply helpful? Yes No
Dorottya 10 on at

Like (0)

Report
Copy link

Link copied!

Thank you! That´s exactly what I wanted!
Unfortunately the "No status" as default value method didn´t work out for me, since my choice column gets the data automatecally imported, and the blank values are not considered as no value, and because of that those won´t get the label "No status".
Anyways thank you for the solution!

Was this reply helpful? Yes No