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)

Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report
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

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