cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cyberco01
Post Prodigy
Post Prodigy

If condition on the items property of Combo Box

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")
)

8 REPLIES 8
Anonymous
Not applicable

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")
)

what about the if condition.

Anonymous
Not applicable

 

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
Community Support
Community Support

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?

Best Regards,
Qi

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

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.

vqiaqimsft_0-1642051928869.png

 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 "<>".

Best Regards,
Qi

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

Hi @cyberco01,

Sorry, there is no alternative for this.

Best Regards,
Qi

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,212)