Answered

DataTable ThisItem not available for OnSelect

(0) Share

Report

Posted on by PattersonCA1

I have a DataTable that I am attempting use a hyperlink and let a user navigate to a record. To do that I set IsHyperlink = true. Then, I would like to on that same field use the "Launch" command with current record ID. I end up with something like this:

OnSelect = Launch("Http://MyUrl.com...&id=" & ThisItem.ID)

However, the ThisItem throws an error "Name isn't valid. This identifier isn't recognized." However, the Text=ThisItem.UserDisplayName works perfectly fine. I have also tried to set a variable OnClick for testing purposes and get a similar error message.

Categories:

Building Power Apps

I have the same question (0)

All responses (14)

Answers (2)

BCBuizer 22,636 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @PattersonCA1 ,

Please check the syntax for the Launch() function:

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-param#syntax

Your formula will look something like the below

OnSelect = Launch("Http://MyUrl.com", "id", ThisItem.ID)

Which should result in a new window or tab opened with the below URL:

http://myurl.com&id=X

Was this reply helpful? Yes No
PattersonCA1 75 on at

Like (1)

Report
Copy link

Link copied!

I looked at this just now. While I can definitely change it the way you specified, it does not solve the original issue unfortunately that ThisItem is still not available for use. Typing in exactly what you did still gives me the error "Name isn't valid. This identifier isn't recognized."

If I swap over to the "Text" item and copy paste ThisItem.ID, it displays the ID in the column, so I know there aren't any typos in it.

Was this reply helpful? Yes No
BCBuizer 22,636 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @PattersonCA1 ,

I have used this exact code which working:

OnSelect = Launch("Http://MyUrl.com", "id", ThisItem.ID)

Only if I type the name of a column that doesn't exits, I get the same error:

Can you remove the "ID" after "ThisItem." and see what options PowerApps suggests? Like in the picture above, it suggests me to use "ID".

Was this reply helpful? Yes No
PattersonCA1 75 on at

Like (0)

Report
Copy link

Link copied!

I can't get it to even get that far. It gives me the error on ThisItem. Not on the second half. It gives me no suggestions:

Was this reply helpful? Yes No
BCBuizer 22,636 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @PattersonCA1 ,

What is the control you are setting the OnSelect property for? In my case it is a gallery and I assumed it was the same for you, but now I'm not sure.

Was this reply helpful? Yes No
PattersonCA1 75 on at

Like (0)

Report
Copy link

Link copied!

It's a DataTable.

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@PattersonCA1

DataTables do not have an internal ThisItem property! The datatable itself does not have an OnSelect action - only the columns in the datatable. And since it is a column, the concept of ThisItem is not applicable.

If you want that level of functionality, I would consider moving to a Gallery rather than a DataTable control.

I hope this is helpful for you.

Was this reply helpful? Yes No
BCBuizer 22,636 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @PattersonCA1,

There's the issue then. You can't select individual records in a DataTable, just columns. I was just looking to see if I can add a column to my dataset that is populated with a URL, but I can't get that to work just yet:

For the DataTable, Items = colTest

Was this reply helpful? Yes No
PattersonCA1 75 on at

Like (0)

Report
Copy link

Link copied!

Hey Randy -- I should have been more specific in that I am doing it within a column, not the DataTable as a whole. I don't see how it's not applicable on the "OnSelect" when the "Text" value of the column is using the ThisItem property as its default setting.

Was this reply helpful? Yes No
PattersonCA1 75 on at

Like (0)

Report
Copy link

Link copied!

I will look at transitioning this to a gallery as Randy suggested.

Was this reply helpful? Yes No