Answered

CDS optionset value in Switch command

(0) Share

Report

Posted on by BClouded

174

Dear community

I have a gallery and I want to change the template fill property based on the value of an option set.
ThisItem.'Agreement Status' -> this is an Option Set field in CDS. With 5 options:
Not Sent (Value: 0)
Out for Signature (Value: 1)
Signed (Value: 2)
Declined (Value: 3)
Canceled (Value: 4)

Switch(ThisItem.'Agreement Status',0,Red,Green) nor Switch(ThisItem.'Agreement Status',"Not Sent",Red,Green) isn't working.
What am I doing wrong?

Thanks!
Bart

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

timl 36,785 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi Bart,

From the test that I did, referencing option set field returns the option set text, rather than the ID. This is probably one cause of the problem.

If your requirement is to set the fill property to read if the status is 'Not Sent', and to set it to green for other statuses, you can accomplish this more easily with the If function. The syntax I would try is this:

If(ThisItem.'Agreement Status' = "Not Sent", Red, Green )

Was this reply helpful? Yes No
BClouded 174 on at

Like (0)

Report
Copy link

Link copied!

Hi timl
Thanks for your response, unfortunately that gives an error "Incompatible Type".
I did to so many times with choice fields in SP datasource but in CDS this seems so much more complicated... 😕

Was this reply helpful? Yes No
Verified answer

timl 36,785 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @BClouded

Sorry about that - could you try the following?

If(ThisItem.'Agreement Status' = [@Agreement Status].NotSent, Red, Green )

You should be able to access the Agreement Status enumeration through [@Agreement Status]. If not, you could try [@'Agreement Status']. Hopefully, this will work.

Was this reply helpful? Yes No
BClouded 174 on at

Like (0)

Report
Copy link

Link copied!

@timl

Thanks mate! 🙂

Was this reply helpful? Yes No
timl 36,785 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

You're welcome - glad that helps!

Was this reply helpful? Yes No