Hi
I've set up several flows to trigger based on the parameters of certain columns, no problem
However, if the parameter field is populated by a IF() statement, it doesn't trigger correctly, set up:
Cell formula = "=IF([@[Deactivation Month - Select the 1st day of the month in which you want the deactivation to occur]] <= TODAY(), "SEND", "")"
- Results in either a blank or a "SEND"
-- Flow is a get rows from table, apply to each, condition:
Running the flow, it runs but the criteria returns a failed result - so it hasn't recognised the "SEND" as being in the parameter cell
- However, if i remove the formula and just type "SEND", it works without issue
My assumption would be a data type issue, but I'm at a loss in how to fix it/overcome my issue
End goal - for the flow to trigger based on a date cell that has passed Today()
Any help would be apricated
