Not able to upload items on Sharepoint List

1

Hi team,

I am trying to load items from an excel sheet to Sharepoint list but getting the below error. The fields/columns i have double checked on Sharepoint are editable.

Error:

Error: Invalid data has been used to update the list item. The field you are trying to update may be read only.
Source: action “Export to SharePoint list”, table “Imported table 1”

image
image766×679 21.4 KB

2

On further testing - its not allowing values to be updated for the people picker column.

I have tried - vaibhav.tandon@abc.com
I have tried - tandon, vaibhav but both the valid values are not getting uploaded.

What should be the email / name format?

3

What EasyMorph version are you using? Writing to people picker columns is not supported now, but we’re considering to implement this functionality in the foreseeable future

4

Hi,

Its 5.0.0.20.

Is there any workaround available?

5

Currently there is none

6

Hi All - Bumping this one.

I think it needs to be classified as a different data type. In Power Automate it looks this. I'm trying to work around it currently

{
"type": "OpenApiConnection",
"inputs": {
"parameters": {
"dataset": "https://DOMAIN.sharepoint.com/sites/SHAREPOINTLIST",
"table": "07127eff-7fa4-4d49-8890-1e2271028812",
"id": 1147,
"item/IT_x002f_Initiative": "SY 2024 Pricing Changes",
"item/Contact_x003a__x0020_EXECUTIVE_x/Claims": "FirstName Last Name"
},
"host": {
"apiId": "/providers/Microsoft.PowerApps/apis/shared_sharepointonline",
"connection": "shared_sharepointonline",
"operationId": "PatchItem"
}
},
"runAfter": {}
}

7

Hi @adambeltz

In your example, what is the column type of "Contact_x003a__x0020_EXECUTIVE_x/Claims"?