cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kishama
Helper I
Helper I

Connect datatable with detailform

Hi friends,
I have my datatable with an idticket column (hyperlink), and I would like to achieve the following functionality:
1. Click on a record by "Ticket"
2. Show the "detailform" screen with the data of the clicked record.
Thank you very much for your help.

 

My datatble:

kishama_0-1654789842185.png

My detailform: Before it was connected to a BrowseGallery, but now I need it to connect to my new datatable

kishama_1-1654791242734.png

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
lowcodelewis
Helper I
Helper I

Hi Kishama!

 

This is fairly similar to how you've been working with your gallery. What you want to do here is select the column of the datatable you want to be able to click, in this case ticket, then set the OnSelect property to Navigate(PageTicket_Vista). Then in the form Item property, simply replace your gallery name with your datatable name i.e. Datatable.Selected

View solution in original post

Drrickryp
Super User
Super User

@kishama 

LookUp(...

Darn spellchecker.

 

View solution in original post

6 REPLIES 6
lowcodelewis
Helper I
Helper I

Hi Kishama!

 

This is fairly similar to how you've been working with your gallery. What you want to do here is select the column of the datatable you want to be able to click, in this case ticket, then set the OnSelect property to Navigate(PageTicket_Vista). Then in the form Item property, simply replace your gallery name with your datatable name i.e. Datatable.Selected

Hello @lowcodelewis,

Thank you very much for responding so quickly.
I did the steps you told me, but there is a problem in the detailform.
Message: Invalid formula. Expected n value compatible with DataSource

kishama_0-1654793687786.png

thank you very much for your help

Drrickryp
Super User
Super User

@kishama 

Lookup(yourtable, ID = yourdatatable.Selected.ID) in Item property of the form.

kishama
Helper I
Helper I

Hello @Drrickryp 

I get the following error: lookup is an unknown or unsupported function.

 

kishama_0-1654802121772.png

 

Drrickryp
Super User
Super User

@kishama 

LookUp(...

Darn spellchecker.

 

kishama
Helper I
Helper I

Excellent thank you very much

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,756)