Unanswered

Unable to access data Survey123 Enterprise

(1) Share

Report

Posted on by Michael_V

I am trying to use Power automate to create a feature report as well as fill in an excel table with data from the Survey. I am using my Enterprise account with MA and the connection works. My issue is that I get no dynamic content with responses from the Survey. I do get some general info from the survey (account name, user names, portal ids, URLS, etc). I do not get the dynamic content for the questions in the survey (the data I need). I have use Integromat in the past with great success, has anyone successfully moved response data from a Enterprise Survey123 through Automate?

Thanks

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

NorbertoQuinone 4 on at

Like (0)

Report

Found this article that solves the issue.

https://support.esri.com/en/technical-article/000022795

Was this reply helpful? Yes No
Ben_C_GIS 12 on at

Like (0)

Report

It is my understanding that PowerAutomate's Survey123 connector only works with your org's AGOL accounts, not your org's Portal/Enterprise for ArcGIS accounts, which is annoying. I had to remake the one I initially made for us in Portal so that I could get the webhooks to work. This sounds like a different problem than the one you ran into but I figured was relevant.

Was this reply helpful? Yes No
Michael_V 10 on at

Like (0)

Report

Hi Ben,

I was able to get PA to link with Enterprise, the process is a little complicated but it does work when you get everything sorted out. This article got me sorted out https://support.esri.com/en/technical-article/000025025
There are some issues with the data coming from Survey123, you do not get the feature service attributes as options in PA (dynamic content) , you end up having to use a call for each attribute (survey question) you want to pull the data from. You end up having to write triggers for each attribute which is time consuming. In my situation I wanted to pull survey123 data into an excel file, so after creating columns for every Survey123 data attribute I wanted, in PA you have to go through each one, choose the expression tab in the dynamic content popup and then enter a code similar to this triggerBody()?['feature']?['attributes']['inspector_name']. This will now pull the data from whatever attribute field you put into the last [''] of the code.

Overall the process is time consuming and when it breaks you have to do a lot of copy and pasting. If I had the option I would be using Make (formerly Integromat) to do this data pull but unfortunately my company does not allow it and PA was my only option. I believe PA works a little better with ArcGIS Online but again I am restricted to Enterprise so I had to get creative. Hopefully this helps you if you are in a similar situation.

Was this reply helpful? Yes No