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

Sharepoint-Liste mit Geometrie im Esri JSON-Format hinzufügen

RaajRaaj

In der ArcGIS for Sharepoint 2022.2 Version können Benutzer auch Sharepoint-Listen oder Dokumentbibliotheken hinzufügen, die Geometrie im Esri JSON-Format enthalten.
Was ist ein Esri JSON-Format?<\/STRONG>
Esri-JSON kodiert sowohl Geometrie- als auch Feature-Informationen in Objekten. Gültige Geometrietypen sind Punkte, Polylinien, Polygone, Umschläge und Mehrfachpunkte.
Wie erhalte ich die Daten im Esri JSON-Format?<\/STRONG>
Angenommen, ich habe einen ArcGIS Online Feature Layer und möchte die Daten in eine Sharepoint-Liste exportieren.
Ich kann einen Flow in Power Automate einrichten, der den Esri "Get data from feature layer" Connector verwendet und die Daten in eine Sharepoint-Liste exportiert.
Für das folgende Beispiel erstelle ich eine leere Liste in Sharepoint mit zwei Spalten: die Spalte "Office Name", die mit dem "Office Name" gefüllt wird, und eine zweite Spalte "Shape" (Spaltentyp: Mehrere Textzeilen), die mit der Geometrie im Esri JSON-Format gefüllt wird.<\/P>Hinweis: Wenn Sie eine Spalte in einer Sharepoint-Liste erstellen, um die Geometrie im Esri JSON-Format zu speichern, verwenden Sie bitte "Mehrere Textzeilen" als Spaltentyp.<\/P><\/TD><\/TR><\/TBODY><\/TABLE>
Wenn Sie den ArcGIS Connector "Get data from feature layer" in Power Automate verwenden, können Sie Feature Layers auswählen, die in Ihrer ArcGIS Online Organisation gespeichert sind, um die Geometrie im Esri JSON-Format zu extrahieren (Ausgabeformat "JSON" wählen) und für den Parameter "Return Geometry" "Ja" auswählen. Für den im folgenden Beispiel verwendeten Feature Layer kann ich anhand der Metadaten des Layers sehen, dass die Geometrie im Esri JSON-Format gespeichert wurde. Ich kann nun das Shape-Feld extrahieren und in eine Sharepoint-Liste exportieren, die später dem Karten-Webpart auf einer Sharepoint-Seite hinzugefügt werden kann.
Die folgende Bildschirmaufnahme zeigt Schritt für Schritt, wie man den Power Automate Flow einrichtet und die Geometrie im Esri JSON-Format in eine Sharepoint-Liste exportiert.<\/P> <\/P>https:\/\/players.brightcove.net\/6161463677001\/default_default\/index.html?videoId=6310610323112

Finde mehr Beiträge mit dem Tag

Kommentare

AndrewWalker3

Hello, Thanks for the video and pointers.

I tried out this flow, it appears to work, pulls all the attributes from my feature in AGOL into the list. Including what looks like a JSON for the Shape.

but I get an error in sharepoint "The selected column doesn't contain any valid JSON geometry"

Any idea why?

my Shape column has this as an example:

{"rings":[[[1634982.61335695,7380760.53151438],[1634976.8421821,7380761.35197642],[1635015.95253566,7380985.71551994],[1635021.69189794,7380984.71076092],[1634982.61335695,7380760.53151438]]],"spatialReference":{"wkid":102100,"latestWkid":3857}}

Thanks in advance for any help

RaajRaaj

@AndrewWalker3 - Thanks for your feedback.

Regarding your question, can you check the column type and make sure that you've selected "multiple lines of text"? By default, SharePoint assigns "Single line of text" which has a character limit and it truncates the JSON. Once you change it to "Multiple lines of text", it should work.

Let me know if you have any further questions.

Raaj

AndrewWalker3

Thanks. But actually it is multiple lines. So I don't understand why I have the error.

Anything else to check for?

RaajRaaj

Can you send me the name of the layer? Let me try add it on my end.

AndrewWalker3

Hey RaajRaaj,

i DM you with the name of the layer. Did you get a chance to look?

I have another question on ArcGIS for sharepoint. When you search documents it searches across all sites. is there a way to force it to search in the current site only and remove the options for a user to search across sites.

If we have organised our data into projects in sites we would NOT want users for that site being able to search other sites.

RaajRaaj

Hi Andrew,

I just checked my inbox this AM and I've responded to your message.

Regarding the "search" functionality, am assuming you are asking about the "geosearch" functionality in ArcGIS for SharePoint? If yes, then its possible, but I would like to get some additional details.

If you'd like the page "viewers" to only be able to geosearch documents within the current site, then the author of the page can check the box next to "Search within current site". Once that box is checked by the map author, the setting gets saved.

But with the above option, viewers will be able to change the "Search" options and uncheck the box.

If you dont want to let the viewers to uncheck the box, then the other option is to let the author of the SharePoint page to check that box and once that box is checked, viewers will not be able to uncheck it. If you think this is a viable solution, then we need to address this in a future release and I would need to talk to my team and get back to you on when we can push this to Production.

Let me know your thoughts?

Raaj

AndrewWalker3

Thanks Raaj,

Yes i had been using the search site only button. But I don't want users to be able to uncheck this.

It would be good if I checked this inside "edit mode" then it could be fixed and greyed out for users. The issue for us is that with this unchecked users can actually search documents on other sites (they should not be able to see) if they happen to have similar enterprise keywords or terms associated.

Andy

RaajRaaj

Got it! I will work with my team and will let you know on when we will be able to push this to Production.

Thanks,

Raaj

AndrewWalker3

Also Raaj. I made the layer public for you to check on the power flow.

Andy

RaajRaaj

@AndrewWalker3 - I tried adding the layer and when I look at the layer's metadata, I don't see the Shape field exposed which I need to use in the Power Automate flow to extract the JSON.

AndrewWalker3

@RaajRaaj

I used "geometry" in my flow

flow esri.PNG

and i get the data into my sharepoint list like this:

RaajRaaj

@AndrewWalker3 - Thanks for the screenshot. I was able to use the "geometry" column and extract the JSON into a Sharepoint list and then I was able to add the SP list to a map without any issues.

AndrewWalker3

ok,

i tried from scratch again with a new list with just the title and shape and it worked.

It might have been due to it already being an existing list which I copied from an excel. Might have had an issue with the column not being formatted to multiline like you said originally. (even though I did check it)

Thanks for the support

Andy

RaajRaaj

You're welcome! 🙂

dcallaghan

Hi there,

Thanks for providing this overview! Is there any chance of providing the video in a less pixelated format? It's quite difficult to see what you are actually demonstrating in it.

Alternatively, can you link to written documentation for accessing the geometry of a feature layer with this method? Your post seems to be the only thing on the internet with any information or guidance on what an esriJSON is or how one can use it, irrespective of whether it's being used within Sharepoint or not.

RaajRaaj

@dcallaghan -

Here's the link that explains how to convert features to Esri JSON.

https://pro.arcgis.com/en/pro-app/latest/tool-reference/conversion/features-to-json.htm

Let me know if this helps?

Also, I will send you the videos within an hour or two.

Thanks,

Raaj

RaajRaaj

@dcallaghan - Here's a high resolution video. Let me know if you have any questions.

Thanks,

Raaj

Stefan_Bazar123

Hello,

I'm trying to reproduce the format listed here in arcgis for excel without any success. Actually, it seems incredibly glitchy.....Can you update this post to include more information about data prep to have ESRI JSON objects work? I couldn't find anything.

RaajRaaj

@Stefan_Bazar123 - This flow that I've explained in the blog is meant for Sharepoint lists. Do you want the steps to set up a similar flow that can work with Excel?

Thanks,

Raaj

Stefan_Bazar123

yes I think that would be very helpful. Or just more information on how to format ESRI JSON

RaajRaaj

@Stefan_Bazar123 - Could you please share the workflow steps and the step where you are encountering the formatting issues so that I can better assist (with some screenshots, if possible)?

Thanks,

Raaj

Nehmen Sie an der Diskussion teil

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

Schnellzugriffe

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