Check whether a collection contains a numberical value above a certain numberical value only if it occurs 3 times in a row

(0) Share

Report

Posted on by willtumus

I have an app which records fridge temperatures every 5 minutes.

Twice a day, it pulls data from sharepoint and stores it in a collection before presenting it in a chart.

It has 2 columns, Temperature and DateTime

I need to create an alert that sends an email only if the fridge has been out of range 3 (e.g. over 8 degrees) three times in a row.

If the fridge is out of range for 10 minutes and then goes back in range and then out of range 10 minutes later. I do not want it to send an email. I only want it to send an email if it has been out of range 15 straight.

I know how to configure the email but I don't know how to identify when the fridge has been out of range.

Is this possible with powerapps?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

PowerRanger 3,458 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@willtumus so when you say 'I have an app which records fridge temperatures every 5 minutes. ' what exactly is that app doing? Is it really an app or a flow?

My first idea would be:

Whenever your app records a temperature out of range you set a variable. Set(varCounter,varCounter + 1)

Whenever the temperature is in range you reset the varCounter variable

Set(varCounter,0)

Whenever the variable varCounter is equal to 3 you can send the email and reset the variable again

Was this reply helpful? Yes No
willtumus 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry I should have been more specfic.
Twice a day data for the last 24 hours is dumped into a sharepoint list. The list contains fridge temperatures at 5 minute intervals.
The app then uses this data dump to populate the app.
Your idea would be great if it was sequential data coming through. Is there a way it could work with a entire data set?

Was this reply helpful? Yes No
willtumus 8 on at

Like
a
(0)

Report
Copy link

Link copied!

And to answer your first question. It's a powerapp

Was this reply helpful? Yes No
Verified answer

PowerRanger 3,458 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@willtumus if it is all about sending an email I would then recommend using power automate.

Use Get Items with a Filter query and Sort based on the capture date. Iterate thru the result with Apply for Each and use the same logic as mentioned above. This is much more reliable. Would this meet your requirements? Or is there any reason why you have to do this within the app?

Was this reply helpful? Yes No
willtumus 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Great idea thanks.

Was this reply helpful? Yes No