I am attempting to bring in certain records from 2 tables and collect them on a button click (attached pictures for tables). I only want to collect records that have Completed=0 in the header table and thus only collect the records where Header.shipid=order.shipid after the "completed=1" are filtered out. I have no clue how to join tables from sql server in powerapps though.
If you're only looking to view the records then it might be useful to create a view in SQL and do the join there, you can then use PowerApps to connect to that view. This post from Evan Chaki gives a good overview on how to do this.