Count of rows for current user only

(0) Share

Report

Posted on by Mo_Islam

149

Hi,

I have a helpdesk system and created the following dashboard. However, all the counts work based on filters for ALL users except for 'My Cases' which only works for me and nobody else.

The filter I have for My Cases is:

CountRows(Filter('Complaints Manager Archive',Lower(Case_x0020_Handler.Email) = Lower(varUser.Email))

varUser is assigned the users email onStart: Set(varUser, User())

Please can someone help me understand why this works for me but not for anybody else? To be clear, all other users are able to see the counts for everything else except for 'My Cases'.

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

KrishnaV 5,023 on at

Like (0)

Report
Copy link

Link copied!
Hi @Mo_Islam,

I am assuming "complain Management Archive" is a list if not change the formula as this:
CountRows(Filter(SPListName,Lower(Case_x0020_Handler.Email) = Lower(varUser.Email)))

I hope this resolved your issue if you see any challenge let me know I am always happy to help.

Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
Mo_Islam 149 on at

Like (0)

Report
Copy link

Link copied!
Thank you for your prompt response. It is the name of my SP List. I actually managed to get this to work by using the following:

CountRows(Filter('Complaints Manager Archive',Trim(Lower(Case_x0020_Handler.Email)) = Lower(Trim(Office365Users.MyProfileV2().mail)))

I had to add the Office365Users Connector.

Was this reply helpful? Yes No
Verified answer

KrishnaV 5,023 on at

Like (0)

Report
Copy link

Link copied!
Hi @Mo_Islam ,

strange we need not to use Office365Users.MyProfileV2() for this simple thing. However, this pulls down the performance badly so do as this:
App onStart property Set(varUser,Office365Users.MyProfileV2());
and then change the formulas as

CountRows(Filter('Complaints Manager Archive',Trim(Lower(Case_x0020_Handler.Email)) = Lower(Trim(varUser.mail)))

I hope this resolved your issue if you see any challenge let me know I am always happy to help.

Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
KrishnaV 5,023 on at

Like (0)

Report
Copy link

Link copied!

Hi @Mo_Islam,

Hey, if the issue is resolved please mark all the helpful replies as a solution so that others can make use of it.

I hope this resolved your issue if you see any challenge let me know I am always happy to help.

Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
WarrenBelz 154,955 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@Mo_Islam ,
I was going to post here but realised that @KrishnaV has already answered and it is impolite to post while another forum contributor has the matter under control and is answering promptly.

Was this reply helpful? Yes No
Mo_Islam 149 on at

Like (0)

Report
Copy link

Link copied!

Hi, yes I couldn't understand why it would not work either so this way seems to be the only working option with the O365 connector.

Thank you.

Was this reply helpful? Yes No