I set up a custom Enterprise 11.3 connector to use Survey123 triggers in Power Automate. I'm running into what seems to be a perennial issue: coded domain values. I'm writing new S123 submissions to Google Sheets, and the domain codes are transferring over, not the values. For instance the Site ID instead of the Site Name. I know there's a get coded domain values connector for Enterprise, but there isn't one for S123. Is there a calculation I can do on the field to get the domain value?
Solved! Go to Solution.
That would grab the 4th option picked in a mutli-select question.
Ah gotcha, the 3rd index. I just went with jr:choice-name(${dayofweek}, '${dayofweek}')
It is grabbing the value, but the user has to have selected 4 options before that value will be grabbed. The order is based on the order the user selects values, not on the display order of the options. It only grabs the 4th choice selected, not all choices up to the 4th value..