Answered

undefined

(0) Share

Report

Posted on by Community Power Pla...

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

I have the same question (0)

All responses (10)

Answers (2)

365-Assist 2,324 Moderator on at

Like (0)

Report

You can set the current user as a variable in the App-> OnStart.
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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report
@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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report
@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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report

@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 ?

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

So I made this change

Was this reply helpful? Yes No
WarrenBelz 153,073 Most Valuable Professional on at

Like (0)

Report
@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

Was this reply helpful? Yes No