Medium badge

Automation Machine

Louisville-Metro-Badges/Automation-Machine

Work to automate some process in the data life cycle- from data collection to data visualization.

 

Andrew McKinney

Expert

Awarded badge on January 8, 2020

Medium pic

Endorsements & Feedback

Feedback

Kudos!

This is great. I'm interested in knowing more about this Microsoft Power and Sharepoint Automation. Keep up the amazing work. 
Small pic amckinney About 2 months ago

Badge Portfolio

Proof of Automation

Evidence visible to public
Write up a summary about how you were able to change the process, and how the current automation process works. More Info

Automate Dashboard updates from SharePoint List

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.