Skip to main content

Notifications

Power Automate - Building Flows
Unanswered

Updating a SP List HTML column fails when using Send an HTTP request to SharePoint

Posted on by 70

Updating a SP List HTML column fails when using Send an HTTP request to SharePoint. I'm following How To Update Hyperlink Fields With URL And Description Using Microsoft Flow (c-sharpcorner.com). I have a SP List with a URL column titled "Link". Let's say the list name is "Online User Account Request Form", note the spaces in the list name. 

tpcolson_3-1715377665536.png

 

 

However, I get this error

tpcolson_1-1715377572459.png

 

The objective is to insert a URL into the column titled "Link" after some other actions occur. The flow is working perfectly without this HTTP action....

  • ManishSolanki Profile Picture
    ManishSolanki 14,981 on at
    Re: Updating a SP List HTML column fails when using Send an HTTP request to SharePoint

    Hi @tpcolson 

     

    It looks like single quote is the issue (highlighted in red color). It seems you have copied this line from some web page & pasted directly in the action.:

    web/lists/GetByTitle(‘Online GIS User Account Request List’)/items(388)

     Pls remove those and readd those. 

     

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

  • tpcolson Profile Picture
    tpcolson 70 on at
    Re: Updating a SP List HTML column fails when using Send an HTTP request to SharePoint

    Still fails. 

     

     

    The expression "web/lists/GetByTitle(‘Online GIS User Account Request List’)/items(388)" is not valid.
    clientRequestId: fdc35adb-1e86-4631-90e9-fd0855b140ae
    serviceRequestId: e1b727a1-80f7-5000-84f5-124746ef076f

    tpcolson_1-1715459082830.png

     

     

  • ManishSolanki Profile Picture
    ManishSolanki 14,981 on at
    Re: Updating a SP List HTML column fails when using Send an HTTP request to SharePoint

    Hi @tpcolson 

     

    You can refer one of my solutions for updating hyperlink field:

    Solved: Copy attachment URL to hyperlink/picture column in... - Power Platform Community (microsoft.com)

     

     

     

    If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

     

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

November 2024 Newsletter…

November 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #7 Community Profile Tips…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 143,487

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 64,014

Leaderboard