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; } } }

Power Automate-stroom om gegevens van Sharepoint naar ArcGIS Enterprise Server in real-time te kopiëren

_CameronPearson

Hallo, We proberen een stroom te implementeren om flat file-gegevens in real-time naar ons ArcGIS Enterprise-portaal te kopiëren. Telkens wanneer een eindgebruiker de flat file in Sharepoint bijwerkt/wijzigt, die adres-/locatiegegevens binnen de attributen bevat, willen we dat de gegevens bijna realtime worden gekopieerd/bijgewerkt op onze ArcGIS Enterprise Server. Dit stelt onze kaarten/apps/dashboards in staat om gesynchroniseerd te worden met actuele gegevens. Alle hulp bij de eenvoudigste workflow wordt zeer gewaardeerd.<\/P>

Met vriendelijke groet,<\/P>

Cameron<\/P>

Vind meer berichten getagd met

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.

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

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