Customer Complaint Management App

Microsoft Form is used to collect Data collection and Data gathering from the Customers.

SharePoint is used as the Database to get response from the Form and also use as a Data source in Power Apps.

· It is used to create a list for the emails of the Customer Service Personnel

Power Apps is used to build an App that allows the Customer Personnel to track the complaints of a Customer.

· It is used to send Feedback messages to the Customers using Power Apps

Power Automate is used to create flow that:

· Get response from Microsoft Form to the SharePoint list

· Notify the Customer Personnel through the App and email every time a new complaint is added.

Microsoft Form allows your users to quickly and easily create custom quizzes, surveys, questionnaires, registrations and more

Organizations use Microsoft SharePoint to create websites. You can use it as a secure place to store, organize, share, and access information from any device.

Power Apps is a suite of apps, services, and connectors, as well as a data platform, that provides a rapid development environment to build custom apps for your business needs

Power Automate is a tool for automating processes and tasks by connecting different applications and platforms

Create a Microsoft Form

Create SharePoint List

Add Image control (A control that shows an image from, for example, a local file or a data source) to the Screen.

Add the Image URL to the Image Property

“https://blog.hubspot.com/hubfs/customer-complaint.jpg"

Change the Image Position Property (The position (Fill, Fit, Stretch, Tile, or Center) of an image in a screen or a control if it isn’t the same size as the image)

ImagePosition.Fill

Change the Fill Property (the background color of a control) of the Screen

RGBA(232, 232, 232, 1)

Add Button control ((A control that the user can click or tap to interact with the app) to the Screen

Change the Text Property (appears on a control or that the user types into a control) of the Button control

“Get Started”

Change FontWeight Property (the weight of the text in a control: Bold, Semibold, Normal, or Lighter) of the Button control

Bold

Change the Fill Property (the background color of a control) of the Button control.

RGBA(0, 51, 102, 1)

Change the OnSelect Property (specify the default action to take when the user clicks or taps an item in the gallery) of the Button control

Navigate(‘Complain Management Screen’,ScreenTransition.Fade)

Select New screen, and then select the Blank Screen

Add Rectangle icon to the Screen

Add Label control (shows data that you specify as a literal string of text, which appears exactly the way you type it, or as a formula that evaluates to a string of text) to the Screen

Change the Text Property in the Label control

“Customer Complain Management”

Change the Size Property (The font size of the text that appears on a control) of the Label Control

Change the FontWeight of the Label Control

Bold

Change the Color Property of the Label control

RGBA(255, 255, 255, 1)

Group the Rectangle Icon and Label control

Change the Theme of the Screen Steel

Add a Blank Vertical Gallery control (is a type of control that can display a set of records from a data source)

Change the layout of the Gallery control at the Right hand side of the pane to Body, Title and Body

Add Data Source from the SharePoint list

Add Text Input control (A box in which the user can type text, numbers, and other data) to the Screen

Add ComboBox control ( is used to display a drop-down list of various items) to the Screen

Change the Item Property of the ComboBox control

Choices(‘Customer Complaints’.Status)

In the ComboBox control, Switch off Allow Multiple Selection at the Right hand side of the Pane, then Switch on Allow Searching

Change the Item Property (one single record from the table configured under DataSource property) of the Gallery

Filter(‘Customer Complaints’, (StartsWith(Title, TextInput1.Text) Or StartsWith(Email, TextInput1.Text)) And (ComboBox1.Selected.Value = Blank() || Status.Value = ComboBox1.Selected.Value))

Add Button control to the Gallery

Change the Text Property of the Button control

ThisItem.Status.Value

Change the Fill Property of the Button Control

Switch(ThisItem.Status.Value,
“Open”,
Red,
“In Progress”,
Yellow,
“Completed”,
Green)

Change the DisplayMode Property of the Button control

DisplayMode.View

Change the Transition Property (the visual effect (Pop, Push, or None) when the user hovers over an item in a gallery) of the Gallery

Transition.Pop

Change the Template Fill Property (the background color of a gallery) of the Gallery

If(ThisItem.IsSelected, RGBA(0, 51, 102, 1), RGBA(0, 0, 0, 0))

Change the Color Property of the the Gallery

If(ThisItem.IsSelected, White, Black)

Add Edit Form (update one or more fields in a single record (or create a record starting with default values), and save those changes back to the underlying data source) to the Screen

Change the Column of the Form to 1 at the Right hand side of the Pane

Add Data Source

Change Fill Property of the Form

RGBA(0, 0, 0, 0)

Change the DisplayMode Property (The mode to use for data cards and controls within the form control) of some part of the Form

DisplayMode.View

Add Button control to the Screen

Change the Button control, Text Property

“Reply”

Change the OnSelect Property (specify the default action to take when the user clicks or taps an item in the gallery) of the Button control

Office365Outlook.SendEmailV2(Gallery2.Selected.Email, “Feedback to your complaints”,
“Dear “ & Gallery2.Selected.Title & “,<br>

This is a feedback to your complaint that was logged with us.<br>
Complaint: “ & Gallery2.Selected.Complaint & “<br>
Status: “ & DataCardValue5.Selected.Value & “<br>
Feedback: “ &
DataCardValue6.Text& “<br><br>

Thank you
“);
SubmitForm(Form1)

Change the DisplayMode Property of the Button control

If(Form1.Valid, DisplayMode.Edit, DisplayMode.Disabled)

Change the OnSucess Property (Actions to perform when a data operation has been successful)of the Form

Notify(“Response Sent”, NotificationType.Success, 3000)

Create a Trigger When a response is submitted (Microsoft Form)

Add the Action Get response details (Microsoft Form)

Add Initialize Variable to the flow

Add Create Item (SharePoint)

Added an action Get Items (SharePoint)

Add Apply to each

Add Append to array variable

Add the action, Send push notification (V2)

Add Send an email (V2)

Save

I had an issue after adding the Filter function to the Gallery, nothing was showing in the screen

Had to reload the page and noticed it was network.

I had an Issue with using the Button Control in the Gallery to show the Status from my SharePoint list.

The Issue was that I was using the Button control in the Screen instead of the Gallery.

I had an Issue with using the Reply Button on the OnSelect Property of the Button control.

The issue was that in my formula the DataCard and Gallery was wrong.

Thank you for Reading!!!

Follow!!!

You can find me on Linkedln, Twitter and Github

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Rachel Irabor

Rachel Irabor

Power Platform Advocate | Power Platform Developer | just a girl doing what she loves