web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Comparing OptionSetVal...

Power Apps

Answered

Comparing OptionSetValue to Text

(1) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hello,

I am currently getting an error that reads:

"Incompatible types for comparison. The left value is a OptionSetValue(secctor_options_keys) and the right is a Text"

So my the OptionSetValue(secctor_options_keys), comes from my table. The table has a column called Sect, where it is a choice field from sectoor_options_keys. (choice NOT choices).

I want to compare this to a text value selected from a Dropdown called SectorDD, which has all of the options hard coded in. Like ["A","B","C"....].

I am trying to filter by using the following code:

Filter('K.E.Y.S', Sect = SectorDD.Selected.Value)

However I am getting the errror message from the beginning of this post under the equals sign.

I was wondering how I would be able to compare there two different OptionSetValue and Text.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(3)

Report
Copy link

Link copied!
Hi @Anonymous,

Could you please modify your formula as below:

Filter('K.E.Y.S', Text(Sect) = SectorDD.Selected.Value)

This will lead to the delegation warning, if your data set is not very huge, please ignore this warning.

Regards,

Qi

Was this reply helpful? Yes No
BenDonahue 932 on at

Like
a
(0)

Report
Copy link

Link copied!
One way to get around this delegations issue is to add a column and populate that with the text value of Sect:
ClearCollect(colKEYS, Filter(AddColumns('K.E.Y.S.', "_textSect", Text(Sect), _textSect = SectorDD.Selected.Value));

"I do it for the Kudos, :)"

Was this reply helpful? Yes No

Join the conversation