Forum Discussion

Henning Strand's avatar
Henning Strand
Brass Contributor
Jun 14, 2018

Updating a Hyperlink field (both url and description) using Flow?

I tried using the update item action to set a Hyperlink type column in my custom list. The Flow field for this column only accepts the url so there seems to be no way to add the description part. Any...
Microsoft Flow
sharepoint
Jason H's avatar
Jason H
Copper Contributor
Aug 29, 2018

 

I too found updating the hyperlink description much harder than it should be.  The best solution that worked for me is detailed below.

 

I had a client ask for the ability to export individual items to Excel.  SPO export function by default exports all items so long story short I ended up using Flow.  I used the below action to update the URL to the CSV file and changed the display name to "CSV"

 

TestURL2 is the column name

 

  • Chintan123's avatar
    Chintan123
    Copper Contributor
    Nov 15, 2021
    Jason - there is a correction in your screenshot. YOu need to correct it to avoid confusion by reader.
    Body Text is as follow:-
    {'__metadata': {'type':'SP.Data.TaskListItem'},
    'InternalFieldName':{'Description': 'Click Here','Url': 'siteUrl/sites/site1/Lists/Task/DispForm.aspx?ID=1'}
    }
    if your list name is "abc" then type value should be "SP.Data.abcListItem".
    Field name should be Internal field name and not display name.
  • Anonymous's avatar
    Anonymous
    Feb 20, 2019
    Hi Jason, For me, it was bit complicated that my site name and list name contain some spaces. But, it just works fine. Thanks. Masahiro
    • Jason H's avatar
      Jason H
      Copper Contributor
      Feb 22, 2019
      Deleted wrote:
      Hi Jason, For me, it was bit complicated that my site name and list name contain some spaces. But, it just works fine. Thanks. Masahiro

      I'm glad that worked for you Masahiro.  Yes spaces are nasty and I try to avoid them if I can :)

      • mo_mkf's avatar
        mo_mkf
        Copper Contributor
        Mar 08, 2019

        I was trying to get this to work and I keep running to the following error:

         

        "The property '__metadata' does not exist on type 'SP.Data.AccountsListItem'. Make sure to only use property names that are defined by the type.\r\nclientRequestId: 2408701b-9fdd-49fc-8136-0d0a2244ce5d\r\nserviceRequestId: d614c79e-f0dd-8000-aa83-416edc2ce86f"
         
        After a bit of searching around the best 'solution' I found was here: http://dinushaonline.blogspot.com/2014/09/resolve-property-does-not-exist-on-type.html
        However, I have gone to the URL and copied out the "category term=" exactly.
         
        So, I'm not sure what else could be the culprit.
         
        Any thoughts?
         
        Thanks!
  • Marianne Chalupt's avatar
    Marianne Chalupt
    Copper Contributor
    Oct 29, 2018

    Hi,

    I have tried your solution, but I have an code error 412. 

    message": "La valeur «  » ETag de la demande ne correspond pas à la valeur « \"4\" » ETag de l'objet.

     The message are in french  ,but that said : Etag Request doesn't match to value 4 of the Etag Object.

    Please can you help me?

     

    • Jason H's avatar
      Jason H
      Copper Contributor
      Nov 08, 2018

      1. Could it be that your column name is actually different to the display name?

       

      You can check this by browsing to the URL

      https://<sharepoint server or tenant>/<site collection>/<subsite>/_api/web/lists/getbytitle('<listname>')/Items

       

      Then view the source which will display what your columns are actually named.

       

      2.  Check that the "type" is correct.  This can also be found in the source above

      3. Check that the destination column you are trying to update, is the type "Hyperlink or Picture"

       

      See how you go with that.  If you still can't find the issue, send screenshots of your flow, attach the source file and screenshot the column type in list settings

    • Parmi MEHTA's avatar
      Parmi MEHTA
      Copper Contributor
      Nov 07, 2018
      unfortunately taxonomy values are not yet supported in Flow for tagging. it does not work.

Resources