Hi all
I'm trying to use a Power Automate flow to send a HTTP POST request to update the URL column in my Sharepoint list but I'm coming across this error.
Here is the HTTP request:
The error I'm getting is as in the subject, i.e Incompatible type kinds were found. The type 'SP.FieldUrlValue' was found to be of kind 'Complex' instead of the expected kind 'Entity'. I've checked my list column type and it is set to Hyperlink or Image so I'm confused.
Any help would be much appreciated!
Excellent!
Hi Ellis
Thanks for your help but I have worked it out now. I'm back to using the metadata method and figured out the issue was because Folder is a system/reserved name in Sharepoint so after I changed the column name it worked perfectly!
The body code posted earlier updates my SharePoint List called Client List. The HTTP action updates a column called Website that is of type Hyperlink to the value "https://www.google.co.uk". As I understand, you are trying to do the same to column named "Folder".
Please try the body code exactly as posted previously, then post the results:
If it still fails to work, please post the content of the HTTP Action including screenshots of the SharePoint list, and sample data.
Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
Hi Ellis
I think I probably wasn't clear with the problem - I'm trying to get the list to update the URL when a new item is created in the list, it's not actually through a form.
If the URL field is called Folder, I think the body should be:
Body:
{
"formValues": [
{
"FieldName": "Folder",
"FieldValue": "https://www.google.co.uk"
}
]
}
Ellis
Hi Ellis
The Hyperlink field I have is named Folder, don't I have to include that somewhere as it is not on a form?
Thanks
Hi @Geaven
Please check the body of the HTTP request. I noticed an unexpected Folder property:
Here is a screenshot of my runtime output:
Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
Hi @ekarim2020
Thank you for your reply.
I tried that and it gave me the error: Not well formatted JSON stream.
Here's the output result:
I then googled the error and saw that I need these headers:
"Content-Type": "application/json;odata=nometadata",
"Accept": "application/json;odata=nometadata"
So I have put them in but now the error is {"odata.error":{"code":"-1, Microsoft.SharePoint.Client.InvalidClientQueryException","message":{"lang":"en-US","value":"Not well formatted JSON stream."}}}
Hi @Geaven ,
Try the following Uri and Body format:
Uri:
_api/web/lists/GetByTitle('Deals')/items(33)/validateUpdateListItem
Body:
{
"formValues": [
{
"FieldName": "Website",
"FieldValue": "https://www.google.co.uk"
}
]
}
Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.
WarrenBelz
146,731
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,075
Most Valuable Professional