Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Answered

Hyperlink to Sharepoint

(0) ShareShare
ReportReport
Posted on by 50

Hi I have created an app where I capture the current location when i push a button for capture location.

The code  for getting the url "http://www.google.com/maps/place/" & CurrentLocation.Latitude & "," & CurrentLocation.Longitude"

The link below is then sent to Sharepoint with the correct longitude and latitude of course.

http://www.google.com/maps/place/Latitude,Longitude

Im using a Textlabel to show the link and then I send it to a sharepoint directory with a textcolumn using a flow.

But my issue is that the link is not clickable, does any one have any good idea how to solve it?

 

  • cwebb365 Profile Picture
    3,294 Most Valuable Professional on at
    Re: Hyperlink to Sharepoint

    Don't know why I keep forgetting about column formatting. It's the old schooler SharePoint in me.... good call on that one. 

  • Verified answer
    bhitchlock Profile Picture
    28 on at
    Re: Hyperlink to Sharepoint

    Hi Johan,

    I'm not a developer either, but the new column formatting isn't too bad once you get the right code since you can just copy and paste directly in SharePoint. See https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting

     

    The Hyperlink column type is clickable by default, but I have found this column presents challenges in Flow since it's not a simple field and requires both a Url and Description. Column formatting with Modern lists and text columns ended up being an easier solution for me.

     

    Hope this helps.

     

    Brian

    FormatColumnClickableLink.PNG

     

  • iAm_ManCat Profile Picture
    18,201 Most Valuable Professional on at
    Re: Hyperlink to Sharepoint
    Hi, Yes it's stored in a SharePoint list - the screenshot I posted is from within the list on SharePoint. Could you have a form that is submitted back to SharePoint as well as trigger a flow for the image?
  • J_Karlsson Profile Picture
    50 on at
    Re: Hyperlink to Sharepoint

    Hi, did you use sharepoint as a datasource then?

    My case is that I Use a flow to send a picture and the link as some kind of metadata together.

    But I guess I could use sharepoint as datasource as well.

     

  • iAm_ManCat Profile Picture
    18,201 Most Valuable Professional on at
    Re: Hyperlink to Sharepoint
    Hi @J_Karlsson & @bhitchlock I was able to create a column in SharePoint (of type: Hyperlink) without any extra settings (using the SharePoint Modern experience) and a form in PowerApps with no extra settings and was able to save the entire link back to SharePoint and then have it be clickable (attached). Could you try this on your end by adding the new column of type Hyperlink? Cheers, @iAm_ManCat
  • J_Karlsson Profile Picture
    50 on at
    Re: Hyperlink to Sharepoint

    Hi,

    Yes the Hyperlink column type is not working to put information in from Powerapps.

    But since I'm using a flow between my power app and sharepoint I would have hoped that there was a way to convert the text in the flow and save it to sharepoint, either a textcolumn or hyperlink column.

     

    I saw an answer on my question regarding modify the column in sharepoint but my hope is that it should be possible to do without making modifications in sharepoint.

     

    Regards Johan

  • J_Karlsson Profile Picture
    50 on at
    Re: Hyperlink to Sharepoint

    Hi,

    Thank you for your answer, I'm not a sharepoint developer but thanks for your code snippet anyway and maybe I will try to test it.

     

    I have done it in powerapps using the Launch command and it works fine, but that isn't quite what I'm looking for at the moment.

    Regards Johan

  • bhitchlock Profile Picture
    28 on at
    Re: Hyperlink to Sharepoint

    Hi J_Karlsson,

     

    If you want the link to be clickable in the SharePoint list view you can use SharePoint column formatting to make the text value in a field a clickable link. The basic code is below:

    {
     "$schema": "https://developer.microsoft.com/json-schemas/sp/column-formatting.schema.json",
     "elmType": "a",
     "txtContent": "@currentField",
     "attributes": {
     "target": "_blank",
     "href": "=@currentField"
     }
    }

    If you want it to be clickable in PowerApps, just attach a Launch command to the OnSelect event of the control or a button.

    Launch(ThisItem.Hyperlink)
  • cwebb365 Profile Picture
    3,294 Most Valuable Professional on at
    Re: Hyperlink to Sharepoint

    There is a Link column type in SharePoint but from what I've seen no one has or it's not possible to update that field type in SharePoint yet from Powerapps. Until we can figure out how to get that data in a link field type we won't have clickable links. 

     

    What you might try and see if it works is using a multitext column, and pass in the formatting for it for that field in SharePoint instead? I want to say that comes across in list views. Assuming you are trying to click the links via a list view? 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard