cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NicoleChina
Frequent Visitor

In PowerApps how to refresh a list as a word with link/address?

In powerapps, how to refresh the url in the sharepoint list to display it as a word like "click here", and click the word to jump to the url instead of directly displaying it as a url?

3 REPLIES 3
timl
Super User III
Super User III

Hi @NicoleChina

You can accomplish this by using a label and calling the Launch function when the user clicks the label.
Assuming that you're working with a field in a form, the first step is to click the 'Advanced' section and to click the unlock button.
Next, insert a label and set the text to 'Click here'. Set the OnSelect property to:

Launch(ThisItem.URL)

SPLink.JPG

You would need to replace URL with the name of your SharePoint field.
Finally, set the color and hover colors to Color.Blue (or some other color) to give the label the appearance of a hyperlink.

v-xida-msft
Community Support
Community Support

Hi @NicoleChina,

Could you please share a bit more about your scenario?

Do you want to display a url text (from a SP list) as a Hyperlink (as a word like "Click here") within PowerApps?

I agree with @timl's thought almost, I think the Launch function could achieve your needs.

I have made a test on my side, please take a try with the following workaround:

I created a SP list on my side, the data structure as below:3.JPG

Note: The URL column is a Single line of text type column, which is used to store the URL link.

App's configuration as below:4.JPG

Within the Display form (in Detail screen), unlock the URL Data card, set the Text property of the Label control (DataCardValue) within the URL Data card to following:

"Click Here"   /* In default, here would be set to Parent.Default */

Set the OnSelect property of the Label control to following formula:

Launch(ThisItem.URL)            /* Or, you could also type Launch(Parent.Default) formula */

Set the HoverColor property of the Label control to following:

RGBA( 255, 20, 147, 1 )

Set the DisplayMode property of the Label control to following formula:

DisplayMode.Edit

The GIF screenshot as below:Test1.gif

More details about the Launch function in PowerApps, please check the following article:

Launch function

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
NicoleChina
Frequent Visitor

Hi, @timl , @v-xida-msft , thank you for replies. I think my description is not correct.
Here is an example:
My sharepoint has a list named ListA, like this:
ListA
title color link
FolderA red Read
FolderB blue Read
When you click the Read, you will go to the link http://www.mysharepoint/ListA/FolderA .
The problem is when I click a button in PowerApps to create a new FolderC, and saved the url in the ListA.link as “http://www.mysharepoint/ListA/FolderC”. ListA will like this:
title color link
FolderA red Read
FolderB blue Read
FolderC green http://www.mysharepoint/ListA/FolderC

I hope the “link” is still show “Read”, and when I click the “Read”, I will go to the url.

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (56,570)