I came across the article below that highlights the use of Power Query. About halfway down the page it notes that you can get the "full Get Data experience" with multiple sources available. Is this a feature that still exists? I see the article is about a year old so perhaps it was dropped.
If so it would open up quite a few options.
Hi @Anonymous5 ,
The "Transform data using Power Query" action still exists in Microsoft flow, you could take a try with the action in your flow to achieve your requirement.
Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I'm blowing the dust off this one to see if anyone is experiencing the same issue as I am. When working in Power Automate under the SQL Power Query, I can see that there are other potential data sources are available but when I select Excel for instance, I am presented with a screen for the source details but the window will timeout and revert back to SQL only. I am unable to utilize this feature. Is this an issue specific to my account or is this a bug?
Appreciate any insight.
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!