I have the following scenario:
I have a screen with a gallery, on the screen I have 4 buttons that filter on a field in my SharePoint list named Status.
When I only place this code in my gallery: Filter('Leave Requests','EmployeeEmail'= User().Email) then indeed, it only shows the items when the field EmployeeEmail equals the email of the current logged on user.
But since I need to be able to filter on the different values on my field Status, I have updated it with the following code for my Items in my Gallery:
If(
IsBlank(vFilter),
'Leave Requests',
Filter(
'Leave Requests',
Status=vFilter
)
)
The above works just fine but I am seeing all items of all my users.
For my All button I have this code onSelect: UpdateContext({vFilter:Blank()})
For my Pending button I have this code onSelect: UpdateContext({vFilter:"Employee Signed"});
So really I need to change it so that it only shows the items of the current logged on user but I have no idea where exactly I need to change my code. Appreciate any help on this.
Cheers!!
