topic Re: Power Automate - no dynamic content in ArcGIS Survey123 Questions

Power Automate - no dynamic content

KG_427 — Thu, 04 May 2023 15:37:48 GMT

Hello, I have a flow to add a new survey response to an excel table that still works, but I can no longer edit the Flow with dynamic content. I cannot create a new flow using this survey. It appears it may be related to having a map question in the survey as surveys without maps show dynamic content, however, I was able to configure the survey with the map in there originally.

Is this a bug and if so, will it be fixed? Is there a work around in the meantime to get dynamic content from a survey with a choose your location question?

Re: Power Automate - no dynamic content

abureaux — Thu, 04 May 2023 15:52:49 GMT

Hello,

Is this for AGO or Enterprise? For Enterprise, this should not be related to the map question (I have numerous surveys with all question types in Power Automate that work properly). If this is for AGO, then there may be an issue with the new custom connectors.

The things that immediatly come to mind:

Permissions changed for the survey. Ensure that the survey is shared with the appropriate people/groups
Enterprise: Something changed with your connection. In Power Automate, go to Data > Connections > find you S123 connection > Click the ellipses (...) > click Switch account > log back in

Re: Power Automate - no dynamic content

SusanHmel__DOIT_ — Mon, 08 May 2023 20:12:25 GMT

Where is your survey created - through Survey123 Connect or the webpage designer?

We ran into this issue with Power Automate and Survey123 forms authored in Survey123 in ArcGIS Online.

Survey123 forms authored with Survey123 Connect did not have this issue for us and could generate dynamic content. We reached out to ask about this and found that it is currently a bug:

BUG-000115734
Status : Known Limitation

Synopsis: Adding workflow automation such as Microsoft Flow and Integromat as WebHooks to surveys created in the Survey123 for ArcGIS website do not recognize the field or choice names designed in the survey

BUG-000133012
Status : Known Limitation
Automated emails generated using Microsoft Power Automate do not retain choice labels within multiple-choice questions in ArcGIS Survey123.

Re: Power Automate - no dynamic content

abureaux — Tue, 09 May 2023 14:57:53 GMT

Ahhh. Thanks for the info! Honestly, I always forget that the web-based forms exist.

Re: Power Automate - no dynamic content

KG_427 — Wed, 10 May 2023 18:00:43 GMT

Hi Susan, yes, it was created in the webpage designer. Thank you for letting me know about the bug! I have found we can remove the map question, configure the dynamic content, add the map back, and the flow works as expected. It's not ideal, but it can work.

Re: Power Automate - no dynamic content

cnw_ivesleung — Thu, 25 May 2023 18:14:47 GMT

I am also having the same issue when building new flows but the workaround that worked for me was that I hovered my cursor to a dynamic content of an older flow so it shows an expression (e.g. triggerBody()?['feature']?['result']?['objectId']) - Pic below. So I entered that expression in a similar format and run the flow, the expression turns into dynamic content.

So if you know which attributes to pull, you can give this a try.