Automating Customer Onboarding with Power Automate

MS Form

The form is created in Microsoft Forms, which is a web-based application that allows users to create surveys, quizzes, and polls. The form collects customer data, such as name, address, and identification documents, when a new customer applies for an account. The form is linked to SharePoint Online to store the data.

SharePoint Online

SharePoint Online is a cloud-based service that allows organizations to create, store, and manage content. The customer data collected in the form is stored in a SharePoint list, a collection of data that can be used to store, view, and edit information.

MS Flow

Microsoft Power Automate, also known as MS Flow, is a cloud-based service that allows users to create automated workflows between different applications and services. The flow is created to automate the customer onboarding process, which involves collecting customer data, verifying identities, and creating customer accounts automatically. The flow involves the following steps:

• Trigger: When a new customer applies for an account and submits the form, the flow is triggered.
• Data verification: Power Automate verifies the Customer's identity by cross-referencing the information provided in the form with external databases.
• Compliance checks: Power Automate automatically performs compliance checks to ensure that the Customer's data meets regulatory requirements.
• Account creation: Once the Customer's identity is verified, Power Automate creates a new account for the Customer and sends them a welcome email with their account details.

External databases 

External databases are used to verify the Customer's identity during data verification. These databases could include government databases, credit bureaus, and other external data sources. Overall, the backend architecture involves MS Form for data collection, SharePoint Online for data storage, MS Flow for workflow automation, and external databases for data verification. This architecture provides a seamless and automated customer onboarding process, reducing errors and saving time for ABC Bank.

Implementation

In the above requirement, the MS Form fields could include the following:

• Full name of the Customer
• Email address
• Phone number
• Date of birth
• Address
• Identification documents, such as a passport or driver's license number
• Employment details, such as job title and employer name
• Financial information, such as income and assets
• Purpose of opening the account

Source of funds or wealth

 Additional fields may also be required based on the specific requirements and regulations: https://forms.office.com/r/etpGZ0YRGF.

SharePoint Backend list

We are maintaining three lists here, and each list is linked to a customer-unique ID, which serves as the primary key across all three lists.

Power Automate

1. Create a SharePoint list: Create a new SharePoint list to store the MS Form responses. Make sure the list has columns to store all the required information, such as name, address, and identification documents.
2. Create a Microsoft Form: Create a Microsoft Form with the required fields for collecting customer data, such as name, address, and identification documents.
3. Create a new flow: In Microsoft Power Automate, create a new flow and select the "When an item is created" trigger in SharePoint as the flow's trigger.
4. 4. Connect the SharePoint list: Connect the SharePoint list that you created in Step 1 to the flow.
5. Add an action: Add the "Get response details" action to the flow and select the Microsoft Form that you created in Step 2.
6. Add an action: Add the "Condition" action to the flow and set the condition to check whether the Customer's identity has been verified.
7. Add an action: Add the "Create item" action to the flow and select the SharePoint list that you created in Step 1. This action will create a new item in the SharePoint list with the Customer's details.
8. Add an action: Add the "Send email" action to the flow and select the Customer's email address as the recipient. This action will send an email to the Customer with their account details.
9. Add an action: Add the "Update item" action to the flow and update the SharePoint list item with the Customer's account details.
10. Test the flow: Save and test the flow to make sure it's working as expected. You can test it by submitting a test form and verifying that a new item is created in the SharePoint list and the Customer receives an email with their account details.

 

Email Communication

Approval Email to Manager

Account Details send email to Customer after approval.

Send an email to the Customer after the Manager rejects due to more documents required.