title: Can I Add Related Tables to a PowerApps Canvas App?
body: <p>I have inherited a PowerApps Canvas app that uses SQL Server as it's data source. The tables involved are Customer, Project and Work Order. </p>
  
  <p>I’m building a Create Work Order Screen that requires the Customer ID, Project ID and Work Order Item IDs. The tables have foreign key relationships. How do I add all required tables as a collective data source?  It seems that Canvas PowerApps are limited to single entities but need to confirm this. </p>