cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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

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? 

6 REPLIES 6
Highlighted
Anonymous
Not applicable

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

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.

Highlighted
Regular Visitor

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

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

 

Highlighted
Community Support
Community Support

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

Hi @cynde001,

 

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:13.JPG

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:14.JPG

 

 

The flow works successfully as below:15.JPG

 

 

 

 

Best regards,

Kris

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

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

 

Capture.JPG

Highlighted
Regular Visitor

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

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. 

 

Capture.JPG

Highlighted
Regular Visitor

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

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. 

 

Capture.JPG

Helpful resources

Announcements
Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Upcoming Events

Experience what’s next for Power Automate

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Top Solution Authors
Top Kudoed Authors
Users online (6,204)