Using Power Automate in Power BI Service to Append Dates on File

The Steps:

1. Go to Make.powerautomate.com

2. In the left click Create
3. Choose Automated Cloud Flow
4. Give it a name- and save
In the flow box search for When a new email arrives (V3) , select folder and fill in
Include attachments             Yes

Only with Attachments         Yes

From                                      email address

Subject filter                          Report Name
Click on Save

Next Add The Loop

5. Click  + New Step
6. Search apply to each under control

7. In the field select an output from previous steps click inside and click on dynamic content and select Attachments
8. Under 6 click on + add an action

9. Click on Microsoft 365 outlook and select Get attachment (v2)

10. click on tab dynamic content and search for message Id. Also click on attachment Id field and dynamic content and select attachment id

11. add compose filename step. Click on add an action and search for compose, select it and click on expression and type in concat('report name_', formatDateTime(utcNow(), 'yyyy-MM-dd'), '.xlsx') and click ok. Rename compose to compose filename by clicking on the ... and select rename

12. Click on + add an action

13 search for condition and select condition under control. click inside the box on the left and click expression and paste endsWith(toLower(item()?['Name']), '.xlsx') click ok

14. middle box remains is equal to

15. right box click on expression and typr true and click ok.

16. 2 boxes appear under Yes and no. No side remains the same. In the yes box click + add an action. search for send an email (V2) under Microsoft 365 outlook}

17 fill he card
To: email addresses of users
Subject Report name - @{formatDateTime(utcNow(), 'mmmm dd, yyyy')}
Email body
Advanced Options:

From (Send as): Email account you want the email to go out from. Exchange admin can help if not available
Attachments:

Name: Click inside > Expression and type outputs('compose_Filename') click Ok
ContentByte > click inside> click expression> type body > select Get attachment (v2) from suggested list and complete the expression> body('Get_Attachment_(V2)')?{'contentBytes'] Click OK. 
You are set