Send an HTTP request to SharePoint - adding description to a SharePoint URL column entry

[Barncliff]

I've a SharePoint list which has a URL column, which I'm populating via a flow.

That results in a long URL in my list, so I simply wanted to update the list entry with a URL and a description e.g. 'URLlink'.

So I've realised that I need to use 'Send an HTTP request to SharePoint' 🤔

I'm new to Power Automate, so have tried to copy solutions I've found.

Despite trying various different methods, I'm now stuck.

The request ETag value '' does not match the object's ETag value '"

[ScottShearer]

@Barncliff 

All the examples that I see use a POST method rather than a PUT - don't know if that's your issue...

This example approach it a little differently than your example (headers, etc.)

Example

I just ran a test where I followed the example in the link above EXACTLY and it worked first time.  It took about 5 minutes.

My list name is FormsData and my column name is HL.  You should not be entering anything in the Tracked Properties area.

[Barncliff · Accepted solution]

Thanks for the pointers Scott. I've arrived at your solution. 

Well, after a lot of trial and error I've got it to work 😀

I found it useful to look at the SP List via Chrome to see what SharePoint was using, as I'd removed spaces part-way in case that was the problem.

<SiteUrl>/_api/web/lists/GetByTitle('List Name')/

<SiteUrl>/_api/web/lists/GetByTitle('List Name')/Fields

Also used a JSON validator to check my code in the body section, as I've tried many different variants.

No idea why I don't see the Header boxes, but copied someone who had entered values direct in the Header box.

Anyway, the result is a compact URL link in my list.