Unanswered

Creating Excel file from SQL using Flow but it creates corrupt file in OneDrive

(0) Share

Report

Posted on by shaan

Hi,

I am trying to create an One Drive Excel (.xlsx) file from a SQL Server Stored Pro (Running a Select Query). It Creates file successfully but I can't open it because it says that file is possibaly corrupt. However when I try to open it in notepad it looks like that data is there but in Json format:

Data displayed in Notepad:

{"Business":"ABC","CreatedOn":"2018-03-01T00:00:00","Product":"XYZ"}

Following is my flow:

Thanks

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

v-yuazh-msft on at

Like (1)

Report
Copy link

Link copied!

Hi @ Hayer,

Do you want to create a excel file with some seleted items when an an item is created in your SQL?

Or Do you want to create some excel files with each seleted item when an an item is created in your SQL?

If you want to create one or more excel files with seleted items or each seleted item when an an item is created in your SQL,I afraid that there is no way to achieve your needs in Microsoft Flow currently.

Microsoft flow don't support to create a excel file and insert rows in the new excel file in the same flow,if you would like to create a excel file and insert rows in the new excel file in the same flow, please submit an idea to Flow Ideas Forum:

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

Regards,
Alice Zhang

Was this reply helpful? Yes No
shaan 3 on at

Like (0)

Report
Copy link

Link copied!

Hi @v-yuazh-msft

Thanks for your reply. I just want to create one excel file from a select statement in stored proc.

1. A new record in table called 'TriggerFlow' and that insert triggers the flow.
2. Flow executes a store Proc which contains a single select statement and returns a table.
3. Apply to each loops through that table to write rows in a newly created file.

Is it something doable or not?

I can create and open a csv file successfully. But when I am trying to create file with .xlsx extention it creates the file but when I try to open it with MS Excel is throws an error saying that file is corrupt.

Was this reply helpful? Yes No