I am using NWC. I have a start event variable that is showing as an integer (it is a People Picker field). The Nintex designer and Sharepoint List has this field has a ‘People Picker’ AND has both ‘Users’ and ‘Allow selection of: People and Groups’. Show field is set: Name (with presence). I did try changing this to ‘Work email’.
My question is (I hope above is enough information), I want to be able to pull the email address for a single user or a group so the workflow can send an email. What would be a way (or ways) to get this accomplished?
P.S. I don’t seem to have this trouble if I only use the ‘Allow selection of: People Only’
Any help would be greatly appreciated.
Thanks, Lois
Page 1 / 1
Hi @millerlo
Would you be able to find the field on the sharepoint list and screenshot its configuration?
then if possible check the variable in the workflow to again screenshotting its type?
also if you are using a Nintex form on the sharepoint list can you locate the control and share its properties
I know that lookup fields are returned into the workflow as integers, it’s possible that on the people picker field on sharepoint that it isn’t connected to a people field, instead it’s being stored as a lookup, this might not be the case but I’d like to eliminate it.
Jake
Thanks for the quick response. I am attaching a file for your review. Also, I wanted to mention that when this was originally created we were using the Nintex ‘Classic’ workflow, and I was selecting the column for emails with no issues, screenshot below:
In the new NWC, when I test the workflow, the Item Preview, actually shows the email address, displayname, and ID from the column, but there is no variable with the email address or displayname.
Hi @millerlo
In the screenshots you provided it appears you are using the Contact_name (ID), near this in the retrieved fields there should also be Contact_name (Email)
See below my examples for Assigned and Owners:
When using both variables in the workflow;
you get the following for single value:
and multiple value:
Please check to see this Email field is there, if it is not that means that it is not being included in the API start event, this typically means that you have hit the API limit of the type of fields, this could be people or lookup fields on that list.
Normally this is fairly simple to solve by adding an additional retrieve and item action at the beginning of the workflow to get the starting item again as this allows us to request all fields.
Jake
Here is the start variable:
Here is a sample shot of workflow:
From the Retrieve an item:
I don’t have email option anywhere to select it.
Thanks, Lois
I forgot to mention that I also added a ‘fake’ text field in the designer and set the following rule. When I try it in “Preview” mode, it does not add the email address as I was hoping for.
