Share
Report
167Hi :),
Let's say this is my SPlist:
| Employee | Date | Batch_ID | Status |
| Robin | 09.17.20 | 1 | Approved |
| Robin | 09.01.20 | 1 | Approved |
| James | 09.17.20 | 2 | Approved |
| Robert | 08.13.20 | 3 | Rejected |
| Jessica | 09.02.20 | 4 | Approved |
| Jessica | 09.01.20 | 4 | Approved |
| James | 08.10.20 | 5 | Rejected |
| Robin | 07.26.20 | 6 | Rejected |
Is it possible to create a gallery that will group identical "Batch_ID" and show "User()" and "Status" as label?
And if possible get "from date to date" as a label as well?
Example gallery:
| Robin 09.01.20 - 09.17.20 Approved |
| Robin 07.26.20 - Rejected |
I have managed to group them or distinct on "Batch_ID", but I have not been able to get any more labels/values out of the record.
This is my code that will give the filter result that I want, but not the labels/values of the record.
OnVisible:
ClearCollect(ColProcessed; Filter(SPlist; Status = "Approved" || Status = "Rejected" && Employee.DisplayName = currentUser.FullName))
(2 different attempts) Items:
Distinct(ColProcessed; Batch_ID)GroupBy(Filter(ColProcessed; Employee.DisplayName = currentUser.FullName);"Batch_ID";"Grouped"
Does anyone know how I can solve this?
Thanks ‌‌
Categories:
I have the same question (0)
All responses (
Answers (
