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?
Don't know why I keep forgetting about column formatting. It's the old schooler SharePoint in me.... good call on that one.
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
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 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,
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 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)
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?
WarrenBelz
146,524
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
65,906
Most Valuable Professional