Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Sales forum / How to generate excel ...
Sales forum
Answered

How to generate excel file using power automate and send it as an attachment ??

Posted on by 354
Hi,
 
I have a requirement where I need to run the ms flow on weekly basis and sent the report(using List row) as an excel and this excel should be attached in the mail.
 
As I have checked few links where we can achieve this through one-drive connector. Can't we create the excel file inside the power automate only and send as an attachment ? because through one drive connect, every week there will be a new excel file and in future we need to delete those old excel files.
 
 
Categories:
  • Suggested answer
    RudyZhang Profile Picture
    RudyZhang Microsoft Employee on at
    How to generate excel file using power automate and send it as an attachment ??
    Hi,
     
    We analyzed your requirement and found a similar requirement to yours in the Power App community, the answer to that post mentions a solution to convert data to an array to generate a CSV.
     
    You can refer to the post in the link below for specific details.
    https://powerusers.microsoft.com/t5/Building-Power-Apps/Power-Automate-Create-A-Excel-File-As-email-Attachments/m-p/1412386#M366807
     
     
    I hope my answer is helpful to you! If you have any other questions, please feel free to contact me.
     
    Best Regards,
    Rudy Zhang
     

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,773 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,513 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans