When feature is created, automatically copy feature to different feature layer

[Bud]

When a point feature is created via a Survey123 form in a feature layer (FL1 - a permanent record of unedited survey results), I want to automatically copy the feature to a different feature layer (FL2). A user will then take the point in FL2 and edit/clean it up/change the status for the purpose of displaying it on a public web map.

Question: When a feature is created in FL1, how can I automatically copy it to a different feature layer (FL2)?

My organization doesn't have any automation software/licenses, other than Office365 (and ArcGIS Enterprise). All of this data is hosted in AGOL. I'm looking for a dead-simple, reliable, no-cost solution, since this is just a small project.

Related: 

• Upon feature creation, use webhook to copy feature to different feature layer
• Idea: Built-in AGOL mechanism — Upon feature creation, copy to different feature layer

[Katie_Clark]

If it's just a matter of visibility/permissions, could you use a view layer for the public web map that has editing disabled?

Otherwise, my first thought goes to using ArcGIS Notebooks, could probably script something to do this.

[Bud]

@Katie_Clark  ...using ArcGIS Notebooks, could probably script something to do this.

Do you think my organization would need to purchase ArcGIS Notebook Server to run the notebook on a schedule?

[Katie_Clark]

Ah, I had just assumed ArcGIS Online, but yes, if you're working with Enterprise, I believe you will need Notebook Server. 

[Bud]

@Katie_Clark 

My bad, I'm using AGOL, not Enterprise. I should have known that AGOL wouldn't need Notebook Server.

Is there a mechanism in AGOL to run notebooks automatically, on a schedule or on a trigger?

[Katie_Clark]

Yes, you can schedule Notebooks using Tasks. A relevant limitation listed in that documentation is that the maximum frequency a scheduled task can run is every 15 minutes. So if you went this route, your second feature layer would get updated in batches based on the schedule, not every time a record was submitted to the survey. However, if you were actively working on the second layer and needed to sync things, you could manually trigger the Notebook and have it run.

There isn't a built in mechanism for triggers in the Notebooks, but you could possibly utilize PowerAutomate for webhooks with Survey123 to trigger a script. 

[JonathanMcD]

@Bud 

Have a wee look at Data Pipelines - you can easily create scheduled processes which can also help with some of your data standards too.

[Bud]

One option could be to abandon AGOL and recreate the project in Enterprise instead. Use attribute rules or Oracle database triggers in the enterprise geodatabase to satisfy this need. Serve the form and other items up to the public in Portal.

And possibly use a Distributed Collaboration between Enterprise and AGOL if needed?

• Set up an ArcGIS Enterprise and ArcGIS Online collaboration
• About distributed collaboration

[Bud]

Here’s a video showing how to send an email when a Survey123 feature is created, using a web hook and Power Automate.

YouTube: Setup Webhooks in ArcGIS Survey123 using Microsoft Power Automate (Esri Canada)

As others have suggested, I imagine something similar could be done to create a feature in a different feature layer.