You can get around it the 5,000 record limit when FILTER by indexing the column you want to apply the filter on.
Start with SharePoint but consider a move to SQL if you can't overcome these 2 obstacles
Keep in mind if for SQL every user of the app will require a premium license @ $10 per app or $40 for unlimited apps.
Link To MS Blog Post Verifying My Claim
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!