Unanswered

Combo box restrict items available per User().FullName (Employee Name) in table

(0) Share

Report

Posted on by CU30071822-0

Good Morning,

I have two combo boxes 1. Element 2. Project.

I currently have the project filtered by the element that is selected i.e. each project has an element assigned to it but i also want to filter the project list by the user i.e. JULIO should only see the projects assigned to him. I think i need two filters but not sure how to achieve that.

EmployeetoProject_T - Source table

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Ethan_009 4,838 Moderator on at

Like (0)

Report
Re: Combo box restrict items available per User().FullName (Employee Name) in table

Hi @jubae22 ,

As much as I got your requirement, I guess this should work:
//For Element combobox items property Filter( EmployeetoProject_T, 'Employee Name' = User().FullName ).'Element Name' //For Project combobox items property Filter( EmployeetoProject_T, 'Employee Name' = User().FullName && (IsEmpty(CBProject.SelectedItems) || IsBlank(CBProject.Selected.Value) || CBProject.SelectedItems in 'Element Name') ).'Project Name'

Hope this helps

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

Like (0)

Report

Re: Combo box restrict items available per User().FullName (Employee Name) in table

Ethan_R appreciate your response. The element combo box worked great. I got errors messages for the project combo box. Please see below.

Was this reply helpful? Yes No
Ethan_009 4,838 Moderator on at

Like (0)

Report

Re: Combo box restrict items available per User().FullName (Employee Name) in table

Hi @jubae22 ,

If Value isn't present, you can either remove the ".Value" or add any column after that so if you add dot operator "." then you will see list of columns by suggestion from the App itself

Hope that helps

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

Like (0)

Report

Re: Combo box restrict items available per User().FullName (Employee Name) in table

Thank you Ethan_R but not able to fix the errors.

Was this reply helpful? Yes No