I have a screen with a gallery that shows a list of contracts (datasource: SharePoint). I would want to show only the active ones, so I created a calculated column ("Contract Status") in SharePoint that checks the start date and end date. The possible values of this column is "Active Contracts" and "Inactive Contracts." In my PowerApp screen, I added a dropdown filter also with the items "Active Contracts" and "Inactive Contracts."
I see the delegation warning in my gallery, but upon checking the documentation on delegations (from here) it seems that my formula should be correct? Is it because of my calculated column? Appreciate any suggestion to modify my current set-up or any explanation as to why this is. Thank you!!
Yes, I believe the issue is the calculated column (LookUp columns also cause delegation problems).
You could try using a Flow (Power Automate) to populate a 'real' Acitve column whenever records are added or modified, but note that the flow will run on a cycle something like every 3 or 4 minutes, so it may take a while for the Active column to be updated. This may or may not be an issue depending on your scenario.