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

Verbindung einer SharePoint-Liste mit einem gehosteten Feature-Service (AGOL)

AdamCrateau

Ist es mit ArcGIS für SharePoint möglich, eine SP-Liste mit einem gehosteten Feature-Service in AGOL zu verbinden, sodass bei einer Aktualisierung der Liste auch der Feature-Service aktualisiert wird? <\/P>

Alternativ, ist dies ein Workflow, der mit Power Automate durchgeführt werden kann?<\/P>

Finde mehr Beiträge mit dem Tag

Accepted answers

AdamCrateau

Thanks Tim, I did indeed get this working using the ArcGIS connector.

My flow in Power Automate uses the Sharepoint [When an item is modified] trigger to pass the updated row to the hosted feature service using the ArcGIS [Update a record in a feature layer] action.

I found that I needed to be the owner all of the resources, including the SP List, hosted feature layer and flow to make it all work.

All comments

TimLohnes1

Yes, there is an intermediary step between knowing there is a change and updating the hosted layer. See attached.

1. When an item or a file is modified

2. Get changes for an item or a file

3 Update a record in a feature layer

That will do all changes. I'm only usually looking for certain changes, so after step 2, I put a condition in to check if the Status column has changed and then if the status column = a certain value. If those things are valid, I make changes to the layer. That may or may not be useful depending on what you are doing. In this case the flow fires a lot more (whenever there are list changes) than updates to hosted feature layer take place. Because if the status isn't what I want the flow just does nothing. So it can be confusing when reading the logs as it runs often.

PowerAutomate_UpdateHostedLayeronListChanges-01.jpg

jcokin1

Yes, would be interesting to see the Power Automate workflow @ACrateau.

JeremyMiller

Can you share an example of your Power Automate workflow? Is there an intermediary step between the [When an item is modified] step and the [Update a record in a feature layer]? I want to JOIN the Sharepoint list and feature layer based on a certain field and update other fields in the feature layer with the changes from the Sharepoint list.

Thanks

AdamCrateau

Thanks Tim, I did indeed get this working using the ArcGIS connector.

I found that I needed to be the owner all of the resources, including the SP List, hosted feature layer and flow to make it all work.

TimLohnes1

Hi,

Hopefully you got this squared away. I was using survey123 trigger to create a new list, but just glancing and it looks like there are 3 feature layer triggers in power automate related to agol.

When record is created in feature layer
When record is deleted in feature layer
When record is updated in feature layer.

So looks like this will keep your list updated. Doesn't seem like a connection per se, but at least your 'copy' list will reflect the data in your agol layer.

-Tim

Nimm an der Unterhaltung 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.