Powerapps Helpdesk - All the records from sharepoint are not showing up - it displays only the records I have created and not my colleague tickets.

[SomMMT]

I created HelpDesk app about 3 months back using the documentation and it was working fine until 2 days back.

I planned to role out internally to my colleagues and I added two of my colleagues as admins to the admin collection list in the app - OnStart

since then the app is not giving me the full list of tickets available in the sharepoint list. The app only shows the tickets I have created and not the tickets my colleagues created under both admin and user login. The situation is similar for my colleagues also. They see only the tickets they created and not the tickets others created.

Any ideas where I need to change the code to show all tickets available in sharepoint which show up for admins login. By the way login for admins and user is working but unfortunately for both logins it shows the same records. 

[Mira_Ghaly]

@SomMMT 

Can you open the Gallery that displays the Tickets and check the Items Property? It might be having like a filtering Condition to the current user

[SomMMT]

The code is as below  

If(isAdmin,Sort(AllTickets,Created,Descending),Sort(Filter(AllTickets,Author.Email = MyProfile.Mail || Author.Claims = MyProfile.UserPrincipalName ),Created,Descending))

[Mira_Ghaly]

@SomMMT 

If(isAdmin,Sort(AllTickets,Created,Descending),Sort(Filter(AllTickets,Author.Email = MyProfile.Mail || Author.Claims = MyProfile.UserPrincipalName ),Created,Descending))

So the above expression checks whether the logged in user is an Admin , if Yes then you can see all the tickets otherwise it is filtered by the logged in user , so if you want all users to see all tickets you need to replace witj

Sort(AllTickets,Created,Descending)

[SomMMT]

I want only the admins to see all tickets and users to see only tickets raised by them.  Hence the logic If(isAdmin,Sort(AllTickets,Created,Descending),Sort(Filter(AllTickets,Author.Email = MyProfile.Mail || Author.Claims = MyProfile.UserPrincipalName ),Created,Descending)) should be working correctly

Unfortunately this logic is not working for admin. It shows up only the tickets raised using user login. As I mentioned in the post it was working correctly but now it is not after adding the additional names to admin. Now whatever I do I can only see the tickets raised by the admin/user (Myself).

[Mira_Ghaly]

@SomMMT 

How are you adding new admins to the admin collection?

they should be in the format email1,email2

[SomMMT]

ClearCollect(AdminList,"email1@Mydomain.com" "email2@Mydomain.com" "email3@Mydomain.com" "email4@Mydomain.com"

[Mira_Ghaly]

@SomMMT

You need to add delimiter comma between each email as below:

ClearCollect(AdminList,"email1@Mydomain.com","email2@Mydomain.com", "email3@Mydomain.com","email4@Mydomain.com"

Try and let me know if this worked for you

[SomMMT]

I already have a delimiter ", " in the code. while typing out here I missed that.