
Dear team,
I am building a Helpdesk application. The sharepoint list has a "Assigned to" column. Technician will be assigned to the ticket with his email id.
I am trying to display the tickets in Gallery by applying filter of the technician email id. But for some reason i am not able to display it.
I have a set a variable On App Start as set(varuser, user.email())
On the Gallery Item property, i have given as Filter(helpdesk, 'Assigned to' = varuser)
But i am getting an error. Please guide. I have also added the connection Office365.Users .
When i display the varuser in label, it displays the email id properly.
Hi @venka91 ,
Please use the below formula.
Filter(helpdesk, 'Assigned to'.Email = varuser)
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.