Is it possible to Query List on a Hyperlink field?

  • 11 October 2017
  • 2 replies
  • 0 views

Userlevel 2
Badge +11

Hi all,

For a project I need to query a list and one of its filters needs to be on a Hyperlink column. No matter what I try, I can't get it working; except for the too loose filter if the Hyperlink Contains a partial text. What am I missing?

Thanks in advance.

KR

Jean-Pierre


2 replies

Userlevel 2
Badge +11

Found it. The URL to search for in a Hyperlink field should not include the http://your.sharepoint.domain part and it should start with the / character.

Badge +1

Thanks for solution! Also you should use Trim({TextStart}search string{TextEnd})

Reply