Forum Discussion
Azure DevOps Clear Schedule Clear Field
Hi all,
I have a field in DevOps that needs to be updated on a weekly basis. It just has a dropdown of "Yes" and "No". I need to be able to report on when this has not been completed, I have another field beside it which is a date that people are supposed to fill in when they have updated that field however people are completing the date and not updating the dropdown field from "Yes" or "No".
I'm looking to see if there is a way to clear the contents of the field on a weekly basis and that way there is no option but to complete the field each week?
Many thanks
Sarah
Please refer this:
- Create a new custom field (Say “Weekly Reminder” or something similar) with a dropdown containing options like “Reminder Sent” and “Not Sent.”
- Set up a scheduled rule (Say Azure Pipelines or external scripts) to:
- Weekly, change the value of the “Weekly Reminder” field to “Not Sent” for all work items.
- Notify relevant team members (e.g., via email or chat) that they need to update the main field.
- When team members update the main field, they can also change the “Weekly Reminder” field to “Reminder Sent.”
To clear a field in Azure DevOps on a weekly basis, you can automate the process in a few ways
1. Azure DevOps REST API:
You can write a script using the REST API to clear the field automatically. This script can be scheduled to run weekly. The API lets you update work items programmatically.2. Power Automate:
Use Power Automate to set up a scheduled flow that clears the field every week. This can trigger the necessary updates.3. Azure DevOps Pipeline:
Create a pipeline that runs weekly. This pipeline can use PowerShell or Azure CLI tasks to interact with the REST API and clear the field.Reference URL:
1. Work Items - REST API (Azure DevOps Work Item Tracking) | Microsoft Learn
2. Get started with Power Automate - Power Automate | Microsoft Learn
