- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
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