Unanswered

Combo box Filter plus look up?

(0) Share

Report

Posted on by CU30071822-0

Hello !!

I am trying to figure out how to accomplish the following.

I have a project combo box that its source table (EmptoProject) is being filtered by the user email. This filter is so that the user can only see and select projects that are assigned to him. But i also have a Project (Project_T) table that is related to the (EmptoProject) table. I want to filter the same way I'm doing now but i also want the combo box to check if a specific project (in the Project_T) is closed (There is a Is active column with Yes or No Boolean) if it is then do not display that project for any users that has that project assigned to them.

Below are some images.

EmptoProj_T (Table)

Project_T (Table)

Any help is appreciated!!!!

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
Hi @jubae22 ,

To Filter a Yes/No field type from a related Dataverse table, you can use:

Filter( EmptoProject, Email = User().Email, 'Your Related Column'.IsActive )

The assumption above is that there is a One to Many relationship between the Project_t table (one) to the Employee to project table (many).

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No
CU30071822-0 on at

Like (0)

Report

Thank you for your reply Amik. Yes i do have a one to many relation between Project_T (One) and EmptoProj_T(Many)

I tried this but getting an error message.

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

@jubae22 - check my expression again, you first need enter the Lookup column in the EmptoProj_T.

This is the column which establishes relationship with the Project_t table. After selecting the Lookup column, press the full stop/period key, which will automatically display a list of columns in the Project_t table.

------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Was this reply helpful? Yes No