cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
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
Highlighted
Super User III
Super User III

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.

Highlighted
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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (8,790)