nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Flux Power Automate pour copier des données de Sharepoint vers ArcGIS Enterprise Server en temps réel

_CameronPearson

Bonjour, Nous essayons de mettre en place un flux pour copier les données de fichiers plats vers notre portail ArcGIS Enterprise en temps réel. Chaque fois qu'un utilisateur final met à jour/modifie le fichier plat situé dans Sharepoint qui contient une adresse/emplacement dans les attributs, nous souhaitons que les données soient copiées/mises à jour sur notre ArcGIS Enterprise Server en quasi temps réel. Cela permettra à nos cartes/applications/tableaux de bord d'être synchronisés avec des données à jour. Toute aide concernant le flux de travail le plus simple serait grandement appréciée.<\/P>

Cordialement,<\/P>

Cameron<\/P>

Trouver plus de publications taguées avec

Accepted answers

SeanKMcGinnis

Good Day @_CameronPearson - at this time, the ArcGIS Connector for Power Automate only connects to ArcGIS Online. We are working on identifying the security best practices that will allow the connector to authenticate against Enterprise and are planning to release it by the end of this year.

That being said, the workflow you are laying out is possible with existing actions and triggers against hosted feature layers in ArcGIS Online. Microsoft does have a trigger to listen for new or edited files. The flat file would have to be structured so it could be iterated through and include unique ID's for each record. There will be some complexity in determining if the record needs to be updated because of a change or created because it is a new record. But the ArcGIS Connector's update and create record actions could handle it.

One thing that might make the process a little easier is instead of a flat file, using a SharePoint list. The Power Automate trigger for lists knows which record has been created or edited and would pass the unique ID and the flow is working with a single record and not having to infer the delta(s).

I hope this helps and feel free to share any comments or other questions you may have.

All comments

SeanKMcGinnis

I hope this helps and feel free to share any comments or other questions you may have.

ZacharyHart

at this time, the ArcGIS Connector for Power Automate only connects to ArcGIS Online.

Could you please clarify this? Do you mean the direction of data flow from Power Automate/MS365 to Enterprise is not supported? I ask this because we do have an ArcGIS Enterprise connector which is set to capture basic info from Portal webhooks which feeds into other Power Automate flows.

I'm only familiar with one connector for ArcGIS in Power Automate.

SeanKMcGinnis

@ZacharyHart - that is correct. The current release of the ArcGIS Connector for Power Automate is not able to connect to or utilize services from ArcGIS Enterprise.

ZacharyHart

@SeanKMcGinnisMy fault...I was thinking of the Survey123 Connector for Enterprise. The ArcGIS Connector for Enterprise will be a welcome addition!

AdamCrateau

Hello @SeanKMcGinnis ,

As you suggested in the above post, I'm attempting to set up a workflow where when a Sharepoint list item is modified, a hosted feature layer (ArcGIS Online) is updated with the new values.

In this case, the owner of the SP List is someone else in our organization, but I have view access. I'm the owner of a hosted feature layer with the same column names, including a column "SP_ID" which maps to the ID of the SP List.

Will I be able to setup an action using the ArcGIS Connector "Update a record in a feature layer" to accomplish this?

SeanKMcGinnis

Hi @ACrateau - that is an interesting use case.

I am not sure of Microsoft's security model and the rules allowing a user that only has view access to listen for deltas in a list. As for the use of the "Update record in a feature layer" action, that would be the one that would the one to use to query based on your SP_ID values and update the record.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.