You’re offline. This is a read only version of the page.
10
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:
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!
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.
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
#1
WarrenBelz
146,601
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,946
Most Valuable Professional
Share
Report
All responses (
Answers (
