CARR LIST using Microsoft Power Automate
Updated: May 17
Why do you need to use PA to create a CARR LIST?
Standardized business rules
Reduce human error by using standardized dropdown list in SharePoint
Approval process completed by different parties
Traceability of each state
Create a CARR item in SharePoint list.
Declaration variables for Autogenerated Complaint Ticket Number.
Get Items - CARR List for getting all items whose "Complain Number" is equal to the default value "AUTOID". (Prevent for same ticket number)
Get Item - CARR List is used to filter items from the Get Items-CARR List.
Get Item – Auto Numbering List is used for Prefix and Generated Number, which is use in Autogenerated Complaint Ticket Number.
Get Item – CARR Approver List is used, when the user selects Stage, the flow is utilized to automatically set associated persons from the CARR Approver List.
Scope – Get Related Persons and Emails for details persons and their email per “Related Person” from CARR Approver List.
Set Variables for Autogenerated Complaint Ticket Number.
Update Item – Auto Number Generation List is used for saving current complain number, current month, and current year for Autogenerated Complaint Ticket Number and update on related ID is get from “Get Item – Auto Numbering List”.
Update Item – CARR List is used for update “Request ID”, “Complain Number” and “Related Person” fields and update on related ID is get from “Get Item – CARR List”.
Scope – Grant Access on CARR List’s Item is used for grant access item level permission on current created item and related ID is get from “Get Item – CARR List”. In this scenario, related person can assess edit permission and the rest are view only.