Forum Discussion

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

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

Deleted

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
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
  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!
  - Jason H
    Copper Contributor
    Mar 11, 2019
    Its not the "category term="
    Look for the tag:
    
    <d:ListItemEntityTypeFullName></d:ListItemEntityTypeFullName>
    If that doesn't work, take a screenshot of your flow

Resources