You’re offline. This is a read only version of the page.
5
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!
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 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?
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.
#1
WarrenBelz
146,653
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,999
Most Valuable Professional
Share
Report
All responses (
Answers (
