Hi,
I have a gallery list listing employees and their ID. I used a Groupby function to group the multiple entries since there is more than one entry per employee in the excel data source (temporary).
This is the following code from my groupby and filter
here is a snippet from my code building the gallery
GroupBy(
Filter(
Sort(
Source;
SnapshotDate;
Descending
);
ManagerID = IDtextbox
);
"EmployeeID";
"Data"
)
However, when I try to add a datetime element in my gallery (using thisitem.data). It gives me an error because I have to send it a text value.
Example: ThisItem.Data.Snapshotdate returns me an error.
Is there a method of formating that could allow me to call the snapshot date through the groupby?
