You’re offline. This is a read only version of the page.
To set up Power Automate so that when a column value is changed to RESOLVED, the item is archived, marked with the resolved date, and removed from the original list, start by creating a new Automated Cloud Flow. Use the trigger “When an item is created or modified” and select your original list.
Next, configure a trigger condition so the flow only runs when the column value is RESOLVED. In the trigger settings, go to … → Settings → Trigger Conditions and add the following expression:
@equals(triggerOutputs()?['body/YourColumnInternalName'], 'RESOLVED')
Replace YourColumnInternalName with the internal name of your column.
After that, add a “Get item” action to retrieve all the details of the current item from the original list. This ensures you have the full item information for archiving. Then, add a “Create item” action to add the item to your archive list. Map the fields from the original item to the archive list fields, and for the Resolved Date column, use the expression utcNow() to automatically record the current date and time.
Finally, add a “Delete item” action to remove the item from the original list, using the ID from the trigger. Test the flow by marking an item as RESOLVED in the original list and confirm that it appears in the archive list with the resolved date while being removed from the original list. This setup ensures the process runs automatically without affecting items that are not marked as resolved.
If this solution helped you resolve your issue, kindly mark it as accepted — it makes it easier for others to find and also closes the discussion. If you found it useful, a Like ❤️ would be greatly appreciated!
🤝 Let’s connect on LinkedIn || 📘 Explore more on my articles
#1
Michael E. Gernaey
745
Super User 2025 Season 2
#2
Tomac
528
Moderator
#3
Power Apps 1919
320
Share
Report
All responses (
Answers (
