Power Automate send Excel file only if there is data in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2492888%22%20slang%3D%22en-US%22%3EPower%20Automate%20send%20Excel%20file%20only%20if%20there%20is%20data%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2492888%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20I%20have%20created%20a%20flow%20that%20sends%20out%20an%20email%20once%20a%20month%20containing%20an%20Excel%20file%2C%20this%20works.%20But%20the%20mail%20can%20only%20be%20send%20out%20if%20the%20Excel%20contains%20data%2C%20does%20anyone%20know%20how%20I%20should%20build%20this%20in%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBest%20regards%2C%3C%2FP%3E%3CP%3ESandra%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2492888%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hello, I have created a flow that sends out an email once a month containing an Excel file, this works. But the mail can only be send out if the Excel contains data, does anyone know how I should build this in?

 

Thank you.

 

Best regards,

Sandra

2 Replies

@Sanvanie What kind of data you have in excel file?

 

If you have data in table format, you can get rows present in a table & then count the no. of rows using flow expressions & condition action. If there are any rows present, you can send an email.


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

@ganeshsanap,

It's only data, can you help me further on how I can process this in my flow? I don't quite understand how to do this with the rows count.

Thanks in advance!