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

I have the same question (0)

All responses (6)

Answers (1)

Verified answer

ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report
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

Was this reply helpful? Yes No
MaxEAI 11 on at

Like (0)

Report

I still get an error when trying that formula. I attached a screen grab if that helps.

button.PNG

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
MaxEAI 11 on at

Like (0)

Report

Incompatible types for comparison. These types can't be compared: error, Number

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (1)

Report
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

Was this reply helpful? Yes No
MaxEAI 11 on at

Like (1)

Report

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.

Was this reply helpful? Yes No