Unanswered

Moving Contact Information from SharePoint to Smartsheet

(0) Share

Report

Posted on by 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?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

v-yuazh-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @Hannibopeep,

Could you please share a screenshot of the configuration of your flow?

Could you please share a screenshot of the flow run history when the flow run failed?

Please share more details so we would try to provide a proper workaround for you.

Best regards,

Alice

Was this reply helpful? Yes No
Hannibopeep 4 on at

Like (0)

Report
Copy link

Link copied!

I removed the site address from the screenshot for security sake.

Was this reply helpful? Yes No
aashcraft 13 on at

Like (0)

Report
Copy link

Link copied!

Was this issue ever resolved? I am having the same issue with a requester field that matches in both the form and smartsheet.

Was this reply helpful? Yes No
Hannibopeep 4 on at

Like (0)

Report
Copy link

Link copied!

Not that I'm aware of, no. However, Smartsheet has launched a lot of additional functionality lately so it maybe they have a solution?

Was this reply helpful? Yes No