Sharepoint list - (Data Table)

[Elitezone]

Hello,

Right now in my PowerApp I use Sharepoint list to save the data. People can view this data in a Data Table.

I created data table with listed data from Sharepoint list.

It works mostly good, but I would like to make it even better.

1) One issue I noticed is that hyperlink does not work. I made some columns in DataTable with parameter HyperLink. It shows as a hyperlink but cannot be opened (I checked 2 different PC, and also my one PC at home with different browsers). For example I made link to sharepoint (standard field). It should open I sharepoint detail list (only about this one position that I clicked.

I could only open this hyperlink on mobile.

2) Is it possible to make this DataTable list for example max 5 records and then create pages 1,2,3,4,5? Dynamically? If not is there any other solution for that? Is DataTable even good for that?

I mean my app works like that - You have a suggestion, You make it, attach some stuff, and send it. And I want my people to view it.

3) Is it possible to make a PowerApp page with details about each sharepoint list position? How to link it so there would be a button show details etc?

Thank you all.

[v-qiaqi-msft]

Hi@Elitezone,

Have realized that you have several points appending to be solved in this single case. To better solve them, you should pay attention to one problem in a single case. You could open other cases for the left problems, which will attract more users to help you solve them.

Let's get back to business and we get started with the first one.

Do you want to click the HyperLink within your DataTable to point to the corresponding item in your SP list?

Could you please share a bit more about the scenario?

I have a test on my side, please take a try as below.

Try to set IsHyperlink property of HyperLinkColumn to true, and set OnSelect property as below:

Launch(DataTable1.Selected.TestAddress)

Note: TestAddress is my HyperLinkColumn, replace it with yours.

Best Regards,

Qi

[Elitezone]

@v-qiaqi-msft 

Thank you. It worked... Ok for the others topic I will create new tickets, but I have two more questions regarding this hyper link.

1. Is it possible to make link not visible and instead show static message (like LINK - CLICK) or dynamic (LINK 1, LINK 2).

2. Right now my link is redirecting people to sharepoint details page (it shows a page on which you can check detail of the send forms - in my PowerApp I have only simple data table that shows this hyperlink and details. So to view something I need Sharepoint. I would love to avoid it. Is it possible to make a hyperlink that would open up a new PowerApp page. On this page there would be details about record that would normally be on Sharepoint list (Name, Description, Additional Fields and Attachment).

Scenario is quiet simple and basic, but impossible for me to work out alone.

Clicking the link of the data table record should open details of this record.

[v-qiaqi-msft · Accepted solution]

Hi@Elitezone,

Based on the issue that you mentioned, do you want to make the link display as Text rather than URL?

In general, there is a Hyperlink column type within the SharePoint which has a Link and a Display text. You can enter a URL within the Link part and enter something text as display text.

While it will display as a URL  in PowerApps where you could not refer to the Display text within the Hyperlink column.

Currently, there is no way to achieve this in PowerApps.

If you would like this feature to be added in PowerApps, please submit an idea to PowerApps Ideas Forum:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

For the second point, do you want to view details about the record that normally is on the Sharepoint list in PowerApps?

A hyperlink will always navigate to the page corresponding details to the URL. 

I am afraid there is no way to achieve this in PowerApps.

As an alternative solution, you could add a Hyperlink column in your SP list and store the related URL within it. Then populate the DataTable with the SP list and add the Hyperlink field. After that, you could click the hyperlink to direct to the detail SP page.

Best Regards,

Qi

[Elitezone]

@v-qiaqi-msft 

Thank you for a comprehensive insight.