Unanswered

Post-Update of Previous Status with Current Status

(0) Share

Report

Posted on by Phineas

5,325 Super User 2025 Season 2

I have a scheduled flow that kicks out certain emails when the Status of on item is changed.

The SP List data source has 'Status' column and a 'Previous Status' column.

When the flow triggers I want the final task to be an action that Updates the 'Previous Status' to the
actual 'Previous Status'.

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 the next flow run should Update
'Previous Status' to 'Hot Lead'.

Status 'Pending' will be changed to 'Qualified' or 'Disqualified'.

Whichever outcome, the 'Previous Status' should also be changed
to 'Pending', and so forth.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

The way you've described it its not possible. When the Hot Lead status is manually changed to pending there is no way for the flow to know that the previous value should be changed to Hot Lead. At the end of the flow it will be changed to pending. But when that run takes place nothing points to Hot Lead.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
BD-01080338-0 44 on at

Like (0)

Report

Can I write a Switch or If expression in the 'Previous Status' property of an Update item?

The If can be something like, 'If 'Status' equal ..... theb 'Previous Status' - ..... , listing all the permutations?

Was this reply helpful? Yes No