web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Add rows to excel file...
Power Automate
Suggested Answer

Add rows to excel file, save file as a new file, then post or email to dynamic email

(0) ShareShare
ReportReport
Posted on by 12
I have a manual trigger flow that adds rows to an excel template.  I'm wondering if number 1:  is possible once the flow is complete, to add an action to save the file as (ie.  'January '25 Sales' from 'Sales Template')?  Number 2:  send that new file to a dynamic email?  For instance, is it possible for the end user to select the email they wish to send it to before they trigger the flow?
 
This is a PBI report that I am looking to have the end user select certain criteria before triggering the flow.  If I bring in a list of email addresses into the model and create a visual that will allow them to select their email address, can I somehow create an action that will send the file to the email the end user has selected in the report?
 
Thank you in advance for any suggestions/assistance!
 
 
Categories:
I have the same question (0)
  • Suggested answer
    David_MA Profile Picture
    15,350 Super User 2026 Season 2 on at
    I am not sure I understand your naming convention for the file, but to create the file, do this:
    1. After you have added the rows to your Excel template, use the Get file content action and point the action to the file you just added rows.
    2. Then use the Create file action and use the file content from the get file content action in the file content field of the create file action.
    3. Name it however you want.
    Since the flow is manually triggered, just add an e-mail field to the trigger and use the selected value to send the e-mail:

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 259 Super User 2026 Season 2

#2
trice602 Profile Picture

trice602 177 Super User 2026 Season 2

#3
11manish Profile Picture

11manish 136 Super User 2026 Season 2

Last 30 days Overall leaderboard