cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Hyperlink to Sharepoint

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?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

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

 

View solution in original post

9 REPLIES 9
Highlighted
Impactful Individual
Impactful Individual

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? 

Highlighted
Frequent Visitor

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)
Highlighted

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

Highlighted

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

Highlighted

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

@iAm_ManCat

Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!


Thanks!
You and everyone else in the community make it the awesome and welcoming place it is, keep your questions coming and make sure to 'like' anything that makes you 'Appy
Sancho Harker, MVP


Highlighted

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.

 

Highlighted

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?

@iAm_ManCat

Please 'Mark as Solution' if someone's post answered your question and always 'Thumbs Up' the posts you like or that helped you!


Thanks!
You and everyone else in the community make it the awesome and welcoming place it is, keep your questions coming and make sure to 'like' anything that makes you 'Appy
Sancho Harker, MVP


Highlighted

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

 

View solution in original post

Highlighted
Impactful Individual
Impactful Individual

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (11,943)