web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Combo box restrict ite...
Power Apps
Unanswered

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

(0) ShareShare
ReportReport
Posted on by

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. 

 

jubae22_1-1687364698843.png

 

 

EmployeetoProject_T - Source table 

 

jubae22_3-1687364938732.png

 

jubae22_2-1687364726286.png

Categories:
I have the same question (0)
  • Ethan_009 Profile Picture
    4,838 Moderator on at

    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

  • CU30071822-0 Profile Picture
    on at

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

     

    jubae22_0-1687369819231.png

     

    jubae22_1-1687369870974.png

    jubae22_2-1687369972262.png

    jubae22_3-1687370006142.png

     

     

     

     

     

     

     

  • Ethan_009 Profile Picture
    4,838 Moderator on at

    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

  • CU30071822-0 Profile Picture
    on at

    Thank you Ethan_R but not able to fix the errors. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 101 Most Valuable Professional

#2
Haque Profile Picture

Haque 81

#3
VASANTH KUMAR BALMADI Profile Picture

VASANTH KUMAR BALMADI 70

Last 30 days Overall leaderboard