web

You’re offline. This is a read only version of the page.

Power Platform CommunityForums Power Automate Writing to a SP List U...

Power Automate

Unanswered

Writing to a SP List URL Field - REST API

(0) Share

Report

Report

Posted on by EdwardHodson

94

I'm getting an error when trying to write to a SharePoint List URL field using REST API. Please see below:

{"__metadata": {
 type: "SP.Data.TESTINGTeamsSiteCreationListItem"
 },
 "TeamsLink": {
 "Url":"@{variables('URL')}",
 "Description": "MS Teams"
 }
}

Error:

All the documentation/guides I've seen seem to indicate that what I've done is correct, but I'm still hitting this issue.

Any help would be appreciated. Thank you

Categories:

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Verified answer

Expiscornovus 33,175 Most Valuable Professional on at

Like (0)

Report

Re: Writing to a SP List URL Field - REST API

Hi @EdwardHodson,

In your headers you specified that you won't be using metadata. However, in the body you included the metadata property.

Can you try and use application/json;odata=verbose in the accept and content-type headers instead. This way you don't have to change the body value

Was this reply helpful? Yes No
Expiscornovus 33,175 Most Valuable Professional on at

Like (1)

Report

Re: Writing to a SP List URL Field - REST API

Oh and it is worth checking if you used the correct type value in the json of the body. You can lookup this value via the listitementitytypefullname property.

I have written an article about this approach: https://www.expiscornovus.com/2021/07/10/listitementitytypefullname-within-power-automate/

Was this reply helpful? Yes No
EdwardHodson 94 on at

Like (0)

Report

Re: Writing to a SP List URL Field - REST API

HI @Expiscornovus - That's done it! Thanks for spotting my mistake. Also, thank you very much for the link to your article. I've added the "ListItemEntityTypeFullName" step in my flow.

Thank you!

Was this reply helpful? Yes No

Join the conversation