Answered

PowerApps issue, auto populate manager name

(0) Share

Report

Posted on by Gti182

Hi All,

I'm trying to auto populate Column C with Manager name based on Column B Salesperson*. I was trying to replicate exactly this https://www.youtube.com/watch?v=yuIxzObDa28

Now when i test it in power apps by inserting a salesperson it doesn't auto populate manager field but it does find the manager when i click on the drop down arrow.

What am i missing that will make it auto populate?

To add:

Very new to SharePoint lists and started playing around with PowerApps literally today so still trying to figure out a lot of things.

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report
Hi @Gti182 , The code need to be added on the Default property of DataCard.
Office365Users.ManagerV2(DateCardValue2.Selected.Email).DisplayName
You have added to Items property of Combo box.
-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

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.👍

Thanks,
ANB

Was this reply helpful? Yes No
Gti182 38 on at

Like (0)

Report

Thanks ANB that makes sense, I've created a new list from scratch and a new powerapp and now i'm getting a formula error

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Gti182 , EDITED: Apologies, it was my mistake. Can you confirm the error message?

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

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.👍

Thanks,
ANB

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Gti182 , I have edited my response. Can you check please.

Thanks,
ANB

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

HI @Gti182 , Watched the video again and in that video that person is using single line text column for Manager and Manager Email. In your case you are using Combo box and that is reason you are getting the error message.

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

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.👍

Thanks,
ANB

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report
Hi @Gti182 , I did a test for you. If you want the manager as Person or group column type with combo box in UI, then this code will help you. You need to add below code on DefaultSelectedItems property:
If( !IsBlank(DataCardValue2.Selected.Email), Office365Users.Manager(First(Office365Users.SearchUser({searchTerm: DataCardValue2.Selected.Email})).Id) )
-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

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.👍

Thanks,
ANB

Was this reply helpful? Yes No
Gti182 38 on at

Like (0)

Report

Thanks for the help ANB, I managed to replicate your solution above and got it to work in powerapps amazing

The issue I have now is this doesn't seem to carry over to the Sharepoint list as expected.
1) Should this work with grid view?
2) When seller is inserted in the input form populates manager field correctly but doesn't stick when I save and exit 🤔

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report
Hi @Gti182 , Please add below code on Items property of manager combo box:

Office365Users.SearchUser({searchTerm:Self.SearchText})

Add below code on the Manager_DataCard1 data card update property:

{ Claims: "i:0#.f|membership|" & DataCardValue3.Selected.Mail, Email: DataCardValue3.Selected.Mail, DisplayName: DataCardValue3.Selected.DisplayName, Department: "", JobTitle: "", Picture: "" }

EDITED:
And on the OnSuccess, add Refresh(SPLISTNAME)

Then Save and publish the form. Refresh the SharePoint list and try again. It worked for me.
-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

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.👍

Thanks,
ANB

Was this reply helpful? Yes No
Gti182 38 on at

Like (0)

Report

Thanks ANB,

Now the manager is populating in the list view only and not the seller 😞 (both appear fine in the input form) - wondering if i should give up on this idea and try a different approach 🤔

Was this reply helpful? Yes No
Verified answer

ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Gti182 , For me it is working fine. Have you checked that I have update my previous response for the OnSuccess property of form. Make sure to Save and Publish the form. Clear the cache of your browser and try again.

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

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.👍

Thanks,
ANB

Was this reply helpful? Yes No