Datatable display based on form data

[ksmith23]

I am trying to get the Datatable on the bottom of the screenshot to display list rows when a user types in the "Oracle Number" from the top form.  I tried a lookup function based on the form, but it did not work.  Is this possible?  

[Drrickryp]

@ksmith23 

Please explain the table structure for your app.  Is all the data in a single table or are there two tables in a one to many relationship?

[ksmith23]

It is a one (form input) to many (data table) on the app itself, but all data is located on the same list.  The user inputs data on the form that populates the list, and I am trying to get the data table to display all records from the list that have the "Oracle Number".   Does that make sense?  I am pretty new to Powerapps, so my terminology is probably off.

[Drrickryp]

@ksmith23 

It sounds like you have a single table containing a one to many relationship.  I suggest you normalize them by separating out a second table. Please see my blog post starting here about how to do this and why it is a "best practice". https://powerusers.microsoft.com/t5/Power-Apps-Community-Blog/Relational-database-design-and-PowerAp... 

[PK_Hong · Accepted solution]

Hi @ksmith23 

I guess you wish to Filter(Datatable) based on the data in "Oracle Number".
Wish I am right.

Pretty straighforward if so

DataTable.Items = Filter(datasourceOfYourDatatable, "Oracle Number" = TextInputofOracbleNumber.Text)
Just a normal Filter.

Wish My guessing is correct.

have a nice day

PK Hong / hpkeong

[Drrickryp]

@PK_Hong 

You are right, but the table is poorly designed. 

[ksmith23]

That worked, thank you for the help.  I may have not explained it very well.  I am using the form as the input to the list, and the Datatable as the view of the list since it can display multiple records.