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 Flow zum Kopieren von Daten von Sharepoint zu ArcGIS Enterprise Server in Echtzeit

_CameronPearson

Hallo, wir versuchen, einen Flow zu implementieren, um Flat-File-Daten in Echtzeit in unser ArcGIS Enterprise-Portal zu kopieren. Jedes Mal, wenn ein Endbenutzer die Flat-Datei in Sharepoint aktualisiert/ändert, die Adress-/Standortinformationen in den Attributen enthält, möchten wir, dass die Daten nahezu in Echtzeit auf unserem ArcGIS Enterprise Server kopiert/aktualisiert werden. Dies ermöglicht es unseren Karten/Apps/Dashboards, mit aktuellen Daten synchronisiert zu werden. Jede Hilfe zum einfachsten Workflow wäre sehr willkommen.<\/P>

Mit freundlichen Grüßen,<\/P>

Cameron<\/P>

Finde mehr Beiträge mit dem Tag

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.

Nimm an der Diskussion teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

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