We have an application where we are collecting operational data (e.g. temperature, power, vibration, gas analysis etc) from a range of sensors attached to a variety of assets.
We store a range of safe operating limits for each asset and we would like to issue alerts by SMS or email to the asset owners when we receive data that is outside those limits. This needs to be as close to real time as possible so action can be taken asap.
Can this be done using Power Automate?
Paul
It can be done with Power Automate. However, you will need an intermediate data storage such as SQL Server, SharePoint or Excel to temporarily store the data and evaluate it using PowerAutomate.
You can then use the respective connectors to check for any new entry and then run the values updated through a condition and then either use the SMS or Email connector to trigger emails to respective Asset Owners. You might need to create a Lookup Table in Excel, SP or SQL listing the Assets against the Asset Owners.
Alternatively, if the application supports API, you can consider Streaming connection to a Power BI report and then trigger email through Subscription option triggering when a threshold is met.
Hello @PaulBoyes It’s been a while since we got a response from you.
Did the responses above help solve your query?
If not, how far did you get, and what kind of help do you need further?
If yes, kindly mark as the solution the answer that solved your query.
Hi @PaulBoyes
Checking if you were able to check the solutions provided to your inquiry.
Did it help you solve your inquiry?
If it does, kindly mark the answer as the solution that solved your query.
If not, how far did you get, and what kind of help do you need further?
i’ve set up something similar before, and power automate can definitely handle it.
And you just need somewhere to store the data, like SQL, SharePoint, or even Excel. From there, you can create a flow to check the data, compare it to your limits, and send out an SMS or email when something’s off.
Well, when I was testing it, I used disposable phone numbers to try out the SMS alerts without worrying about giving out personal numbers.