Flow is sending some blank emails

[oliviahitchell]

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?

[creativeopinion]

@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

[oliviahitchell]

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]

@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.

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]

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!