I created a model in modelbuilder to automate the process of taking a new .csv file, creating a xy point layer and then having that new layer overwrite the current web layer that I have hosted. The issue is that the web layer is connected to a web map and a dashboard so when I overwrite the current layer, the new one doesn't appear in the map or dashboard. Is there a way to automate this so I don't have to go in and add the new over written web layer to the web map and then reconfigure the dashboard every time?
I'd recommend making a view layer from the hosted feature service you overwrite, and consume that in the web map and dashboard. The symbology and popups configured on that layer won't be affected when you overwrite the source hosted feature layer.
Have a look at the workflow here:
https://learn.arcgis.com/en/projects/schedule-automated-near-real-time-data-updates/
Should this workflow be the same if I'm using .csv files or do I need it to be geojson for this to work?
The process is basically the same. The OverwriteFS script should handle CSV.