I have a scheduled flow that kicks out certain emails when the 'Status' of on item is changed.
The SP List data source has a 'Status' (single line of text) column and a 'Previous Status' single
line of text column.
The flow runs twice per day. When the flow runs, I want the final task to be an Update action
that updates the 'Previous Status' column to the content previously contained in the 'Status'
column.
I am aware one of the main purposes of this flow is send an email because the 'Status' has changed,
meaning the only 'Status' is no longer a definable meta data.
However, I was wondering if I could get around this by creating a formula that makes assumptions
on the old 'Status' and updates the 'Previous Status' based on those assumptions?
Example:
When a new item is added the 'Status' is "Hot Lead".
At this point the 'Previous Status' should be empty.
"Hot Lead" will always be (manually) changed to "Pending".
Once this change occurs, and during the next scheduled flow run, the flow should see the 'Status' has been changed
to "Pending" and - based on a formula in the action property, update the 'Previous Status' to "Hot Lead", because
"Hot Lead" is always the first Status before "Pending".
Likewise, 'Status' "Pending" will always either be changed to 'Qualified' or 'Disqualified'.
Whether the 'Status' is changed to "Qualified" or "Disqualified", the 'Previous Status' should always be changed
to 'Pending', as "Pending' always comes before either "Qualified" or "Disqualified", and so forth.
Share
Report
5,331
All responses (
Answers (
