web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filter with Yes/No col...

Power Apps

Unanswered

Filter with Yes/No column in dataverse

(0) Share

Report

Report

Posted on by BestJust

48

Hello,

I have a question about a filter.
I have two databases in Dataverse.
- employees
- projects
I only want to display the data from the employee database that matches the selected dropdown menu xyz and is marked as Active with Yes in the project database. The column in the project database is a Yes/No column.

So it would be something like this, but unfortunately it doesn't work:
Filter(Employee, Name=Dropdown1.Selected.Name) && Filter(Project, Active = Active.Yes)

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

Sundeep_Malik 6,501 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @BestJust

You should be using a lookup function here.

The filter function should look like below:

Filter(
Employee,
Name = Dropdown1.Selected.Name &&
Lookup(
Project,
Name = Dropdown1.Selected.Name,
Active.Yes
)
)

Replace the Name in Project Lookup with your respective column.

Your expression wont look exactly same, you will have to do some modifications.

I hope this helps 🙂

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

Like
a
(0)

Report
Copy link

Link copied!
Hi @BestJust，

Do you mean that both Employee and Project table shares a same Name column?

If there is also a Name column existing in Project table, please modify your formula as below:

Filter(Employee, Name=Dropdown1.Selected.Name&& Name in Filter(Project, Active = Active.Yes).Name)

Was this reply helpful? Yes No

Join the conversation