How to populate an Edit form with a record from SQL Server table based on pk passed from combobox.

(0) Share

Report

Posted on by KurtWimberger

Hi there. Brand new to PowerApps. I come from an old VBA and C# background.
I have a combobox on a screen and it lives outside of the boundary of the Edit form on the same screen. The combobox contains the names and PKs of IT systems. When the user selects a system name from the combo I want to pass the system pk to the edit form to populate the form with data from just the selected system.

I have the edit form's DataSource set to a SQL Server table (I have the gateway and connection set up properly). How can I inform the Edit form to load using the pk from the combo? I know I can capture the selected pk by referencing the combo.SelectedItems and the pk column name. That's as far as I have been able to go.

Most of my searching has led me down incorrect paths so far. Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (0)

narayan225 2,547 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@KurtWimberger

You can use the following formula to lookup your records and display it in the form.
LookUp(table,ComboBox1_1.Selected.pk= pkcolumn)
I don't know your data schema, so you will need to adapt this formula to suit you.

Cheers!

Was this reply helpful? Yes No