cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mrb783
Frequent Visitor

PowerApps -> Execute Stored Procedure -> (NEED HELP HERE) Create Excel file with results and email

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:

  1. Create a new Excel file
  2. Load the data from the SP into the Excel file
  3. Email said file as an attachment to the user (whose email is defined as one of the PowerApps parameters to make things easy)
  4. 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:

flow.png

 

Thanks in advance!

2 REPLIES 2
v-yuazh-msft
Community Support
Community Support

Hi @ mrb783,

 

 

Do you want to create a new excel file and then insert the stored procedure to the excel when  the stored procedure is done executing?

 

Microsoft flow support to insert the date to a existing excel file currently,if you would like to insert the date to a new created excel file in one flow,I afraid that there is no way to achieve your needs in Microsoft Flow currently.

 

If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:

https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

 

 

 

 

Regards,
Alice Zhang

I apologize, but I'm not understanding your post...but think you're saying I can't do what I'd like to do.

 

Would it be possible to create a .csv file instead? Either would suffice for my needs.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,478)