title: Single Gallery from multiple sharepoint list (all same fields)
body: <p>Currently my powerapp is having a Gallery which is based on a single sharepoint list but <strong>i would like to implement a gallery on my app which should show items from 3 different sharepoint lists (all have same columns/fields)</strong> and i am using a filter on the galley so that user can type on the box and get filtered response only instead of showing all data</p>
  
  <p>Please Help</p>
  
  <p>I am already having this formula in gallery1.items : </p>
  
  <p>Search('PO list', TextSearchBox.Text,"Branch_x0020_Code")
   For example,consider i have 2 list : list 1 &amp; list 2 ,now when an user searches in the searchbox (i.e. TextSearchbox) i want the gallery to filter the data wherein "Branch_x0020_Code" equals search data from both the List</p>
  
  <p>EDIT 1 : This is the formula i am trying to implement : 
  Formula  : <em>ClearCollect(Aitems,'PO list',PO 2)</em></p>
  
  <p>and error is shown as in the following image:</p>
  
  <p><a href="https://i.stack.imgur.com/r7r47.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/r7r47.jpg" alt="error"></a></p>
  
  <p>My <em>"PO List"</em> was having a column called status and its type was Single line of text whereas in <em>"PO 2"</em> the type of status column was Choices .since i cannot change the datatype i have changed one of the list column name to <em>"Status 0"</em> .
  Now the only difference i have between these two lists are one list has some extra columns while other don,t have.
  But still when i am trying ti implement i am getting this <em>"Incompatible type"</em> error.</p>