Moving Contact Information from SharePoint to Smartsheet

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?

Find more posts tagged with

Education

Integrations

IT & Operations

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

DocuSign integration suddenly not working with contacts that display the name instead of email.
I've had a DocuSign integration working for a while now. Today, I go to use it and it doesn't work because it sees invalided characters. Upon researching, I have discovered that if the contact field displays the person's email instead of their name the integration works. So it's like DocuSign used to be able to use the…
Checking provisional members on Smartsheet for USM model
Hi smartsheet community! I wanted to check if there is any way by which we can check who all are provisional members in our existing user list. Kindly note that we have not ye to move to User Subscription Model. Thank you for your response!
Onedrive & DocuSign Integration Capabilities
I am in the process of designing our Smartsheets workflow and am trying to better understand the capabilities / limitations of these integrations. Current Process: 1) We receive a PDF (say an invoice). 2)Manually save the file in Onedrive updating the file name. 3) Manually enter the data from the PDF into a SS Form and…