Survey123-Integromat Extract email value

650
2
02-10-2020 06:40 AM
GeorgeFloros1
New Contributor II

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

0 Kudos
2 Replies
Jim-Moore
Esri Regular Contributor

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}')

More on this function here:

Formulas—Survey123 for ArcGIS | Documentation 

XLSForm essentials—Survey123 for ArcGIS | Documentation 

Cascading and external selects—Survey123 for ArcGIS | Documentation 

Hope this helps

Best,

Jim

GeorgeFloros1
New Contributor II

Thank you Jim! Exactly what I was looking for!

Kind regards,

George