Creating Excel file using Scheduled Flow in Power Automate, with data from SQL

[Argy_Zadkine]

I have built a Scheduled Flow, in which data from an SQL server via an SQL Statement is read. Then data is used to create a CSV File and finally post it in Sharepoint. It is working at the moment. But I need to create now, an Excel file, instead of a CSV File. 

The change should happen in the last steps  from "Get CSV Data". What would I need to do in the flow , in order to produce an Excel file instead of the CSV File, apart from Encodian "Convert Excel" and Plumsail " CSV To Excel"? 

Thanks 

[CraigStewart]

Is this flow going to create more than 50 excel files a month?

Encodian appears to be free for 50 actions a month
https://www.encodian.com/products/flowr/#pricing

Clarification on actions:

https://support.encodian.com/hc/en-gb/articles/360005989118-What-is-an-Encodian-action-

@Jay-Encodian might be able to clarify for your requirements.

[Argy_Zadkine]

Thanks, Craig for your reply. My flow would create 4 files a month. But I have 35 flows like this creating each one file per week. In total there would be 35*4 = 140 actions per month. Would that still be covered for free permanently?

Thanks.

[CraigStewart]

No that would exceed it, you'd need to go to a paid subscription for that.

I did find this which might be helpful if you're looking to avoid the paid subscription route.

I haven't run through this myself but will take a look later this week as it certainly looks interesting.

https://benediktbergmann.eu/2020/09/27/create-and-fill-an-excel-file-dynamically-with-power-automate...

[Jay-Encodian]

@CraigStewart- thanks, you're correct. The Free plan is limited to 50 actions per month

[Argy_Zadkine]

Thanks, Craig for the suggested link. I will have a look at it later today ( testing it), but it does not look like an uncomplicated solution , rather cumbersome. I have found something similar, albeit for OneDrive, not Sharepoint:

https://www.youtube.com/watch?v=Kupz71dWYyY 

You are correct, I am trying to avoid, at this stage, any paid subscription, as my company expects a  clean free solution.

I do appreciate if you have a look, as you said, over the link you just have shared with me, and give me your feedback.

Very much appreciated 

[Argy_Zadkine]

Unfortunately, yes. Thanks for the suggestion

[Argy_Zadkine]

Hi Craig:

I have given the Benedikt flow a go, but I got stuck with the " Common Data Service Connector", as I was not able to find  it . The information I have found via  a search is that this Connector is now part of the Premium Dataverse. Benedikt's flow uses a trigger that I do not require, as myine is a Scheduled Flow using an SQL.  I also tried Reza's  video (https://www.youtube.com/watch?v=Kupz71dWYyY) that looks pretty much what I intend to do, but I cannot fin the "get items" in Sharepoint, and the " Select" action from his flow.  Any help would be highly appreciated

[Argy_Zadkine]

I have finally applied the solution given in the following links:

https://www.youtube.com/watch?v=RB_ySjhm9Sg

https://www.youtube.com/watch?v=9J6ThPWGaG0

https://docs.microsoft.com/en-us/office/dev/scripts/resources/samples/convert-csv

I am still working on it, as I am having issues with the Script