Based on an article that I read, https://tbmcouncil.jiveon.com/message/1441 , I don't think there is a quick way of grouping down values and separate them by commas. It suggests the creation of a table transform and then the leveraging of the UniqueValues() formula. I tried it on a table I have on my side and worked.
How I think it could work for you is:
1) Build a table transform out of your applications' raw data
2) From the source dataset table, do a UniqueValues function: SVC Code Concat=UniqueValues(Table Transform:SCV Code[Application Name=Application Name]) . This formula will bring back the SVC Codes in a format with quotation marks:
"SVC1","SVC2","SVC3",etc.
If you want to remove the quotation marks, you need to add the following steps:
3) Add two additional formulas to remove the quotation marks:
- Quotation Mark=Left(SVC Code Concat,1)
- SVC Code Final=Substitute(SVC Code Concat,Quotation Mark,"")
4) Add the SVC Code Final to your HTML component, {various} should no longer show.
It may not be the shortest way, but it works. I hope it helps!