Answered

Incompatible type kinds were found. The type 'SP.FieldUrlValue' was found to be of kind 'Complex' instead of the expected kind 'Entity'.

(0) Share

Report

Posted on by Geaven

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!

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (1)

Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (0)

Report
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.

Was this reply helpful? Yes No
Geaven 13 on at

Like (0)

Report

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."}}}

Was this reply helpful? Yes No
Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Geaven 13 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (0)

Report
If the URL field is called Folder, I think the body should be:

Body: { "formValues": [ { "FieldName": "Folder", "FieldValue": "https://www.google.co.uk" } ] }

Ellis

Was this reply helpful? Yes No
Geaven 13 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

Geaven 13 on at

Like (0)

Report

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!

Was this reply helpful? Yes No
Ellis Karim 11,691 Super User 2025 Season 2 on at

Like (0)

Report

Excellent!

Was this reply helpful? Yes No