Power Automate
Query Any SharePoint List from Power Apps with a Power Automate Flow Broker
A Power Apps data source is fixed at design time, and every one you add counts against the app's connection budget. A flow broker avoids both limits. The app sends a small request to one Power Automate flow, the flow calls SharePoint, and the app gets rows back