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:

Connecting to Data

Connectors

Using Apps Using Formulas

General Questions

All responses (4)

Answers (1)

kouliscon 247 on at

Like (0)

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

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)
v-jefferni on at

Like (0)

Report

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

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.
kouliscon 247 on at

Like (0)

Report

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

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"?
Verified answer

v-jefferni on at

Like (1)

Report

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

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.