if column contains anything then... (New Column)

(0) Share

Report

Posted on by md7

232

Hi all,

I'm trying to make a new formula column that is auto-filled based on other columns.

It's a fairly simple argument where if a column one contains anything then return column 1, but if column 2 contains anything then return column 2 and so on. I have 9 different columns so the formula could be quite long. I'm unable to choose the coalesce function for some reason.

I was hoping that this formula would work but I get errors when inputting it.

If(Not(IsBlank('column1')),'column1',If(not(isblank('column2')),'column2','column3'))

Any help is appreciated. Thanks in advance.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @MD7 ,

I tested with 4 of them and was able to get it to complete without errors following this syntax:

If(Not(IsBlank(column1)),column1,If(Not(IsBlank(column2)),column2,If(Not(IsBlank(column3)),column3,column4)))

What error are you getting? Is it not accepting your formula?

Was this reply helpful? Yes No
md7 232 on at

Like (0)

Report

Hi, thanks for looking into this.

I get the error "The result type OptionSetValue is not supported in formula columns." Does it matter that the columns1, 2, 3 ect are Choice columns? Or could it be something else?

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report
Hi @MD7 ,

Not supported currently. You can only use the following types in a formula column. My example was text above...

Text

Decimal Number

Yes/No (boolean)

Date

Was this reply helpful? Yes No
md7 232 on at

Like (0)

Report

Ah that's a shame. Is there an alternative way to add this to a model driven app? Without a new column?

Was this reply helpful? Yes No
Verified answer

Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report
Hi @MD7 I would look at the following. I would start with Business Rules to see if you can configure that way first.

Business Rules

Real-Time Workflows

Power Automate

Was this reply helpful? Yes No
md7 232 on at

Like (0)

Report

Thanks for your help. I was able to do it by making a workflow using the classic view. I don't fully understand the new flows view.

Was this reply helpful? Yes No