Dataflows for Power Apps: calling a table-valued SQL function with Power Query

Posted By Olena Grischenko on 2 Feb 2021 in Power Automate

It’s very easy to query SQL table-valued function to retrieve the result with Dataflows.

This is how we do this.

Let’s connect to a database. It will work via gateway as well.

Select your function.

Pass the parameter if required.

Now you can use this table to merge with other tables or map and load to Dataverse.

Super easy!

Continue Reading Olena Grischenko’s Article on their blog

https://msolenacrm.blog/2021/02/02/dataflows-for-power-apps-calling-a-table-valued-function-sql-function-with-power-query/

Blog Syndicated with Olena Grischenko’s Permission

More About This Author

Olena Grischenko

Array

Array

• YouTube20 April 2024Contoso Coffee – YouTube
• Power Automate21 March 2024Power Platform for Admins: create Dataverse with Dynamics 365 apps enabled
• Power Automate9 February 2024Will It Break? Non-business Dataverse connector + AI Builder with a DLP policy for the Default environment
• Power Automate25 January 2024Power Automate: contains(), array, AI and bananas.