<!-- Step 1 - Retrieve distinct values in status reason or option set field from all records in Dataverse -->
{% fetchxml statusreason_query %}
<fetch distinct="true" >
<entity name="musdyn_track" >
<attribute name="statuscode" />
</entity>
</fetch>
{% endfetchxml %}
<!-- Step 2 - Populate the HTML form control akak dropdown list, using the numeric option set value as value and the option set label as label
Note - this is comparing each status reason in this query to the selected status reason in the main query, a list of music tracks -->
<select id="statuscode">
{% for statusreason in statusreason_query.results.entities %}
<option value="{{ statusreason.statuscode.value }}" {% if statusreason.statuscode.value == trackresult.statuscode.id %}selected{% endif %}> {{ statusreason.statuscode.label }}</option>
{% endfor %}
</select>
<!-- Step 3 - Example format to update the field using the Portal Web API -->
"statuscode": $('select[id="statuscode"] option:selected').val()
