topic Re: "Repeat" data and Microsoft Flow... in ArcGIS Survey123 Questions

"Repeat" data and Microsoft Flow...

DanBihari — Mon, 03 Jun 2019 14:06:48 GMT

I’ve been working with Survey123 and Microsoft Flow to automate an email response once a survey has been submitted. I came across and article (published on Sept. 24, 2018) where it states that one of the limitations will be:

Data from repeats will also be missing in Microsoft Flow at the moment

Has Esri made any advancements in exposing repeating data in Microsoft Flow? Is this still a limitation?

Also, is there a way to expose “select” question data from a submitted survey that does not require me to duplicate questions just so that I can display it in an email. I have so many questions that I have to store answers twice just so that I can get it to work with Microsoft Flow.

Any assistance or direction would be greatly appreciated.

Thank you.

~Dan

Re: "Repeat" data and Microsoft Flow...

joerodmey — Mon, 03 Jun 2019 18:27:12 GMT

Have the exact same problem in Integromat. The only workaround I can think of is make an HTTP call via Integromat or Flow and use REST to hit the related table.

Eagerly await another solution as well.

Re: "Repeat" data and Microsoft Flow...

JamesTedrick — Tue, 04 Jun 2019 23:25:40 GMT

Hi Dan,

As indicated, repeats are not supported within webhooks at this time. Joe does point out a solution on another provider; unfortunately the Flow connector does not include the token information to be able to query the related records yet.

Re: "Repeat" data and Microsoft Flow...

JeffJackson4 — Mon, 17 Jun 2019 12:59:29 GMT

Is there a way to pull the repeat data out of the repeat and place it in a hidden data line within the main workflow to then pull something like an image attachment into a report? This would be helpful if there is such a workaround.

Thanks.

Re: "Repeat" data and Microsoft Flow...

JamesTedrick — Tue, 18 Jun 2019 22:20:11 GMT

Hi Jeff,

It is possible to place information from a repeat into a hidden question by using functions such as join(); that being said, it wouldn't necessarily help get an attachment.