Answered

Hyperlink to Sharepoint

(0) Share

Report

Posted on by J_Karlsson

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

cwebb365 3,294 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
bhitchlock 28 on at

Like (1)

Report
Copy link

Link copied!
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)

Was this reply helpful? Yes No
J_Karlsson 50 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
J_Karlsson 50 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
J_Karlsson 50 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
iAm_ManCat 18,256 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Verified answer

bhitchlock 28 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
cwebb365 3,294 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No