For some reason, sometime in the past few months, the UserProfileLookup function in Nintex Forms for O365 has stopped working completely. I have noticed that lookup funcitons that used to return values in people fields stopped working too. This is extremely frustrating - I suddenly have functions that used to work in production forms failing all over the place because of this and I HAVE GOT TO get to the bottom of this as soon as humanly possible.
To reproduce UserProfileLookup issue: (1) create a SharePoint list that includes a people field. (2) Create a new responsive designer form for that list and display the people field. (3) create a variable that does a user profile lookup against that people field and display the value in a label.
To reproduce lookup issue: (1) create a second sharepoint list and add a few text fields, plus a people field. (2) Create a lookup field on list 1’s form that links to list 2. (3) Create a lookup variable that returns a field value from the lookup list and display the value in a label. Test with various data types form list 2. Text fields return, but people fields do not.
I really, really hope there’s a solution for this. If there isn’t the client will expect me to rebuild the entire solution on Power Platform and I’d rather rip out my nose hairs with a tweezer than do that.