I have a gallery with a textbox GropuedBy in which have Concat values without duplicated.
In the same page I have another Galery where I have to GroupBy the same Dataset by another value ("Location" instead of "EID")
Gallery Item property 1:
GroupBy(Table1,"EID","DATA")
Text box property 1:
Concat(Distinct(ThisItem.DATA,'EU NAME'),Value, "; ")
WORKING!
Gallery Item property 2:
GroupBy(Table1,"Location","DATA")
Text box property 2:
Concat(Distinct(ThisItem.DATA,'Location'),Value, "; ")
NOT WORKING
The error says "The specified column "Location" doesn't exist. But it does and I have been using it. It only allows me to GroupBy some columns.
Table1= my DataSource
EID= The column I used to GroupBy
DATA= The column I created to unify the GroupBy values
EU NAME= A column with user names to display
Location= The second column I want to use to GroupBy

Report
All responses (
Answers (