cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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

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.

Capture2.JPGCapture.JPG

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Frequent Visitor

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

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.

 

Capture3.JPG

View solution in original post

2 REPLIES 2
Highlighted
Super User III
Super User III

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

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

HL.jpg

 

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

Scott
Highlighted
Frequent Visitor

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

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.

 

Capture3.JPG

View solution in original post

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (8,264)