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 para Copiar Dados do Sharepoint para o ArcGIS Enterprise Server em Tempo Real

_CameronPearson

Olá, Estamos tentando implementar um fluxo para copiar dados de arquivo plano para nosso portal ArcGIS Enterprise em tempo real. Sempre que um usuário final atualizar/alterar o arquivo plano armazenado no Sharepoint, que contém endereço/localização dentro dos atributos, gostaríamos que os dados fossem copiados/atualizados em nosso ArcGIS Enterprise Server quase em tempo real. Isso permitirá que nossos mapas/aplicativos/dashboards sejam sincronizados com dados atualizados. Qualquer ajuda sobre o fluxo de trabalho mais fácil seria muito apreciada.<\/P>

Atenciosamente,<\/P>

Cameron<\/P>

Encontre mais publicações marcadas com

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.

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

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