Answered

Filtering behaves differently based on user logged in

(0) Share

Report

Posted on by alietzau

I have an issue filtering a SharePoint List on a DateTime column, but it only happens on certain user accounts.

The image below shows the table I'm having issues filtering. The DataTable shown at the bottom shows all items in the list. The number at the top is a count of the items that share the same maturity date. The code for this count is - CountRows(Filter(SPList, Maturity Date = DataTable.Selected.MaturityDate))

Power Apps Filtering.png

I only have issues filtering this SharePoint List on the Maturity Date column. All other columns filter properly. I don't know how to troubleshoot this issue because filters that are working for one user are not working for others. I'm looking for suggestions or if anyone else has seen this issue when building apps.

Thank you!!

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

WarrenBelz 154,399 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @alietzau ,

Firstly, the code seems correct. Data Tables are not the most friendly tool to use, try a gallery instead for a test and see if this works for all users.

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Verified answer

alietzau on at

Like (0)

Report
Copy link

Link copied!

So I hate that this is the solution because it doesn't make sense or explain anything. I removed the affected user from the site collection that hosted the SharePoint list and then added them back to the site. For whatever reason, this resolves the issue that they had.

I don't know what happened to the user that makes this issue appear and I couldn't recreate it after resolving the issue. In case someone else has an issue like this, try removing the user entirely from the site collection and then add them back. Should fix it.

Was this reply helpful? Yes No