If condition on the items property of Combo Box

(0) Share

Report

Posted on by cyberco01

480

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

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
cyberco01 480 on at

Like (0)

Report
Copy link

Link copied!

what about the if condition.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
cyberco01 480 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
cyberco01 480 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @cyberco01,

Sorry, there is no alternative for this.

Was this reply helpful? Yes No