Adding a timestamp to file in Power automate flow

[Imagauthamam]

Hi All,

I have successfully created a power automate flow which goes to a Power BI Report and exports the file in the form of a PPT.
Since we generate this file multiple times in a day, I want to add a timestamp to the filename.
I'm adding my flow diagram and the filename should be PBI_Report_TIMESTAMP.
I'm sure we should add a step between Export to file for power bi reports and Create file step.
Can someone please help me with this implementation

CREATE FILE STEP

[Imagauthamam]

Hi @v-tangjie-msft ,

Actually I found a way, instead of creating 2 compose steps, I just made a single step with the following expression and it worked.

 concat('PBI_Report_', utcNow('yyyyMMddHHmmss'),'.pptx')

Thanks Neeko for your help.

[Imagauthamam]

Hi @v-tangjie-msft 

Thanks Neeko for the response.
I tried the following steps. But the file is not getting generated as a pptx format.
It is in an invalid format. I'm attaching the screenshot of sharepoint location after the flow ran successfully


The flow also ran successfully. Attaching the flow diagram.


Also, Please find the below output of compose step:

Also, find below the output of compose 1 step:

Finally, using the output of compose1 in create file step

Also, from the first screenshot, the text "PBI_Report" is also not getting concatenated in the file name.
Also saving as ".pptx" is also not working.
Please help me with this please

[v-tangjie-msft · Accepted solution]

Hi @Imagauthamam ,

To add a timestamp to the filename in your Power Automate flow, you can follow these steps:

1. Add a "Compose" action:
- Click on the "+" sign to add a new step between "Export to file for Power BI reports" and "Create file".
- Select "Compose" from the list of actions.
- In the "Inputs" field, use the following expression to generate the timestamp:

```plaintext
formatDateTime(utcNow(), 'yyyyMMdd_HHmmss')
```

2. Modify the filename:
- Add another "Compose" action to create the filename with the timestamp.
- In the "Inputs" field, use the following expression:

```plaintext
concat('PBI_Report_', outputs('Compose'))
```

3. Use the modified filename in the "Create file" step:
- In the "Create file" step, use the output from the second "Compose" action as the filename.

For more details, please refer: Add a date to file name when storing it in SharePoint with Power Automate

Add Timestamp (Date) in the File Name

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.