Hoping for some advice - we have a Dynamic App with a custom field of type "Pick List" (it is a custom pick list). There are 11 possibilities to chose from and multiselect is available. In querying the app, the field, called "Issue type", returns the data as a numeric value, not as the value seen by users in the list. For example the first five issue types are:

"Incorrect Reporting Date" - this returns a 1 in query results 

"Insufficient Comments" - this returns a 2 in query results

"Tasks/Deliverables not updated" - this returns a 4 in query results

"Report Not Submitted on time" - this returns an 8 in query results.

and so on with the 11th issue type returning a value of 1024.

As we allow multi-select, a user can select a large number of combinations - up to a total number of combinations (if they select all) of 2047.

It appears I need to translate all these 2047 combinations in a case statement to get the actual value of the field to appear, rather than the numeric equivalent, which I am not going to attempt. Ideally I want to see the actual text value in the field so I can interrogate if it contains a particular issue type - eg using the patindex function. Is there an ARB workaround or alternatively can we set this field up some other way (other than obviously restricting the user to single-select, which is not desired) to make reporting on this field do-able?

Sorry in advance if this has been discussed somewhere else,  I looked by couldnt find

thanks