Power Automate workflow using Survey123 Connector

3680
8
Jump to solution
09-21-2023 02:08 PM
Shubhreet
Regular Contributor

Hello Esri Community,

I am pretty new to Power Automate but have been using Survey123 for a while. I am looking to have automatic notification system for a particular response submitted via Survey123.

Is it safe and promising to use Power Automate to create automated workflow using Survey123 connector? Is there a cost to this? 

0 Kudos
1 Solution

Accepted Solutions
rsun_TQB
Frequent Contributor

Hi @Shubhreet,

It's pretty stable, and if you are using it with ArcGIS Online + Survey123 with Microsoft Power Automate, the setup is easier than using ArcGIS Enterprise + Survey123.

Our approach of using Power Automate + Survey123 is to use "Power Automate per user plan" to run unlimited flows using one centralized Microsoft account, and also manage all automations using this account as well. We have 2FA setup for the user, and we also make sure multiple users (IT & GIS) can manage it anytime with security key. This is the best approach for us, but maybe not for you.

You will also have to "refresh" your Survey123 connection every two weeks by reentering credential of the account. The maximum life of access token is 2 weeks by design...so make sure that you set up reminder on you and your team's calendar to refresh before your conneciton is expired.

Moreover, if you're ArcGIS Enterprise user, you need to make sure that Power Automate can reach your "Portal for ArcGIS" from internet. Your IT need to make sure of that. If you have reverse proxy, you need to make sure reverse proxy is funcitoning properly to allow Power Automate to reach to the portal for connection. If you have corporate firewall, you need to make sure that Power Automate can reach to the portal as well.

Finally, please make sure that you do not always use the "latest" version of Survey123 by default of your survey, if it's a very critical online survey/form for your organization. It happened to me that the latest update may cause issue of your survey. However, Esri got it resolved in a week...but we might be lucky like this everytime. There are some trick that you can use Survey123 Beta or url parameter to load "older" version of your survey (version here means Survey123's version such as 3.17/3.18/3.19 etc.). 

I have shared what I have been experienced so far using Survey123 and Power Automate. 

Bonus point here, to use Survey123 Create Report Action, it will cost you ArcGIS Online Credits. However, if you are using it with ArcGIS Enterprise, you do not need to use any credits. I believe it doesn't cost much...but you better double check with your Esri Account Manager. If you're planning to publish your "surveys" publicly, you will need extra technique to make sure security/access token can still be generated for your need. 

Also, you may want to learn deeply regarding how to handle "attachments" from Survey123 using Power Automate. Survey123 has created so many tutorials or blog posts to help people understand how to do it using OneDrive as @IsmaelChivite has taught me so much from his posts.

You can and should compare other "form" centric on the market, but usually many organization has Survey123 included as part of their enterprise agreement...so why not take advantage of this existing powerful solution that you have already paid for. It's also an opportunity to show your organization that GIS is not just "mapping", it's far more powerful than that!

Hope this help a bit 🙂

View solution in original post

0 Kudos
8 Replies
WhitneyC
New Contributor

I use Power Automate along with Survy123, and it works pretty well. If you already have Microsoft365 Power Automate should be included, there is a premium version, but what you are looking for sounds pretty easy to do with the basic version by just using the survey123 trigger and then a Condition.

0 Kudos
Shubhreet
Regular Contributor

Thanks for your thoughts @WhitneyC 

0 Kudos
AdrianWelsh
MVP Honored Contributor

We're looking into doing this soon and I found this 8-minute video to be really helpful from Ismael.

https://community.esri.com/t5/arcgis-survey123-videos/survey123-create-report-action-in-microsoft-po...

He then posted another link that is much more recent but it has like an hour long video that I haven't gone through yet!

https://community.esri.com/t5/arcgis-survey123-videos/survey123-tricks-of-the-trade-live-automate/m-...

 

0 Kudos
Shubhreet
Regular Contributor

Thank you @AdrianWelsh for your time and sharing the links. For the time being, I am only looking to have a notification system for a response submitted through Survey123. 

0 Kudos
rsun_TQB
Frequent Contributor

Hi @Shubhreet,

It's pretty stable, and if you are using it with ArcGIS Online + Survey123 with Microsoft Power Automate, the setup is easier than using ArcGIS Enterprise + Survey123.

Our approach of using Power Automate + Survey123 is to use "Power Automate per user plan" to run unlimited flows using one centralized Microsoft account, and also manage all automations using this account as well. We have 2FA setup for the user, and we also make sure multiple users (IT & GIS) can manage it anytime with security key. This is the best approach for us, but maybe not for you.

You will also have to "refresh" your Survey123 connection every two weeks by reentering credential of the account. The maximum life of access token is 2 weeks by design...so make sure that you set up reminder on you and your team's calendar to refresh before your conneciton is expired.

Moreover, if you're ArcGIS Enterprise user, you need to make sure that Power Automate can reach your "Portal for ArcGIS" from internet. Your IT need to make sure of that. If you have reverse proxy, you need to make sure reverse proxy is funcitoning properly to allow Power Automate to reach to the portal for connection. If you have corporate firewall, you need to make sure that Power Automate can reach to the portal as well.

Finally, please make sure that you do not always use the "latest" version of Survey123 by default of your survey, if it's a very critical online survey/form for your organization. It happened to me that the latest update may cause issue of your survey. However, Esri got it resolved in a week...but we might be lucky like this everytime. There are some trick that you can use Survey123 Beta or url parameter to load "older" version of your survey (version here means Survey123's version such as 3.17/3.18/3.19 etc.). 

I have shared what I have been experienced so far using Survey123 and Power Automate. 

Bonus point here, to use Survey123 Create Report Action, it will cost you ArcGIS Online Credits. However, if you are using it with ArcGIS Enterprise, you do not need to use any credits. I believe it doesn't cost much...but you better double check with your Esri Account Manager. If you're planning to publish your "surveys" publicly, you will need extra technique to make sure security/access token can still be generated for your need. 

Also, you may want to learn deeply regarding how to handle "attachments" from Survey123 using Power Automate. Survey123 has created so many tutorials or blog posts to help people understand how to do it using OneDrive as @IsmaelChivite has taught me so much from his posts.

You can and should compare other "form" centric on the market, but usually many organization has Survey123 included as part of their enterprise agreement...so why not take advantage of this existing powerful solution that you have already paid for. It's also an opportunity to show your organization that GIS is not just "mapping", it's far more powerful than that!

Hope this help a bit 🙂

0 Kudos
Shubhreet
Regular Contributor

Hello @rsun_TQB, Thanks much for your time and sharing detailed information that might be helpful down the road. Our organization currently uses ArcGIS Online. I am planning to use the Power Automate free license that I already have from my organization to accomplish the automatic notification task. Does Survey123 connection needs to be refreshed every 2 weeks when using with ArcGIS Online?

0 Kudos
abureaux
MVP Frequent Contributor

I'll be as honest as I can...

I have used Power Automate to automate S123 for a (newly) multinational company for the last ~2.5 years. I have ~300 automations set up for various purposes. A large number of those automations are rather complex as to support high-level business operations.

I have encountered the odd issue/error that causes unexpected/unexplained failures, but some simple error handling auto-corrects those. The biggest hurdle I've encountered was when Esri releases updates that break things. They typically fix those mistakes with ~24 hours. Definitely the most stressful times...

Overall, I am quite happy with the level of redundancy, security, and reliability. While I haven't done an official up-time calculation, we are definitely way up there since my record of downtimes is almost non-existant this year (beyond my regular EOM maintenance).

They really simplified the automation process for Enterprise this year as well, which is nice.

0 Kudos
Shubhreet
Regular Contributor

Thanks much @abureaux  for your thoughts. After reading your reply and replies from other contributors, I feel like Power Automate is a very good option for automatic notifications. 

0 Kudos