topic Re: Survey123 plus Power Automate and Workforce (on ArcGIS Enterprise) in ArcGIS Survey123 Questions

Survey123 plus Power Automate and Workforce (on ArcGIS Enterprise)

DfIRivers — Mon, 15 Jan 2024 19:23:39 GMT

The following describes our deployments which is based on ArcGIS Enterprise 10.8.1.

I have a Survey123 Connect survey (Survey1) which is used by our industrial staff for asset inspection. The asset inspections includes identification of any additional works (i.e. assignments).

We are planning to deploy Workforce to manage assignments, and based on the blog article at:
https://www.esri.com/arcgis-blog/products/workforce/field-mobility/workforce-survey123-creating-assignments-field/
I have set up a separate Survey123 survey (Survey2) that can be used (by our technical supervisors) to initiate new assignments (unassigned) to Workforce.

We have also deployed Power Automate, so that when 'Survey1' asset inspections are recorded that include any additional works.. then a message is sent to an MS Teams channel (potentially to alert the Workforce Dispatcher).

My question is whether its possible to use Power Automate to pass new assignments from my original survey (Survey1) to the Workforce service... if this isn't possible, I guess the alternative would be to remove the works identification from Survey1 and get our industrial staff to use Survey2 to get the new assignments into Workforce.

I note that there is some discussion around this within the community post at:
https://community.esri.com/t5/arcgis-survey123-questions/editing-multiple-feature-services-in-a-single-form/td-p/829426
that suggests that a solution may be possible.. but the post is from 2018, so perhaps there has been updates since then?

Grateful for any insights/advice.

Re: Survey123 plus Power Automate and Workforce (on ArcGIS Enterprise)

abureaux — Mon, 15 Jan 2024 23:25:01 GMT

Power Automate has new connectors for both AGO and Enterprise that may be of help. Have you looked into those yet (they weren't around in 2018)?

Workforce is still on my To Do list, so I haven't had time to seriously get into it yet.

Re: Survey123 plus Power Automate and Workforce (on ArcGIS Enterprise)

DfIRivers — Tue, 16 Jan 2024 09:50:28 GMT

Hi @abureaux ,

thanks for reply.. we are using a custom connector to connect to surveys on our ArcGIS Enterprise platform, created using guidance at link below..
https://support.esri.com/en-us/knowledge-base/how-to-create-an-arcgis-survey123-connector-for-microso-000025025

Wasn't able to get the Power Automate ArcGIS Enterprise connector to work.

Re: Survey123 plus Power Automate and Workforce (on ArcGIS Enterprise)

abureaux — Tue, 16 Jan 2024 16:39:18 GMT

Did you get any errors with the connector? I am trying recall making the ArcGIS Enterprise Connector, and I don't remember there being anything too involved (at least compared to the Custom Enterprise connection, which you indicated you've already made).

If it isn't anything on the Power Automate Connector side or the Portal application side, my only thought would be a CORS issue (but if the Custom Connector is working, so to should this one).

I know this deviates a little from your initial question, but I'd think that this new connector should do what you are looking for. Assuming we can get it working.

Re: Survey123 plus Power Automate and Workforce (on ArcGIS Enterprise)

DfIRivers — Tue, 16 Jan 2024 19:25:25 GMT

We've tried to configure the default ArcGIS Enterprise connector numerous times and been unable to get the connection created. Its taken us months to get the custom connector working even with assistance from local ESRI office. There seem to be security blocks on the WAF which affect our ability to get ArcGIS Enterprise to behave as its supposed to.

Screen shot below shows configuration screen for the ArcGIS Custom Connector.. Are there other Actions that would allow a 'Post to a feature service' that can be added to this connector, or that would be available if the default ArcGIS Connector was worked?

Re: Survey123 plus Power Automate and Workforce (on ArcGIS Enterprise)

abureaux — Tue, 16 Jan 2024 22:20:18 GMT

The Custom ArcGIS Enterprise Connector (pictured above) only has the capabilities you see listed under it. It isn't possible to add any additional functionality to this connector. That is where the confusingly named ArcGIS Enterprise Connection comes in, by allowing you access to things like Feature Layers.

Unfortunately I won't be able to help with any WAF issues. It's always a struggle to get IT on the same page, and it took us a good year of back-and-forth to get things into a good state where both us and our IT department are happy.