Unanswered

Formula Column Data Type Choice - nested if

(0) Share

Report

Posted on by TTPlayer

I have a formula column of data type choice. If I write a simple condition everything works. For example:

If(Name = "Test",
    Unterlagenstatus.'liegt vor',
    Unterlagenstatus.'liegt vor'
)
 

As soon as I add a second condition I get an error message:

If(Name = "Test",
    Unterlagenstatus.'liegt vor',
    If(Name = "Test",
        Unterlagenstatus.'liegt vor',
        Unterlagenstatus.'liegt vor'
    )
)
 
Error: The operation cannot be performed on multiple Option Sets. Please use single Option Set as result type.
 
If I convert it as follows, the error doesn't occur.
 
If(Name = "Test",
    If(Name = "Test",
        Unterlagenstatus.'liegt vor',
        Unterlagenstatus.'liegt vor'
    ),
    Unterlagenstatus.'liegt vor'
)
 
Can someone explain to me what I'm doing wrong? Or is this a system error?
 

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Shashank Bhide 946 Moderator on at

Like (1)

Report
Copy link

Link copied!
have you tried using switch? your second if condition doesn't seem to fit in the way "If" works in powerapps which is just a sequece of condition1->result1, condition2->result2

If( Condition1, ThenResult1 [, Condition2, ThenResult2, ... [ , DefaultResult ] ] )

Was this reply helpful? Yes No
TTPlayer 2 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your reply. I managed to create my formula correctly in another way.
But I still don't understand the problem. Why doesn't the above example work?

The following variant works. If I use choices instead of text, I get the error above. Why?

If(Name = "Test",

"A",

If(Name1 = "Test",

"B",

"C"

)

)

Was this reply helpful? Yes No
AS-01110123-0 2 on at

Like (0)

Report
Copy link

Link copied!

I just ran into the same issue, and changing to the format of "if" suggested by Shashank Bhide worked for me with a Choice.

I think the issue with the nested "if"s is that the return value of the inner if is a Yes/No - so the return value is then a mix of your Choice and Yes/No, rather than always your Choice.

Was this reply helpful? Yes No