I already told you: you can’t create list of all available applications with InfluxDB query with this approach.
Store only one value in the tag; instead of:
value=x,APPS=APP1,APP2
store it as:
value=x,APP=APP1
value=x,APP=APP2
You may have have a lot of problems (grouping by app, …) with your approach.