Dynamically create Excel file daily with SQL data in Power automate

Question

I have created a power automate flow to execute a sql query and create a sharepoint file in excel format everyday and load the retrieved select query to the excel file. PFB the attached picture on how to pass the file name dynamically like today's date in the file name (create file task).

Skin · Accepted Answer · 2022-04-22 02:05:45Z

0

You can use something like this ...

concat('Prefix_', formatDateTime(convertFromUtc(utcNow(), 'AUS Eastern Standard Time'), 'yyyy-MM-dd'), '.txt')

... I'm not creating an Excel file, just a text file and I'm doing it for my own timezone. This is the result in SharePoint ...

answered Apr 22, 2022 at 2:05

Skin

11.7k3 gold badges16 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Dynamically create Excel file daily with SQL data in Power automate

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related