You’re offline. This is a read only version of the page.
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!!!!
@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.
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.
Hi @jubae22 ,
To Filter a Yes/No field type from a related Dataverse table, you can use:
Share
Report
All responses (
Answers (
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.
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
