cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
J_Karlsson
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

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
cwebb365
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? 

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

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

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

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


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.

 

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


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

cwebb365
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
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.

Top Solution Authors
Top Kudoed Authors
Users online (17,534)