Moving Contact Information from SharePoint to Smartsheet

Hannibopeep · 12/17/18

I'm trying to setup a Microsoft Flow to move data from a SharePoint list to a Smartsheet. The problem I'm running into is that the Contact column type in Smartsheet won't accept the "Person" column type data from SharePoint. I continue to get this error:

Value is not supported for this column type. Use objectValue instead.

"errorCode": 1235,

"message": "Value is not supported for this column type. Use objectValue instead.",

"refId": "19xodyhphnofg",

"detail": {

"index": 0

There are no additional options in Flow that I can see to use. Can anyone help me figure out what combo of data I need for Smartsheet to accept the contact information of the person selected in SharePoint?

sean59916 · 12/18/18

Hi -

I think you might be out of luck on that - contact columns do not support formulas. What is the person type field, what information does it contain? An email address?

Sean

Andrée Starå · 08/13/19

Hi Hanni,

This might help!

Formulas in contact columns. It's released now!

https://community.smartsheet.com/announcement/announcing-formula-support-contact-columns

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Moving Contact Information from SharePoint to Smartsheet

Comments

Categories