top of page

CARR LIST using Microsoft Power Automate

Updated: May 17, 2023

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

Carr using Power Automate
Power Automate



Workflow using Power Automate
Power Automate

Tip #1


  • Create a CARR item in SharePoint list.

  • Declaration variables for Autogenerated Complaint Ticket Number.












Prevent Duplication using Power Automate
Prevent Duplication

Tip #2


  • 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.




Get relation person using Power Automate
Get relation person

Tip #3


  • Scope – Get Related Persons and Emails for details persons and their email per “Related Person” from CARR Approver List.







Autogenerated ID using Power Automate
Autogenerated ID

Tip #4


  • 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”.



Access Rights using Power Automate
Access Rights

Tip #5


  • 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.

37 views0 comments
bottom of page