Moving Contact Information from SharePoint to Smartsheet

Hannibopeep

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

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å

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