I have gone through many references for this request however somehow the solutions are not working in my case.
I am trying to get the managers display name from a different people field as per below snap. But getting error.
I tried different combinations however any of it is not working. Below are some of them.
Referred the YouTube Link: https://www.youtube.com/watch?v=yuIxzObDa28
Can anyone please help how to do that?
Solved! Go to Solution.
So the formula still should be:
However, if there is nothing selected, you will get an error on that formula. However...it should still work if you have a value user selected in the DataCardValue1 control.
You could alter the formula to this to try and remove the error
If(!IsBlank(DataCardValue1.Selected.Email), Office365Users.ManagerV2(DataCardValue1.Selected.Email).displayName, "" )
You are missing a closing ')'
Thanks for the help.
Tried that as well but still getting the error. Below the GIF for your reference.
Can you please help?
Please consider changing your formula to the following:
You were using the MyProfile function and trying to pass an email. MyProfile is specific to the current person. If you want the profile from another user you should use the UserProfileV2.
However, in the formula, you don't even need that, just pass the email of the person you want to the ManagerV2 function and it will get the appropriate manager.
I hope this is helpful for you.
I tried your suggestion but still it is showing a red line and not accepting as formula. Below the GIF for your reference.
I also tried to add UserProfileV2 with different combinations but still it not working. Below the GIF for that testing.
Could you please help?
So the issue is with the DataCardValue1 control.
What is the Items property of the DataCardValue1 control?
Ah...yes, that is not going to work. Your selection will not have an email address in it. You are going to need a valid email address in your dropdown.
Which column in your list actually has email addresses in it?
Hi @RandyHayes ,
It is a People Column in SharePoint. Actually i don't have any column where Email address is there. What should be the workaround for the same please?
But you have Choices([@PhoneList].ID)
ID is an ID column in SharePoint, it is not a People column.
What is the name of the People Column in SharePoint?
Check out the on demand sessions that are available now!
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
Features releasing from October 2020 through March 2021
Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!