Replace URL as a string/link

(0) Share

Report

Posted on by Lisa4404

Hi,

we want to replace the URL in a SharePoint List as a string/link.

We generated a link column in SharePoint which get filled by a flow-workflow with the URL to a SharePoint document libary e.g. "https://sharepoint/documents/test". The workflow works but in the column the whole URL is displayed. Is there an opportunity to replace the long URL for exampl with an expression?

Many thanks!

Lisa

Categories:

General topics

I have the same question (0)

All responses (12)

Answers (0)

Sort by

PieterVeenstra on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Lisa4404,

You can use expressions like substring and split and all sorts of others. When you add dynamic contents in the expressions tab you will find that if you start typing the fucntions available will be presented to you. It's not restricted to the list of expressions shown in the default list.

Was this reply helpful? Yes No
Lisa4404 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Pieter_Veenstra,

thanks for your reply.
The flow to generate the URL with dynamic content works. The problem is that the URL is written in the SharePoint column and we want to have a link. In SharePoint you can decide between the URL and the Display Text. We want to adapt the Display Text of the Link.

Kind regards
Lisa

Was this reply helpful? Yes No
PieterVeenstra on at

Like
a
(0)

Report
Copy link

Link copied!

That means that you need to update the URL field and include the display text of the URL.

you can do wthis with

<UrL>, <Description>

make sure that there is a space after the comma

Was this reply helpful? Yes No
Lisa4404 5 on at

Like
a
(0)

Report
Copy link

Link copied!

I took the workflow action 'update element in SharePoint'. In the link-field I generate a URL. When I added the description like this

the result is

but the result should be

Or do you use another flow action to generate the link?
Hope it's comprehensible...

Was this reply helpful? Yes No
PieterVeenstra 33 on at

Like
a
(0)

Report
Copy link

Link copied!

I think this doesn't work at the moment.

I just created an item with a url field called hyper. Then I ran the following Flow which first gets hyper field of the item and then updates the item and the description is removed.

I also tried manually updating the URL variable with the "url, description" and I got the same result as you.

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @Lisa4404,

Could you please share a screenshot of your flow's configuration?

Do you want convert the URL into a Display text string/link within the Hyperlink column of your SharePoint list or library using Microsoft Flow?

I agree with @Pieter_Veenstra's thought almost, I afraid that there is no way to achieve your needs in Microsoft Flow currently, if you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Best regards,

Kris

Was this reply helpful? Yes No
bdc604 158 on at

Like
a
(0)

Report
Copy link

Link copied!

Has anyone had any luck leveraging REST API in a Flow: HTTP or Flow: Send an HTTP Request to Sharepoint to achieve the link/display issue for hyperlinks?

Was this reply helpful? Yes No
Brentless 106 on at

Like
a
(0)

Report
Copy link

Link copied!

Replying to older thread, but I have done this successfully on several use cases.

The update part of the code for the hyperlink field is as follows:

'HyperlinkFieldNameHere': {'__metadata': { 'type': 'SP.FieldUrlValue' },'Description': 'Link Name Here','Url': 'http://www.whatever.com' }

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

Like
a
(0)

Report
Copy link

Link copied!

Hi Brentless

Please could you attach a screenshot of your rest call for Update the hyperlink?

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

Like
a
(1)

Report
Copy link

Link copied!

Managed to resolve this, here is my screenshot:

Was this reply helpful? Yes No