If condition on the items property of Combo Box

[cyberco01]

This code is present on the Items property of the Combo Box in PowerApps form.

However, the expected data is not present in the Combo Box.

Please advise.

If(
User().Email="abc@xyz.com",
Filter(VW_ANC_WorkerPositionRate, REVPROJID=ComboBox1.Selected.PROJECTID),
Filter(VW_ANC_WorkerPositionRate, REVPROJID<>"HO_PLANT")
)

[Anonymous]

try this 

Filter(VW_ANC_WorkerPositionRate, REVPROJID=ComboBox1.Selected.Value),
Filter(VW_ANC_WorkerPositionRate, REVPROJID<>"HO_PLANT")
)

or this 

Filter(VW_ANC_WorkerPositionRate, REVPROJID=ComboBox1.Selected.Result),
Filter(VW_ANC_WorkerPositionRate, REVPROJID<>"HO_PLANT")
)

[cyberco01]

what about the if condition.

[Anonymous]

try this 

If(
User().Email="abc@xyz.com",

Filter(VW_ANC_WorkerPositionRate, REVPROJID=ComboBox1.Selected.Value),
Filter(VW_ANC_WorkerPositionRate, REVPROJID<>"HO_PLANT")
)

or this 

If(
User().Email="abc@xyz.com",

Filter(VW_ANC_WorkerPositionRate, REVPROJID=ComboBox1.Selected.Result),
Filter(VW_ANC_WorkerPositionRate, REVPROJID<>"HO_PLANT")
)

[v-qiaqi-msft]

Hi @cyberco01,

Have you solved your problem?

Do you want to populate a Combo Box based on current user?

If the REVPROJID is a Text column and you set the ComboBox1 with this column directly, I think your formula is correct which works on my side.

Could you please try this formula one more time and see if there is something error occuring?

[cyberco01]

@v-qiaqi-msft , records are coming in my combo-box using my formula but not all the records. That's the issue.

[v-qiaqi-msft]

Hi @cyberco01,

Okay, that's delegation issue.

Go to the Settings>General>Data row limit, change it into the 2000 if you have 500 there.

 Or if you have already set 2000 for the limit, I am afraid the "<>" cause the delegation issue. Currently, it is nondelagable if you have more than 2000 records and filter them using a "<>".

[cyberco01]

@v-qiaqi-msft , yes i have already set it to 2000. hence all the records are not coming. any other alternative for this.

[v-qiaqi-msft]

Hi @cyberco01,

Sorry, there is no alternative for this.