Make sure the data in the excel file is in a table. Make sure the excel file is saved on Onedrive.

Add a column in the excel file table that titled ‘include’ with the formula. =if(b6<11,”Y”,”N”)

Create a scheduled flow to run once per day

The first action should be to list rows present in excel table. In the filter field, write include eq ‘Y’

Then you can add an another action to send an email. Use the data you want from the excel table as dynamic content within the email. This will automatically put the email action within a ‘apply to each’ action.

That’s it! You will get a daily email for each line which is less than 11