Unanswered

Filter problem with 2 databases and a No/Yes column

(0) Share

Report

Posted on by BestJust

Hello,
I have a question regarding a filter.
I have two databases:
- EmployeeinProject(Name, Project)
- Project(Project, Project active)
The column Project active is formatted as No/Yes column.
I would like to have a dropdown menu that shows all projects that match the name that was previously selected and only the projects that are active.
Unfortunately I can't manage that.

Does anyone have an idea? Thank you

Categories:

Building Power Apps

All responses (11)

Answers (0)

Sort by

swaminawale 195 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BestJust ,

Assuming that you have a PROJECTS list and in that you have Project name & Is Active column as you mentioned and you want to show only active projects in dropdown so what you can do is apply a filter on items property of dropdown

Filter('ProjectList', IsActive = true)
BestJust 48 on at

Like
a
(0)

Report
Copy link

Link copied!

Unfortunately that doesn't solve the problem. I would like to use a filter that uses the name from the other drop-down menu to get the projects from the first database and then checks whether the projects are active and only then displays them.
jorge.daniel 1,430 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi,

You don't mention the datasource, I will assume sharepoint.

Try this:

Filter( Project, Project= Dropdown1.Selected.Project && Active = true)
swaminawale 195 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @BestJust ,

You can try this:
Filter('Project', Project = Dropdown1.Selected.Project && 'Project active' = true)
BestJust 48 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your answers.
The databases are not Sharepoint lists but imported Excel tables in Dataverse.
Unfortunately, the filter is not much use to me because the name of the employee in the project and whether the project is active are in different databases.
Is there also a possibility for this?
jorge.daniel 1,430 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

When you say 2 databases, do you mean 2 dataverse tables?

For dataverse darabases, you need to change the way work with Yes/No fields

Filter( Project, Project = Dropdown1.Selected.Project && Active = 'Active(Project)'.Yes )
BestJust 48 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @jcfDaniel,
Thank you for your Answer.
Both datasources are dataverse tables not sharepoint tables.
But the Problem is that the project name and if the project is active are not in the same dataverse table.
BestJust 48 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes thats right. Both databases are dataverse tables not sharepoint tables.
When I use the filter you suggested, I get an error with the first active, because this name is not found in the Employee database because it is only in the Project database.
and again to my question I actually want to query this but it just doesn't work that way.
Filter(Employee, Name=Dropdown1.Selected.Name) && Filter(Project, Active = Active.Yes)
jorge.daniel 1,430 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

The Project column in Employee is a lookup to the Project table?
BestJust 48 on at

Like
a
(0)

Report
Copy link

Link copied!

I don't quite understand your question. What do you mean?