cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Excel rows send in only one email with condition

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):

Powerautomate condition.JPG

 

Thank you any replay!

1 ACCEPTED SOLUTION

Accepted Solutions
Responsive Resident
Responsive Resident

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:

filterExcel.png

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.

View solution in original post

4 REPLIES 4
Responsive Resident
Responsive Resident

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?

Responsive Resident
Responsive Resident

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:

filterExcel.png

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.

View solution in original post

New Member

Thank you! Its working good.

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (33,482)