Exportovat prvky do Excelu

Question

Ahoj všichni,

jsem nováček v používání ArcGIS pro Power Automate a zajímalo by mě, jestli je možné automaticky exportovat každý prvek, který je přidán nebo upraven v vrstvě Incident Reporting, do tabulky Excel na SharePointu.

Vím, že existuje konektor pro ArcGIS Enterprise v Power Automate, ale nenašel jsem žádné spouštěče pro export dat do Excelu.

Používám ArcGIS Enterprise 11.1 a máme licenci Microsoft 365 E5.

Ví někdo, jestli je to možné?

Děkuji předem!

AnthonyLatini · Answer

Hi @MariusVerdes . Just as a quick note. Please take a look at this blog post to get webhooks enabled in ArcGIS Enterprise 11.1. At the moment, there aren't any dedicated triggers associated with the ArcGIS Enterprise connector as webhooks are not officially supported until ArcGIS Enterprise 11.2.

Enabling webhooks and Fetch Updates for ArcGIS Ent... - Esri Community

As for your inquiry - once you have the webhooks enabled, you can fetch the changes and then export them to any external system you want. SharePoint lists are extremely easy to work with are the easiest way to track and update information. There are connectors for Excel and can be used in conjunction with the ArcGIS connector.

You can create your flow so that it captures anything new that has been created or that has been updated. Here is an example of what this might look like in your flow:

Updating a record in a SharePoint list:

Create a new record in a list:

MariusVerdes · Answer

Hi @AdamAraza,

Thank you so much for the reply. I didn't think about the SharePoint list, I will have a look at that. As for your question, I would like to create a living / dynamic Excel document that will be updated every time a new feature is added to the layer or an existing one is updated. If you have any suggestions here, I would be happy to hear them.

Thanks again!

AdamAraza · Answer

Hi MariusVerdes, this is definitely possible. Are you trying to make a living Excel document in a shared location that your users have access to, or are you sending a new Excel sheet for every record that is added/updated?

With both options, I do find it easier to store data in a SharePoint List first then give the users access to the List or write in your Flow to export the list to a CSV.

If you want features added or updated on your spreadsheet instantly, you may want to make two flows, one with a trigger for "when a feature is updated" and one for "when a feature is added".

Another option would be to create a script using the ArcGIS API for Python and set it on a task scheduler. This wouldn't be triggered when records are added or updated, but if you set the time interval to a reasonable schedule, your users may not even notice.  Here's an example of some code:

import arcpy
from arcgis.gis import GIS
import pandas as pd
csv = 'file location of end product'

#Your enterprise credentials
portal = GIS(url="YourEnterpiseURL", username="yourUsername", password="yourPassword")

#access the layer
url = 'the layer you are querying'
layer = FeatureLayer(url)
feature_set = layer.query(where="1=1", out_fields = ','.join(fields))

#Convert to spatial data frame
sdf = feature_set.sdf

#Export to CSV
sdf.to_csv(csv, index=False)