Canvas with DataTable read data from SharePoint list and a column from SharePoint List which is multiline - HTML code when you press the link

(0) Share

Report

Posted on by kouliscon

247

Hello,

i have a canvas with a DataTable which reads data from a SharePoint list. One of the columns is a multiline column with hyperlinks.

i had an issue that at the DataTable it was showing the HTML Code like below in the View column

that was resolved by marking the column as "isHyperlink" and also at the "text" putting: PlainText(ThisItem.View)

now when i press the View it doesnt do anything.

any suggestion?

thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @kouliscon ,

Although you have changed the "IsHyperlink" property to true and this make the strings look like hyperlinks, it is still a Text column in the data source, you will not be able to clicking the fake hyperlink and open a new tab.

The workaround is use the "Hyperlink" type column in your SP list. This type of column would directly show clickable hyperlinks in the Data Table control.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
kouliscon 247 on at

Like
a
(0)

Report
Copy link

Link copied!

one more question

it now shows the complete link as i input the link and ID with a flow...

any tricks suggestions to hide the link and have a text like "link" or "press here"?

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @kouliscon ,

With a Data Table control, you will not be able to achieve your need. Please consider use a vertical gallery instead. In the gallery, you could use a Label or Button with its OnSelect setting to Launch(ThisItem.Hyperlink) and Text propert setting to "View" or "Press HERE".

Data Table control is basically used to DISPLAY data that in a table, it could not be interactive most circumstance.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

Was this reply helpful? Yes No
kouliscon 247 on at

Like
a
(0)

Report
Copy link

Link copied!
Wanted to pass another solution which i found which is at PowerApps Canvas form at the DataTable in order to make a column to have a link to another page then you do:
Select column and make “is Hyperlink” ON
on "OnSelect" you add the formula: Launch(("SiteWhereYouWantToGo?ID=") & DataTable.Selected.ID)

Was this reply helpful? Yes No