web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How to get the ID of a...

Power Apps

Unanswered

How to get the ID of a CRM OptionSet value instead of label

(0) Share

Report

Report

Posted on by jdos3502

31

Hi,

I have an option set on a CRM named "Categorie" that contain the following values :

- Book (10000001)

- DVD (10000002)

- VHS (10000003)

Currently i have the following condition on my apps

Filter(Options; Text(Categorie) = "Book")

But if the label of one categorie change, i have to change my condition.

How can i get the ID "10000001" instead of the label ?

Many thanks

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

SafaK 62 on at

Like
a
(0)

Report
Copy link

Link copied!

you can always Filter or compare the OptionSet using the following [@OptionSetName].Value:

If( ComparedValue = [@Categorie].Book , 1, 0 )

This way, you are selecting the label (comparing two labels) but in reality it's comparing it with the ID, therefore if you are using the above code, even if the label was changed this will still work because it will change automatically based on the ID .

Was this reply helpful? Yes No
StalinPonnusamy Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @jdos3502

You can use the enum value to filter/compare it instead of Text()

In this below example, 'Relationship Type' is an option set

Filter( [@Accounts], 'Relationship Type' = 'Relationship Type (Accounts)'.Consultant )

When you change the label of the option set Powerapps changes automatically. You can create one small test application and test it.

Was this reply helpful? Yes No

Join the conversation