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 to create a record in AGOL FeatureLayer

GIS_kiwi4

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.

Finde mehr Beiträge mit dem Tag

Content Management

Data and services

Mapping

Accepted answers

alex_mapintel

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

All comments

alex_mapintel

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

GIS_kiwi4

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.

AnninaRupe1

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.

DanielArsenault

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 .

File_Screenshots.docx

DanielArsenault

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

AnninaRupe1

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.

PA_Workflow.png

DanielArsenault

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

Geometry2.docx

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.