
Announcements
Hello,
I was wondering if anybody could help me with an issue I am having.
When a requester submits a request, I have a gallery that shows that request to only his manager (Gets info from 365 environment) and depending on which 365 group the requester belongs to, it also shows it to one of two people that have access to that specific group.
From the managers side it works perfect because it shows the data as it should like the below
But when the other user goes in which he should be able to see it because the requester belongs to the same group, that is what he gets. A scrolling bar that implies there more data in there and it looks like this:
This is what I have under "Items" in this gallery:
SortByColumns(
If(
varUser.Email = testuser1@test.com,
ForAll(
Filter(
ExpenseMaster,
ExpenseStatus = "Submitted"
),
If(
RequesterEmail in Goup1Members.mail,
ThisRecord
)
),
varUser.Email = testuser2@test.com,
ForAll(
Filter(
ExpenseMaster,
ExpenseStatus = "Submitted"
),
If(
RequesterEmail in Group2Members.mail,
ThisRecord
)
),
Filter(
ExpenseMaster,
ExpenseStatus = "Submitted" And ApproverEmail = varUser.Email
)
),
"ID",
Descending
)
Any help would be really appreciated.
Thank you.