Build a Flow: Send an Outlook Email if/when certain Excel cells are left blank

[GBLM2020]

Hello, 

I am new to power automate but I am looking to build a flow that will hopefully help with my work. Below is an excel table that I am working in. The file will be updated bi-weekly by various people, and I am looking to find a way to automate the process of sending an email if people fail to update. (I added row/column# for reference): 

A1	B1	C1	D1	E1	F1	G1	H1	I1	J1	K1
A2	Weekly Send out- Jan 9th
A3	Workstream	Prior	Curr	Milestones	Status/ Key Risks	Resolution	Percentage Build Completed?	Lead Sign-off (initial when updates are complete)	Points of Contact	Email
A4	Program	●	●	Resourcing	no risks				John Doe	John.Doe@Company.com
A5	Project	deadline risk

My overall goal for the flow is to have an email be sent to certain recipients (email addresses) who haven't made updates in an excel file by a certain date. 

So ideally, the flow would send an automatic email to the email address listed in column K IF column I is left blank (i.e. they haven't signed off in this column). 

Is there a way to build a flow to do this? I am pretty new to power automate so I am still learning. I was unsure if this is something that power automate has the capabilities to do. Based on looking into templates, I feel like with some build work it would be possible. I've summarized below the overall goal. 

Build Requirements: 

• Send an Outlook email to all addresses that align with a blank cell in column I at the end of a specific day.
• Emails only be sent to contacts who have not signed off in Column I (blank cells) 
• So---- IF column I is blank THEN send an email to the contact address in column K.  

Correct me if I am wrong but I believe the flow would have to pull from a table in excel and send an email if a condition is met? I am just not quite sure how to get to that point. 

I know I overexplained and re-explained a bunch in this post but love any guidance or feedback on how to build this flow. 

Thank you so much! 

[Pstork1]

1. Use a recurrence trigger to run the flow on the days and times you want to check and send the email.
2. After triggering the flow use the List Rows in a table to get the rows you want to check. This assumes the spreadsheet is stored in SharePoint or Excel.
3. Filter the Rows to filter out any rows where Column I is not blank
4. Do an Apply to Each on the remaining rows and send an email for each row using the email address in the row.

[GBLM2020]

Hi, 

This build isn't quite working. Do you happen to know the odata filter expression to use in order to filter out not blank rows? 

I used: 

$filter=lead sign-off eq null 

but I am getting errors. 

[Pstork1]

I don't think you can use an OData filter to filter out the blank rows.  You can use a Filter Array that's why getting the rows was step 2 and filtering them was step 3.

[GBLM2020]

Hi, 

I have successfully run the flow! However, when testing the filter array function does not appear to be working. I am trying to filter out any cells that are left blank in the column "Lead Sign-Off". Below is the filter array applied. 

I've also tried to use 'equal to'

While emails are sending, they are sending to everyone. Not just the cells that are blank/empty. Any reason why this is? 

For example, I would only want an email to send to fp123@company.com because they did not sign-off.

Lead Sign-off	Email
	fp123@company.com
GB	jd456@company.com

[Pstork1]

Try using the length() function around the Lead Sign off with less than or equal to 0. If the field is an empty string the length will be 0.  You should also test for if its equal to null() just above that line in the condition.  It should look something like the screenshot below, but using your field instead of Body