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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / undefined
Power Apps
Answered

undefined

(0) ShareShare
ReportReport
Posted on by Community Power Pla... Microsoft Employee

Hello,

 

I m trying to create a cascading dropdown where seccond dropdown will show (items/dorwpdown option from data list) it based on currently logged in user.

Currently I have two list one is data list which has two column the manager (text field in sharepoint list) & employee (text field in Sharepoint list) 

Second list where all the data should go where manager field should be a auto poulated field and employee field should show only employees who are under that manager so basically a cascading dropdown

I need help with making that manager field Auto poulated by currently logged in user

please help 

Categories:
Building Power Apps
  • 365-Assist Profile Picture
    365-Assist 2,327 Moderator on at

    You can set the current user as a variable in the App-> OnStart.

    365Assist_0-1674171363414.png

    Then you can filter the dropdown where Manager equals the variable CurrentUser.FullName.

     

    ---------------------------------------------------
    Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

    Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
    Twitter: https://twitter.com/assist_365

    Regards
    Darren Lutchner - 365 Assist

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Thank you for your the idea but I am getting in the Manager dropdown False instead of manager name. and blank results for employee dropdown

  • WarrenBelz Profile Picture
    WarrenBelz 156,570 Most Valuable Professional on at

    @Anonymous ,

    As per the PM you sent - you did not say whether you had the employee's name or email - example below is name.

    With(
 {
 wManager:
 LookUp(
 SPList,
 Employee = User().FullName
 )
 },
 Filter(
 SPList,
 Manager = wManager
 )
)

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

    MVP (Business Applications)   Visit my blog Practical Power Apps

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    hello thank you for your response its manager name and here is what I have 

    this is what I have for manager name field which is a dropdown for now Distinct(OBOList,Managername)

    and this is a user/employee filed which is a dependent dropdown Distinct(Filter(OBOList, Managername = MngDrp.Selected.Result),Employeename) and this works fine I want to make sure that manager name is auto populated based to logged in user I hope this helps again thanky you so much 

     

  • WarrenBelz Profile Picture
    WarrenBelz 156,570 Most Valuable Professional on at

    @Anonymous ,

    The manager name would be

    LookUp(
 OBOList,
 EmployeeFieldName = User().FullName
).Managername

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

    MVP (Business Applications)   Visit my blog Practical Power Apps

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    thank you for the idea but its still not working I am getting red error 

  • Verified answer
    WarrenBelz Profile Picture
    WarrenBelz 156,570 Most Valuable Professional on at

    @Anonymous ,

    It must be your field references as the code structure is valid. What is the actual code you used and what is the error. Also what type of fields are ManagerName and your employee name field ?

  • Verified answer
    Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Manager and employee both are single line of text and here is the formula LookUp(
    OBOList,
    Employeename= User().FullName
    ).Managername

    I used this in managername textbox in canvas app 

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    So I made this change

  • WarrenBelz Profile Picture
    WarrenBelz 156,570 Most Valuable Professional on at

    @Anonymous ,

    You did not note the error message, but if both Managername and Employeename are both Single Line of Text fields in OBOList, then the code

    LookUp(
 OBOList,
 Employeename= User().FullName
).Managername

     as either the Default of a Text Box or the Text of a Label will display the Managername in first matching record in OBOList containing the current User's name in the Employeename field. 

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

    MVP (Business Applications)   Visit my blog Practical Power Apps

     

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 382 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 329

#3
WarrenBelz Profile Picture

WarrenBelz 187 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans