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?
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!
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!
@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.
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.
@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!
Tomac
986
Moderator
stampcoin
699
Super User 2025 Season 2
Riyaz_riz11
577
Super User 2025 Season 2