Answered

Create button to navigate to screen and display record from tabel

(0) Share

Report

Posted on by MaxEAI

I want to put a button within a form that navigates to a new screen and shows a specific row of data from another table. I have the button and another screen with a display from but with my limited knowledge I can't figure out how to make the button tell the form what row of data to display. I have been trying to use OnSelect, Set( vRecord, LookUp(Table2, ID = ); Navigate(Screen4); but I don't know how to describe the row of data for the ID or if that would even work.

Categories:

Building Power Apps

All responses (6)

Answers (1)

Sort by

Verified answer

ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
HI @MaxEAI , Pleases correct me if I am wrong. You are trying to selecta record from table and that record information you want to show in another screen on specific form, if this is what you are looking for then please below code on button OnSelect property:

Set(vRecord, LookUp(Table2, ID = 1));Navigate(Screen4);

Then on form Item property use the variable vRecord and the data source of the form should be same Table2.

------------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.

Thanks,
ANB
MaxEAI 11 on at

Like
a
(0)

Report
Copy link

Link copied!

I still get an error when trying that formula. I attached a screen grab if that helps.
ANB 7,252 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MaxEAI , Can you send the error message. IN the screenshot I dont see the error message. It only show red cross. Please hover on red cross, which will give you the error message. Please capture that and send me.

Thanks,
ANB
MaxEAI 11 on at

Like
a
(0)

Report
Copy link

Link copied!

Incompatible types for comparison. These types can't be compared: error, Number
ANB 7,252 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @MaxEAI , What is the datatype of your ID column? If it is text, then use

Set(vRecord, LookUp(Table2, ID = "1"));Navigate(Screen4);

------------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.

Thanks,
ANB
MaxEAI 11 on at

Like
a
(1)

Report
Copy link

Link copied!

I went back and checked the excel and my ID column was IDd on accident once I fixed the header now it works! Thanks for the help.