topic Survey123-Integromat Extract email value in ArcGIS Survey123 Questions

Survey123-Integromat Extract email value

GeorgeFloros1 — Mon, 10 Feb 2020 14:40:13 GMT

Hello,

I have been able to connect Survey123 and Outlook via Integromat and I can successfully send an email when I enter the email address manually.

In my survey, I have built it so the user can select from a pre-defined select_one list the email address he wants to forward the survey to.However, Integromat does not read the value/label (i.e the email address) but reads the "name" of the choice(i.e. approvalpersonA). As such it fails.

Any ideas on what am I doing wrong?

Thank you,

George

Re: Survey123-Integromat Extract email value

Jim-Moore — Wed, 12 Feb 2020 05:31:01 GMT

Hi George

As you've discovered, a survey's webhook payload will only contain the name (domain value) for a selected choice, not its label. This is by design (the underlying data in the feature service is sent by the webhook).

A workaround for this is to use the jr:choice-name function to write the label of the selected choice to a (hidden) text question. You can then access the answer text question in Integromat.

For example, for a select_one question called "email" you could use a calculation like:

jr:choice-name(${email}, '${email}')

Re: Survey123-Integromat Extract email value

GeorgeFloros1 — Thu, 16 Apr 2020 09:50:40 GMT

Thank you Jim! Exactly what I was looking for!

Kind regards,

George