Skip to main content

Notifications

Community site session details

Community site session details

Session Id : 3TkF1UBnb+7J79QmNtbRrg
Power Automate - Building Flows
Answered

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

Like (0) ShareShare
ReportReport
Posted on 29 Nov 2022 08:03:24 by 13

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:

Geaven_0-1669708849008.png

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!

  • Ellis Karim Profile Picture
    10,927 Super User 2025 Season 1 on 01 Dec 2022 at 08:22:08
    Re: Incompatible type kinds were found. The type 'SP.FieldUrlValue' was found to be of kind 'Complex' instead of the expected kind 'Entity'.

    Excellent!

  • Verified answer
    Geaven Profile Picture
    13 on 01 Dec 2022 at 08:20:19
    Re: Incompatible type kinds were found. The type 'SP.FieldUrlValue' was found to be of kind 'Complex' instead of the expected kind 'Entity'.

    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!

  • Ellis Karim Profile Picture
    10,927 Super User 2025 Season 1 on 01 Dec 2022 at 08:15:27
    Re: Incompatible type kinds were found. The type 'SP.FieldUrlValue' was found to be of kind 'Complex' instead of the expected kind 'Entity'.

    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:

     

    Snag_246c852.png

    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.

  • Geaven Profile Picture
    13 on 01 Dec 2022 at 02:36:20
    Re: Incompatible type kinds were found. The type 'SP.FieldUrlValue' was found to be of kind 'Complex' instead of the expected kind 'Entity'.

    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.

  • Ellis Karim Profile Picture
    10,927 Super User 2025 Season 1 on 30 Nov 2022 at 09:23:43
    Re: Incompatible type kinds were found. The type 'SP.FieldUrlValue' was found to be of kind 'Complex' instead of the expected kind 'Entity'.

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

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

     

    Ellis

  • Geaven Profile Picture
    13 on 30 Nov 2022 at 09:11:13
    Re: Incompatible type kinds were found. The type 'SP.FieldUrlValue' was found to be of kind 'Complex' instead of the expected kind 'Entity'.

    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

  • Ellis Karim Profile Picture
    10,927 Super User 2025 Season 1 on 30 Nov 2022 at 09:02:58
    Re: Incompatible type kinds were found. The type 'SP.FieldUrlValue' was found to be of kind 'Complex' instead of the expected kind 'Entity'.

    Hi @Geaven 

     

    Please check the body of the HTTP request. I noticed an unexpected Folder property:

     

    ekarim2020_0-1669798636175.png

    Here is a screenshot of my runtime output:

    ekarim2020_2-1669798877630.png

     

    ekarim2020_1-1669798764838.png

     

    Snag_3d7107c6.png


    Ellis
    ____________________________________
    If I have answered your question, please mark the post as Solved.
    If you like my response, please give it a Thumbs Up.

     

  • Geaven Profile Picture
    13 on 30 Nov 2022 at 06:49:25
    Re: Incompatible type kinds were found. The type 'SP.FieldUrlValue' was found to be of kind 'Complex' instead of the expected kind 'Entity'.

    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:

    Geaven_0-1669788163196.png

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

  • Ellis Karim Profile Picture
    10,927 Super User 2025 Season 1 on 29 Nov 2022 at 10:00:03
    Re: Incompatible type kinds were found. The type 'SP.FieldUrlValue' was found to be of kind 'Complex' instead of the expected kind 'Entity'.

    Hi @Geaven ,

     

    Try the following Uri and Body format:

    ekarim2020_0-1669715845031.png

    Snag_34d85bc.png

     

    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.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,731 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,075 Most Valuable Professional

Leaderboard
Loading started