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
Frequent Visitor

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
Frequent Visitor

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 Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (1,957)