In a company that already has Microsoft 365, a CAPA workflow usually consists of four elements. SharePoint stores the documents: analysis reports, plans and evidence of completion. Dataverse, the Power Platform database, holds the CAPA cases themselves, with fields such as status, deadline, device and cause.
Power Automate sends tasks and reminders and escalates cases when deadlines pass. Power Apps provides forms for the quality department, and Teams provides notifications and simple approvals. Power BI shows the management board how many cases are open, how long they take and where they come from.
Three settings decide whether the whole thing will pass an audit. First, auditing in Dataverse has to be switched on for the environment, the table and the columns – it does not switch itself on. It records who changed a field, when, and what the previous value was.
Second, the permission to delete the change history must be limited to a very small group of people – ideally no one from the quality department. Third, a single Power Automate flow run lasts at most 30 days. So plan an effectiveness check due several months later as a daily check of deadlines, not as a flow that waits.