I'm trying to build a flow around a SharePoint list. Specifically, I have a value which a user will change from false to true, resulting in an automatic email. However, here's where it gets tricky. The user will most likely continue to be active over time with this list item, editing and saving other values contained within. I don't want any additional emails to be sent upon sequential saves, only the first time this value is changed to true. It the value is true when the user opens the list form, and is also true when the user submits, I do not want an email to be sent.
Is there any possible way to do this?
An example (although not what I'm doing) would be when an item goes "active." If the item is marked as active, the owner should be notified. However, the item will most likely be edited again and again, and I would not like to have the owner notified multiple times, since they are already away that the item is not "active."