topic Re: Power Automate to create a record in AGOL FeatureLayer in ArcGIS Online Questions

Power Automate to create a record in AGOL FeatureLayer

gis_KIWI4 — Wed, 05 Jul 2023 02:30:07 GMT

Hi,

We have a sharepoint list that we'd like to replicate in the AGOL via power automate.

The hurdle for us how do we set up the "Create a record in a feature layer" connector. We have tried passing the "geometry" parameter multiple ways. We have tried -

x,y

AND

"geometry": {
"x": 1436052.3270733608,
"y": 5002615.309330223,
"spatialReference": {
"wkid": 2193,
"latestWkid": 2193
}

The flow runs fine and creates the feature but with no geometry.

Anyone used this connector before, that might have an idea?

Also there is surprisingly low information on these connectors and the format of the inputs they expect.

Re: Power Automate to create a record in AGOL FeatureLayer

alex_mapintel — Wed, 05 Jul 2023 04:26:21 GMT

A quick glance at your json object looks like you have 2 opening brackets "{" and only 1 closing bracket "}".

Id try this format:

{ "x": 1436052.3270733608, "y": 5002615.309330223, "spatialReference": { "wkid": 2193, "latestWkid": 2193 } }

More details regarding Geometry objects can be found in the Developer Documentation at here

Re: Power Automate to create a record in AGOL FeatureLayer

gis_KIWI4 — Wed, 05 Jul 2023 04:30:48 GMT

Thanks @alex_mapintel , I copied the code incorrectly. It had the brackets.
It also didn't like the keyword "geometry" in the code.

What worked for us was the below -

{ "x": 1436052.3270733608, "y": 5002615.309330223, "spatialReference": { "wkid": 2193 } } OR { "x": 170.8504403060537, "y": -45.360211429819564, "spatialReference": { "wkid": 4326 } }

Thanks again.

Re: Power Automate to create a record in AGOL FeatureLayer

AnninaRupe1 — Fri, 05 Jan 2024 18:36:14 GMT

Thanks for this solution!

Also, in case anyone else is having trouble with this, just copy/paste the code directly into the "Geometry" bar--not the f(x) bar in the Expression window that appears when you click in the "Geometry" bar.

Re: Power Automate to create a record in AGOL FeatureLayer

DanielArsenault — Thu, 16 May 2024 17:46:03 GMT

I have issues with this same thread, looking for help on this one, record gets created fine but no geometry in the new record .... anybody's help is appreciated :).

Re: Power Automate to create a record in AGOL FeatureLayer

DanielArsenault — Thu, 16 May 2024 18:45:07 GMT

Well I figured it out, no need to dig further.

Re: Power Automate to create a record in AGOL FeatureLayer

AnninaRupe1 — Thu, 16 May 2024 18:45:37 GMT

I had to work with Esri to get this situated. I've included a screenshot of the Power Automate workflow.
In "Parse JSON," in "Content" I had to put the Current item from the "For each 3" step and under "Schema," I had to paste the following:

{ "type": "object", "properties": { "attributes": { "type": "object", "properties": {} }, "geometry": { "type": "object", "properties": {} }, "changeType": { "type": "string" } } }

Then, in the "Create a record in a feature layer" step, under "Geometry," open the "Insert function" box and then click on the Dynamic content tab in that box. This will give the option to choose and add "Body geometry" from Parse JSON.

I think that should make it work.

Re: Power Automate to create a record in AGOL FeatureLayer

DanielArsenault — Thu, 16 May 2024 19:32:04 GMT

ah yes that's good, thanks for sharing. Below is how I achieved the result.