I stumbled across the DataFlows connector. And wow! Our organization used a custom javascript query embedded in Stratus Forms (kudos to Mark Rackley for that). The code was querying a third-party website API to pull in information to be collected as a choice option in a SharePoint field. But... custom development sometimes breaks and I'm just speculating but I don't think Mark supports Stratus Forms anymore - making it a tool we can't continue to use. Additionally... we're on our path to using PowerApps and PowerPlatform to replace custom web forms in SharePoint. I asked myself what connectors I could use to query API data and post them in a PowerApps gallery for use in a form to patch back to a SharePoint list. And I stumbled onto DataFlows . DataFlows are like the - easy to use - Get Data buttons in Excel and PowerBI. Yet, it creates an encapsulated table that you can pass to any PowerPlatform application. I couldn't believe I had stumbled across something so easy