
Hello all, at this point I have a flow working that is pulling columns from a Power BI dataset using the PA PowerBI action "Run a query against a dataset". my question is what is the best way to access the result in PowerApps.
1. Push the result into SharePoint online list and use the list as a source in the PowerApps
2. or is there a way to get the PowerAutomate flow query result into a PowerAutomate collection
Thanks for any help on this
Please note that I do not have access to Premium license and although I could request elevated permissions (for solution building) I do not have it now. Also I am working in government cloud.