Notifications
Announcements
Hello,
Im am new in the Power automate, but i like it. How can i send all excel rows (from one table) in only one email with condition?
I would like to use simple condition like this (if excel table is empty dont send email):
Thank you any replay!
After your "List rows present in a table" action, add a "Filter array" action. Use that filter on the values from your Excel Spreadsheet to select only the rows where the Date Checked column is not equal to null.
Next, use a "Create HTML Table" action. Set the filter you just created as the source.
Finally, create the action to send the email. Put the output from your Create HTML Table action in the body of the email.
Thank you for your replay!
How can i use the excel - empy filter in the Powerautomate?
The other settings is working good, include HTML, array settings, but I just don't know how to specify the settings for the empty excel condition.
Can you send to me a flow screenshot?
Looks like Date fields with no values are returned as empty strings, not as null - at least in my test. In that case, you can set up a filter like this:
Select the Date created field, set it to "is not equal to", and leave the second field blank. It will filter out all the rows with no date and return the rows that do have a date.
Thank you! Its working good.
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 522 Super User 2025 Season 2
Tomac 364 Moderator
abm abm 243 Most Valuable Professional
