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.
Continue Reading Olena Grischenko’s Article on their blog
Blog Syndicated with Olena Grischenko’s Permission
More About This Author
- Power Automate10 August 2023Canvas App: Office365Users.Search UserV2 not working, but V1 does
- Power Automate7 August 2023Co-pilot with Power Pages: new features to generate UI
- YouTube7 August 2023Power Pages Copilot – YouTube
- Power Automate19 July 2023Power Automate: Send approval email to external customer