title: PowerApps datasource to overcome 500 visible or searchable items limit
body: <p>For PowerApps, what data source, other than SharePoint lists are accessible via Powershell?</p>
  
  <p>There are actually two issues that I am dealing with.  The first is dynamic updating and the second is the 500 item limit that SharePoint lists are subject to.</p>
  
  <p>I need to dynamically update my data source, which I am currently doing with PowerShell. My data source is not static and updating records by hand is time-consuming and error prone. The driving force behind my question is that the SharePoint list view threshold is 5,000 records <strong>however</strong> you are limited to 500 visible and searchable records when using SharePoint lists in the Gallery View and my data source contains greater than 500 <strong>but</strong> <em>less than 1000 records</em>.  If you have any items beyond the 500th record that <strong><em>should</em></strong> match the filter criteria, they will <strong>not</strong> be found. So SharePoint lists are not optional for me until that limitation is remediated</p>
  
  <p>Reference: <a href="https://powerapps.microsoft.com/en-us/tutorials/function-filter-lookup/" rel="nofollow noreferrer">https://powerapps.microsoft.com/en-us/tutorials/function-filter-lookup/</a></p>