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
giampaulo
Helper III
Helper III

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.

giampaulo
Helper III
Helper III

 

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.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (2,171)