Skip to main content
Nintex Community Menu Bar
Solved

SharePoint Online - Create an item - person column can't set a value


Gavin-Adams
Forum|alt.badge.img+13

I'm having problems in NWC with the SharePoint online - create an item action when I try to set a value for a person column.

I've created a NWC form with anonymous access. The scenario is an org with lots of casual and contract staff who do not have corporate user accounts, they will select a managers email from a data lookup control.

I have a data connection to Azure Active Directory as the source for a 'Manager' data lookup control on the form.

This return the email address for the user from Azure AD.

 

I added a SharePoint Online create an item action.

This is configured against a list in a SharePoint online site.

This list has a person type column called manager.

 

When I try to insert a value against the person field all the start event options are greyed out.

 

Next step I thought was to add an action 'SharePoint Online - Query User Profile'. This takes the email from the form and will put the user details into an object variable.

 

However when I go back to the create an item and select the new 'ManagerObject' there are no fields that are suitable to insert.

 

https://help.nintex.com/en-US/nwc/Content/Designer/Actions/SharePointOnline-CreateanItem.htm

Looking at the help file it shows integer type for person field.

So I'm guessing that is the ID of the person from the hidden user list in SharePoint site collection root. I cant find anyway to get to that integer though.

 

Any thoughts on how to take a validated user email/UPN from a Azure AD data source and put it into a SharePoint list person field?

 

Thanks

Gavin

 

Best answer by leighburke

@Gavin-Adams Currently the person field is looking for an ID, so if that user is already exists in a person column on a list, then you could query that list and get the ID.


 


The other option would be putting it into a text field and then using an update item action inside of o365 to set the person field. I have also raised this internally for you.

View original
Did this topic help you find an answer to your question?

5 replies

Forum|alt.badge.img+14
  • Nintex Employee
  • 503 replies
  • Answer
  • October 8, 2020

@Gavin-Adams Currently the person field is looking for an ID, so if that user is already exists in a person column on a list, then you could query that list and get the ID.


 


The other option would be putting it into a text field and then using an update item action inside of o365 to set the person field. I have also raised this internally for you.


Gavin-Adams
Forum|alt.badge.img+13
  • Author
  • Explorer
  • 182 replies
  • October 8, 2020

Thanks @leighburke 


I've gone with option B and have a 'manager email' text column populated with the NWC workflow.


I've then used an 'update list item' action in a Office 365 workflow to set the person column.


 


Cheers,


Gavin


rickdemarco
Nintex Employee
Forum|alt.badge.img+8
  • Nintex Employee
  • 66 replies
  • October 9, 2020

@Gavin-Adams We are just planning an update to the relevant actions to support updating person columns using an email address and will also support multiple users if configured on the list. This shouldn't be to far away so keep an eye out in the release notes and will aim to also update this topic.. 


Gavin-Adams
Forum|alt.badge.img+13
  • Author
  • Explorer
  • 182 replies
  • October 9, 2020
Thanks Rick
Great to hear

rickdemarco
Nintex Employee
Forum|alt.badge.img+8
  • Nintex Employee
  • 66 replies
  • November 13, 2020
If the column is configured for multi values both display name and email address will now work, single values should be coming in the next release but keep eye on release notes.

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings