I'm trying to show the Manager Name (PrefferedName) on a New Responsive form. I'm able to get the LoginID using:
userProfileLookup([Form].[Employee],"Manager") -- Note "Employee" is a people picker form field.
This returns a value like this: i:firstname.lastname@example.org
I then tried to pump that into another user profile lookup:
userProfileLookup([Form].[ManagerLoginID],"PreferredName") -- Note "ManagerLoginID" is the variable capture from above.
But that returns no result on the preview, or the published form. Is there anyway to get to the Manager PreferredName (or any other property, like email) using variables?
I apprecaite you taking the time to reply. A couple of notes (remember that the manager property returns this format: i:email@example.com):
Given number 3, it seems more like a bug.
Euan's video sorted me out. There are some quirks when using variables that were messing me up.
As I wrote on a comment on that video: " Using the "context" of current user works for your variable example, but not the "context" of a people picker. I'm guessing variables don't update dynamically, only on load."
Also, the variable example in my number 2 above works in published form, but not in preview. My appologies for claiming it didn't work.
Hopefully this thread will help others in the future. Step 1: WATCH EUAN'S VIDEO!