Unanswered

Two option set comparition

(0) Share

Report

Posted on by BlackRos

 I have to compare a number with an Option Set field, like the following 
 statement in a condition but it fails
   
 3 in Team.poste_portfoliohierarchy
   
   Any help?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

v-siky-msft on at

Like (0)

Report
@BlackRos

Do you mean the 'poste_portfoliohierarchy' is an OptionSet field and you want to check if the 3 is in that field?
Is '3' one of the Options of 'poste_portfoliohierarchy' field?
If so, the codes should be:
'poste_portfoliohierarchy(Team)'.'3' in Team.poste_portfoliohierarchy
Sik

Was this reply helpful? Yes No
BlackRos 24 on at

Like (0)

Report

I have this statement
ClearCollect(
UfPost;
Filter(
UtentiCol;
Userid = systemuserid
).'Team (teammembership_association)'.'Ufficio Postale'.'poste_name';
false in Team.poste_isportfolioservice &&
3 in Team.poste_portfoliohierarchy &&
0 in Team.poste_portfoliotype &&
false in Team.isdefault && "dico_" in Team.name
)

Here
3 in Team.poste_portfoliohierarchy &&
0 in Team.poste_portfoliotype &&
not working

Team.poste_portfoliohierarchy is a option set
Team.poste_portfoliotype too

Sorry, your
'poste_portfoliohierarchy(Team)'.'3' in Team.poste_portfoliohierarchy.Team
not working

Can i verify anithing for you?

Was this reply helpful? Yes No
v-siky-msft on at

Like (0)

Report
@BlackRos
Are 3 and 0 an option in the options set?
What is the option set name? (Option set name could be different from the Option set field name)
Could you share the more about the OptionSet field as follows?

What I can tell you is the syntax:

'option set name'.'3' in EntityName.'option set field name'

Sik

Was this reply helpful? Yes No