title: combine 2 data sources and display data on single table in power apps
body: <ul>
  <li><p>work environment :  power apps</p>
  </li>
  <li><p>data source : employee table and department table in sql server.</p>
  </li>
  <li><p>the problem scenario :
  please, have a look on the diagram :
  <a href="https://i.stack.imgur.com/MM68Q.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MM68Q.png" alt="Combine table columns and create one single table to display on power apps." /></a></p>
  </li>
  </ul>
  <p>as per the diagram I want to display a table on the simple canvas app
  which is a combined result of both employee and department table.</p>
  <p>I have no idea how I could do that in power apps. tried many things maybe I am doing it in an incorrect way.</p>