New to flow- need to have an email sent when a Live Data column hits a certain Number

[Anonymous]

So a have a live database which in turn has a Live dashboard in excel which is comprised of tables. I need to send a wf when a fail column hits a certain number. Can someone help? 

[Anonymous]

you should be able to use a condiition for this using the Is Equal To condition.

under the No condition, meaning its not equal to the value in question, you can use a terminate action.

[Anonymous]

So I know I have to use recurrance as it needs to keep looking at it. I have tried with the Excel business get row, then condition, my info and I have my send email but it returns a bad gateway on the excelis there something else I should be using? Used to Sharepoint designer. sorry

[v-xida-msft]

Hi @Anonymous,

Could you please share a screenshot of your flow's configuration?
Where does your Excel file store? OneDrive folder or SharePoint library?

Further, could you please show more details about your Excel table?

I have created a Excel file on my side and the data structure of it as below:

I assume that your Excel file is stored in your SharePoint library and you want to send an email notification when the Retweet count column hits 100. 

I have made a test on my side and please take a try with the following workaround:

• Add a "Recurrence" trigger, Interval set to 1 and Frequency set to Hour (I assume that you want to run your flow every hour).
• Add a "List rows present in a table" action, specify Location, Document Library, File and Table. 
• Add a "Apply to each" action, input parameter set to output of the "List rows present in a table" action.
• Within "Apply to each" action, add a Condition, click "Edit in advanced mode", type the following formula:

@equals(int(items('Apply_to_each')?['Retweet count']), 100)

Within "If/yes" branch of Condition, add a "Send an email" action.

Note: The Retweet count is a column in my Excel table, on your side, you should change the Retweet count into the column that you want to detect within your Excel table.

Image reference:

The flow works successfully as below:

Best regards,

Kris

[Anonymous]

v-xida-msft - i have tried your way. However it does reside on my One Drive and I am getting a bad gateway error now. If I put it on sharepoint my data connections dont work. It was created before we started using 365 and need to have this excel file for data.  

[Anonymous]

Here is my excel sheet the data comes from a line on the production floor. so when the fail hits 3,. i need it to send an email. 

[Anonymous]

Here is my excel sheet the data comes from a line on the production floor. so when the fail hits 3,. i need it to send an email.