Hey all,
I have a flow set up to gather filtering parameter settings via PowerApps for a stored procedure executing over an on-premises SQL server. I have it configured now to appropriately execute the stored procedure with all ~20 parameters and it functions as intended. However, while I can "view" the "results" of said stored procedure execution (results could be anywhere from no results to ~100k results based on filter parameters).
However, what I want to have happen is once the SP is done executing, to have the flow do the following:
- Create a new Excel file
- Load the data from the SP into the Excel file
- Email said file as an attachment to the user (whose email is defined as one of the PowerApps parameters to make things easy)
- Delete the Excel file
I know there are limitations within Flow to this end, but I simply have not been able to ascertain how to proceed. Using the "Create File" on SharePoint (for Business) would be an option as I have a Team SharePoint site established that would work for this purpose, but I can't figure out how to make it work. Any assistance would be greatly appreciated. Here's a quick view of my Flow:
Thanks in advance!
