'Dynamically create Excel file daily with SQL data in Power automate
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).
Solution 1:[1]
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 ...
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | Skin |