Power Platform Community Forum Thread Details

Hi everyone,

I'm trying to integrate Power Automate with my Microsoft Lists to create a flow that updates and locks the date and time in a column when a specific choice is selected. Here are the details:

Objective: When the choice column named 'Progress' is set to 'Completed', the date and time column named 'Completion Date' should be updated and locked in at the date and time 'Completed' is selected.
Approach 1 Taken:
1. Trigger: When an existing item is modified.
2. Condition: Progress is equal to 'Completed'.
3. If yes, Action: Update item, set Progress value to 'Completed', and set Completion Date to dynamic content utcNow().

However, the 'Completion Date' column wasn't updated as expected.

Approach 2 Taken:

I tried using a calculated column to input the date and time when 'Completion' is chosen, but this column changes whenever the item is refreshed, so it's not locked in.

Question: How can I get the 'Completion Date' and time to be locked in at the moment 'Completed' is selected in the 'Progress' choice column?

Any suggestions or guidance on how to achieve this would be greatly appreciated!

Thanks in advance for your help!

Categories:

Building flows