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
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

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

Users online (3,386)