You’re offline. This is a read only version of the page.
4
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
Hi @trice602
Thanks for your reply - That was my thinking, but it doesn't work either
Any other thoughts?
Hi @CIJack-Lewis ,
Can you add a helper column (off to the far right in your worksheet) that points to the cell with a formula and then use that cell in your conditional action? Let me know please.
#1
WarrenBelz
146,635
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
Share
Report
All responses (
Answers (
