web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How to filter combobox

Power Apps

Answered

How to filter combobox

(0) Share

Report

Report

Posted on by Andrew73

8

Hi,

I'm trying to filter a combox containing the lookup filed hierarchically referencing the same table.

The idea is to assign a boss to an employee on the "Employee_Edit" form. I've created a many- to-one relationship "Employee-Employee" with a "boss" lookup field. Created Yes , No field - IS Boss filed in Employee table.

Added boss field a combobox to an employee form and now that trying to filter out the added combobox with the values of the records with IS Boss = Yes

Thanks

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Andrew88 ,

Would you like to populate the boss Combo box with items in the Employees table that "Is Boss" field value is Yes?

If so, please try and apply below formula in Items of the Combo box:
Filter(Employees,'IS Boss' = 'IS Boss (Employees)'.Yes)

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Join the conversation