
This is strange. I've had a SharePoint list for months that has been working great. Overnight, I'm having issues filtering all my calculated columns. My calculated columns are basic IF statements based on other columns. When I attempt to filter, it correctly registers all my options. As you can see in the picture, there are fields of "Complete"
But when I select a filter and apply it, no results are found!
This problem was first noticed earlier this week. Has there been a SP upgrade that could cause this? Any suggestions on how to fix?
Hi @eiserb ,
I am surprised they have actually worked as you expected until now. SharePoint calculated columns are at best unreliable and should be avoided using with Power Apps. Simply do the calculation in Power Apps using AddColumns().
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.
MVP (Business Applications) Visit my blog Practical Power Apps