Hi,
I have a project where I need to pull a lot of data (~10 tables worth) from an ODBC and send it to PowerApps to be stored and used (ideally, I could just call on a field and it would populate: example - I select a dropdown and it would show values from that table). I got the gateway set up in Power BI to schedule refresh the data, but I was trying to figure out how to connect that dataflow in Power BI to Power Apps and was told to use Power Automate. I'm quite new to Power Automate so what I have so far is initiating the flow when that dataflow refresh occurs. The main part I am stuck on is how to call all tables and pass that through the flow to get sent to PowerApps.
Any help or information, or general thoughts would be helpful. Thanks!
