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

Community site session details

Session Id : xi2LaqMh+8LQN9bMfoFuO2
Power Automate - Building Flows
Answered

Flow is sending some blank emails

Like (0) ShareShare
ReportReport
Posted on 15 Feb 2024 21:02:06 by 31

I built a scheduled flow to send emails from an excel report that I upload into a SharePoint folder. I'm currently testing the flow so I only have two names on the report. The flow appears to be working, it doesn't show any errors. It is sending the email to one person completely fine but sending a blank one to the other. The body of the email is blank but it does have the correct subject. Has anyone else run into this problem before?

  • Verified answer
    oliviahitchell Profile Picture
    31 on 16 Feb 2024 at 20:23:46
    Re: Flow is sending some blank emails

    I ended up rebuilding the flow and creating formatting the body of the email using the classic designer. I was previously using the code view and formatting using the source copied from an outlook email I'd already formatted. Everything seems to be working now!

     

    Thanks for the tips!

  • creativeopinion Profile Picture
    10,468 Super User 2025 Season 2 on 15 Feb 2024 at 23:29:40
    Re: Flow is sending some blank emails

     

    You might also be interested in this YT Tutorial: How to DYNAMICALLY Select a Table in the List Rows Present in a Table Power Automate Action

     

    In this Microsoft Power Automate tutorial, I’ll show you how to dynamically set the File and Table field.

    IN THIS VIDEO:

     How to create an Automated Cloud Flow

    How to dynamically select a Table in the List Rows Present in a Table Action

    How to use the Parse JSON action

    How to use the When a file is created (properties only) trigger

    How to avoid the Apply to Each Action

    How to Create an Item in SharePoint from Excel Data

     

    Hope this helps!


    If I helped you solve your problem—please mark my post as a solution .
    Consider giving me a 👍 if you liked my response! If you're feeling generous— ️  Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

    👉 Watch my tutorials on YouTube
    👉 Tips and Tricks on TikTok
     

    @oliviahitchell would you be able to switch to the Classic Designer and expand all your actions and take a screenshot of that? Your flow looks correct (from what I can tell). I would also recommend maybe testing out a run in the Classic Designer. The New Designer is a bit buggy.

  • oliviahitchell Profile Picture
    31 on 15 Feb 2024 at 22:18:52
    Re: Flow is sending some blank emails

    Thank you for the resources! Here is a shot of my flow. It is a pretty simple one that I built with the help of a Microsoft Learn path.

  • creativeopinion Profile Picture
    10,468 Super User 2025 Season 2 on 15 Feb 2024 at 21:42:04
    Re: Flow is sending some blank emails

    @oliviahitchell Can you pls show a screenshot of your flow? In the meantime, you might find this YT Tutorial helpful: 5 Power Automate Troubleshooting FAQs and Helpful Tips for Creating Better Flows

    In this tutorial I cover:

     How to troubleshoot a false Condition action result

     How to get dynamic content when it isn’t selectable from the list of dynamic content

     How to troubleshoot an Apply to Each action that isn’t looping through

     How to troubleshoot a skipped Apply to Each action

     How to troubleshoot a Filter Query

     How to use a SharePoint yes/no column in a Filter Query

     How to use Compose actions to troubleshoot a Power Automate flow

    How to troubleshoot multiple emails being sent

     How to troubleshoot multiple Teams messages being sent

     

    Hope this helps!


    If I helped you solve your problem—please mark my post as a solution .
    Consider giving me a 👍 if you liked my response! If you're feeling generous— ️  Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

    👉 Watch my tutorials on YouTube
    👉 Tips and Tricks on TikTok

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

Telen Wang – Community Spotlight

We are honored to recognize Telen Wang as our August 2025 Community…

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2