Skip to main content

Sorry for the apparent newbie question but I'm a .... newbie 

My form is basically a "request" form, using Responsive mode backed by a basic SharePoint Online custom list.

One of the fields in the list is the requester's Manager, with a type of People/Group.

On the form, I can obtain the manager using "userProfileLookup("Current User(email)", "Manager") but I just dont see how I can then push this into the SharePoint field.

If use a Calculated Field it does not allow me to "Connect to" the SharePoint field as it's not listed (incompatible types I guess)... but if I use a People field and set the Default value to a formula fn-UserProfileLookUp(Current User(email),"Manager") it shows an empty text box.

I'm sure it's something really simple but I just cant see it...

TYIA

Chris.

Hi,

The responsive form have advantages and disadvantages, I guess that the reason that you get blank textbox is that there is no operation "userProfileLookup" for "People" field so it's not recognize the action

But I can suggest workaround with you can use Nintex Workflow

You can add calculated value in the form that show Manager Display Name(so the user could see the manager)

When item created you can start WF that insert the initiator manager to any field you want including person field

I'm sure that must be better way than this...maybe other people could help

Regards,


Yeah ... I think that's going to be the only option...

On the plus side, I need a WF to fire "on create" anyway, so I'll just add this as an extra step..

But, as you say, I'm sure there must be an easier way to do this.


Yeah ... I think that's going to be the only option...

On the plus side, I need a WF to fire "on create" anyway, so I'll just add this as an extra step..

But, as you say, I'm sure there must be an easier way to do this.


The easier way would be to create a form variable . In Form variable you can have the formula for manager of current user and form variable can be connected to any field that you want . Connect it to people field that you want and voila ! when form is save you have the field populated.


 


Hope this helps! 


If you find this as a solution please mark it so.


I tried this, but it doesn't let you connect the variable to a people picker column. I have single line of text fields it lets me connect to, but not my choice or date fields either. So it definitely doesn't let you connect to any field. 


 


Any other recommended solution? I'd like to accomplish this on the form instead of having it wait until the workflow triggers.


 


Thanks for any help!


Reply