Unanswered

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

(0) Share

Report

Posted on by 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

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (0)

Sort by

Craig Stewart ABZ 959 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Argy_Zadkine 51 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Craig Stewart ABZ 959 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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/

Was this reply helpful? Yes No
Jay-Encodian 2,920 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Argy_Zadkine 51 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Argy_Zadkine 51 on at

Like (0)

Report
Copy link

Link copied!

Unfortunately, yes. Thanks for the suggestion

Was this reply helpful? Yes No
Argy_Zadkine 51 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Argy_Zadkine 51 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No