Dynamic Filenaming
Subscription output can be customized using dynamic date and time variables enclosed in @{}
. This ensures consistency and automation in report generation. Placeholders like @{yyyy}
, @{MM}
, and @{dd}
are automatically replaced with their corresponding date values when the report is generated. For a full list of supported date and time format options, refer to Microsoft’s documentation.
Here are some example filenames and what they would evaluate to if the subscriptions were executing on July 12th, 2025 at 07:25:00.
@{yyyy} Financial Report @{yyyyMMdd}.csv --> 2025 Financial Report 20250125.csv
Report_@{yyyy}_@{MM}_@{dd}-@{HH}_@{mm}_@{ss}.csv --> Report_2025_07_12-07_25_00.csv
Or, more simply:
Report_@{yyyy_MM_dd-HH_mm_ss}.csv --> Report_2025_07_12-07_25_00.csv
String literals can also be quoted to preserve them:
@{'Report_'yyyyMMdd'.csv'} --> Report_20250712.csv
Another Dynamic Filenaming variable that is available is @timestamp
(with no braces). Occurrences of this will be replaced as if it encountered @{yyyy_MM_dd_HHmmss}
.