Andrew McKinney

Proof of Automation

Automate Dashboard updates from SharePoint List

  • January 7, 2020 at 9:27 AM
  • Last updated about 4 years ago
  • Visible to public
Utilizing Microsoft Power Automate (formally Flows) we built an ETL process that extracts data from a SharePoint list for the Blighted Property Actions Teams Property list into a CSV every hour, can be scaled up or down or run manually. This CSV file can then be consumed by ArcGIS Online from which an Operations Dashboard was created. The only operation that the user has to do is click an Update Button in ArcGIS Online to update the Operations Dashboard.