cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
buffanut
Frequent Visitor

populating an edit table based on primary key using columns not in the viewing table

@mdevaney  Thank you for the suggestion to start a new thread.

I have two tables on a screen. the first table is a view table and displays a unique identifier from a table. the second table is an edit table and has other columns from the same table that I would like to populate based on the selected row from the view table.

The problem I am running into is the table for editing will only contain the value for the unique identifier and not all of the columns. 

i've tried using this formulas, and variations of it:

     Item = Filter('[dbo].[Project List Master]',SID = DataTable1.Selected.SID)

but am getting no luck. 

 

Any help would be very much appreciated!

1 ACCEPTED SOLUTION

Accepted Solutions
v-yutliu-msft
Community Support
Community Support

Hi @buffanut ,

Do you mean that you set an edit form's Item to : Filter('[dbo].[Project List Master]',SID = DataTable1.Selected.SID)?

Actually, one edit form's Item should be one record.

While the result that Filter function returns is a table.

Please set the form's Item:

First(Filter('[dbo].[Project List Master]',SID = DataTable1.Selected.SID))

 

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Drrickryp
Super User II
Super User II

Hi @buffanut 

Filter will not work because it returns a table and not a record.  First(Filter(Filter('[dbo].[Project List Master]',SID = DataTable1.Selected.SID)) should do the trick.

v-yutliu-msft
Community Support
Community Support

Hi @buffanut ,

Do you mean that you set an edit form's Item to : Filter('[dbo].[Project List Master]',SID = DataTable1.Selected.SID)?

Actually, one edit form's Item should be one record.

While the result that Filter function returns is a table.

Please set the form's Item:

First(Filter('[dbo].[Project List Master]',SID = DataTable1.Selected.SID))

 

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

PA Community Call

Power Apps Community Call

Next call is happening on April 21st at 8a PST.

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (52,771)