I have the old chestnut of a requirement to send out an email when the current date is within 30 days of a date in the DataVerse record.
Rather than use a scheduled flow to achieve this, I thought I might try this new fangled formula column, with a formula column set to:
If('someDateCountdown' = 30,true,false).
This field works as expected, being true or false on the records if they are at the 30 day count.
Also, when connecting via TDS to the underlying SQL, one can see the column in the DB which raises hopes that it is not a virtual column like a calculated field, but exists in some kind of reality.
But trying to trigger a flow with a change in this formula column does not seem to work. No amount of making this formula column go true or false fires the flow.
Anyone had any experience with this?
