Get hyperlink display text in SP list

(0) Share

Report

Posted on by PSW

Just starting out in flow and falling at the first fence...

I have a list in Sharepoint Online.

I want to update the title column with the display text in a hyperlink field

I've built a 'When existing item is modified' trigger that catches a change and added an 'Update item' to udate the field.

It almost works... The title is updating nicely.

But I can only see how to use the default value of the hyperlink (The URL) when what I need is the display text

I suspect that I need to use an expression to get at a property of the hyperlink object, but I'm not finding the docs to be of much value

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

GrandMoffReknaw 9 on at

Like (0)

Report
Re: Get hyperlink display text in SP list

This one took me some time too, but I found the following helped:
https://techcommunity.microsoft.com/t5/PowerApps-Flow/Updating-a-Hyperlink-field-both-url-and-description-using-Flow/m-p/204268
https://collab365.community/setting-updating-sharepoint-hyperlink-fields-flow-logic-apps/
https://nishantrana.me/2013/10/03/a-type-named-sp-data-listitem-could-not-be-resolved-by-the-model-when-a-model-is-available-each-type-name-must-resolve-to-a-valid-type-error-in-sharepoint-2013/
It's not 100% clear how to find half the info. I am working on a tool to help with this as it is not clear!

Was this reply helpful? Yes No
Verified answer

v-bacao-msft on at

Like (1)

Report
Re: Get hyperlink display text in SP list

Hi @PSW ,

Please try to do this to get the text of the hyperlink.

For example, list2 has a field of type hyperlink.

Expression reference:

body('Send_an_HTTP_request_to_SharePoint')['d']['ColumnName']['Description']

Image reference:

Hope it helps.

Best Regards,

Was this reply helpful? Yes No
PSW 3 on at

Like (0)

Report
Re: Get hyperlink display text in SP list

Thanks - that works

@v-bacao-msft wrote:

Hi @PSW ,

Please try to do this to get the text of the hyperlink.
For example, list2 has a field of type hyperlink.
Expression reference:
body('Send_an_HTTP_request_to_SharePoint')['d']['ColumnName']['Description']

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Re: Get hyperlink display text in SP list

@PSW @v-bacao-msft can either one of you help me with getting this to work? i followed the steps but have no luck....Kindly...?

I have a list, the column title is "bio". I tried to follow the screenshot step for step.

Was this reply helpful? Yes No