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 / How to send Excel file...
Power Automate
Answered

How to send Excel files uploaded to Forms as attachments to outlook?

(0) ShareShare
ReportReport
Posted on by 13

I am creating a form that is in Microsoft Form.
We always upload and send one Excel file as a requirement.
I have confirmed that the Excel file will be saved to my personal OneDrive.

I want to use Power Automate to attach the Excel file stored in my OneDrive to outlook and send it to a specific person, but I can attach the Excel file, but when I open it, it is corrupted.

How do I set this up?

Categories:
  • Verified answer
    v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @yumoomin ,

     

    I've made a test for your reference:

    1\My Form

    vbofengmsft_0-1715841955555.png

    2\My flow

    vbofengmsft_1-1715842635925.png

    vbofengmsft_2-1715842694467.png

    vbofengmsft_3-1715842723617.png

     

    Best Regards,

    Bof

     

  • NathanAlvares24 Profile Picture
    1,714 Moderator on at

    Hi @yumoomin !

     

    Please do try out this flow:

    NathanAlvares24_0-1715841892644.png

    My form what it looks like:

    NathanAlvares24_3-1715842243183.png

     

    First build the flow till 'Get response details' action. Here we will use this json in the next action.

    NathanAlvares24_2-1715842115869.png

     

    Next action you add is 'Parse JSON' action.

    NathanAlvares24_4-1715842278154.png

    Use the output from the forms. Now for schema, copy the json I mentioned from the output of the previous action and click Generate from sample. Copy that json here. You will get some sample then as seen above.

     

    Compose action is not necessary. Please do ignore that.

     

    Then add 'Send email' action.

    NathanAlvares24_6-1715842543257.png

     

    In the Attachments section, you will get this list. Add the necessary ones to the respective textboxes:

    NathanAlvares24_7-1715842825476.png

     

    Output:

    NathanAlvares24_1-1715841966391.png

     

    I hope this helps.

     

  • yumoomin Profile Picture
    13 on at

    Hi!

    Thank you for your response.
    I tried to run it immediately, but I still get the error "file extension does not match" when I open the Excel attached to Outlook.
    Furthermore, the original Excel file is 16KB while the one attached to the email is only 800 bytes.
    Is there a solution?

  • NathanAlvares24 Profile Picture
    1,714 Moderator on at

    Hi @yumoomin !

     

    Have you tried @v-bofeng-msft approach? If not, please do try it out.

     

    Unless I feel that the file you are attaching to the forms is not excel or maybe something else? Don't you think @v-bofeng-msft ?

     

    If you are only accepting excel files, keep a restriction to accept only excel file types in your form.

    E.g:

    NathanAlvares24_0-1715847474559.png

  • yumoomin Profile Picture
    13 on at

    Hi, _@NathanAlvares24

     

    Yes...
    I've already limited the check there to Excel only

  • Verified answer
    v-bofeng-msft Profile Picture
    Microsoft Employee on at

    Hi @yumoomin ,

     

    Could you please show me you flow? Please edit your flow in classic mode and try again.

    vbofengmsft_0-1715851998998.png

     

     

    Best Regards,

    Bof

  • yumoomin Profile Picture
    13 on at

    Hi!

     

    I was able to successfully complete the project using the method you suggested!
    It seems that it was due to the fact that we did not get the metadata for the files.
    Thank you very much.

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

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 302 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 263

#3
Henil Profile Picture

Henil 115

Last 30 days Overall leaderboard