Share
Report
37Hi all! Maybe you can help med figure out whats going on here, I have a gallery in a gallery and I am seing some items that should not be in the collection.
I have a vertical gallery cointaining the blue paint thing and then a horizontal gallery inside cointaining text the outer gallery items propety is PersonsLeave and the inner property is ThisItem.leaveReasons. I am trying to filter leaveReason to only contain one element "Beredskap" here is my code for collection the collection.
ClearCollect(
PersonsLeave;
AddColumns(
Distinct(
LeaveRow;
Person
);
"IsInView";// Namnet på din nya kolumn
If(
true exactin ForAll(
Sequencelist As seq;
Text(
DateAdd(
varfirstDayView2;
seq.Value;
TimeUnit.Days
);
"yyyy-mm-dd"
) exactin ShowColumns(
Filter(
LeaveRow;
Person = Value
);
"cr6ea_name"
)
);
true;
false
);
"Avdelning";
'Office365-användare'.UserProfile(Value).Department;
"Chef";
'Office365-användare'.ManagerV2(ThisRecord.Value).mail;
"leaveReasons";
ShowColumns(
Filter(
LeaveRow;
Person = Value And LeaveReason = "Beredskap"
);"cr6ea_leavereason")
)
);;
The last leaveReasons should only contain "Beredskap" and it seems like it does if I got to Variables section
But as you can se in my first screenshoot other values are also displayed..
Does someone now what going on here?
Categories:
I have the same question (0)
All responses (
Answers (
