But the columns on the left are not populating. How do I get them to populate?

The fields will be sent via an email notification (workflow) to an external entity. I need to have the values recorded in the list so the workflow will work (and presumably flow!)

I'd love to remove the calculated fields, but how do I get the values to populate in the list fields?

I tried that initially but it puts some horrendous guid in the field.

I'll keep experimenting and will pull screenshots if I can't get it. Thanks so much for your help, @SimonMuntz 

This is what the form returns when the default value of the form field is the calculation. I have removed all of the calculated fields.

Here is the field configuration.

The calculated fields are working, yes, but I must have the values inserted into the list, because they are absolutely necessary for the email that is sent with that information. Does that make sense? What am I missing?

So, the question that remains is; how do I populate the list with calculated values?

@MikeCrawford It seems you need Name, Email, Phone & Title field and you're using user profile lookup function in calculated control. 

All you need to do is remove SLT controls and just keep Calculated Controls. Make sure in Connected To option in Calculated control they are connected to a respective SharePoint list columns.

I appreciate that, @kunalpatel, but I would much prefer to have the fields populated as a default in case the user needs to update a phone number. It may not surprise you that our AD information is often spectacularly out of date, particularly with people working from home. How do I get the calculated values into the form fields?

I have opened a support ticket with Nintex and will post results here when (if!) we have a resolution. Thanks, everyone who has helped thus far!

@MikeCrawford can you try the below steps:

1. Add SLT control on the form but do not connect it to any list columns


2. Name that SLT control e.g. slt_EmpPhNo


3. Add calculate control and connect it to SP list column


4. Name it calc_EmpPhNo


5. Now instead of using just the user profile lookup function, use the If statement i.e. If slt_EmpPhNo is null or blank then in the true portion use user profile lookup, and in the false portion use slt_EmpPhNo

As an enhancement, I will not keep SLT control and calc control side by side, instead I'll add a check box below calc control asking to check if the phone # is incorrect and if they check then it will display the SLT control.

Absolutely brilliant, @kunalpatel - this is exactly what I need.

Step 5 calculated value looks like this: If(isNullOrEmpty(EmployeeName),UserProfileLookup(User,"PreferredName"),EmployeeName)

Additionally, the checkbox is a great addition for a robust form when fields might need to be manually overridden.

Thank you!