Power Platform Community Forum Thread Details

Hello Community, quite new to PowerApps and looking guidance or template with a project I would like to see if it's even possible to do. We have a passport office where we have customers walk-in and check in: name, # of applicants, phone and photo only (y/n).

Currently we are using google sheets and I have created Gmail accounts for our passport agents. we have 2 google sheets, one that the customer enters the info and another one that the agents see the same data. The customer sheet has restrictions so they can only type the information needed and they cannot delete, including hiding the phone number and the staff's sheet has access to everything. My thought is if I can build something like clinics have where the customer can enter their info and once submitted it goes back to the check-in screen but the information is available for staff to see and from there be able to check the customer they will be assisting. Eventually I would like customers to see a waiting list display so they can see their spot in the queue and that will update once an agent checks them off. I think I can create the check-in kiosk with no issues, but I would need information on the other aspects of this project. Any feedback is welcome and again thank you all that will respond to this.

Categories:

Building Power Apps

Creating a Customer Check-In Kiosk in PowerApps is a practical and efficient solution for managing walk-ins at your passport office. This project involves setting up a system where customers can easily enter their details, which are then accessible to your staff for processing. PowerApps allows for the development of both customer-facing and staff-facing interfaces, with the ability to control access and actions based on the user type (e.g., guest or logged-in user). Here's how you can structure your project to include these considerations:

Check-In Interface for Customers (Guest View)

Design a User-Friendly Form: Create a form in PowerApps for guest users to check in. This form should include fields for the customer's name, the number of applicants, phone number, and an option to indicate if a photo is needed (yes/no).
Data Validation and Security: Implement validation rules within your PowerApps form to ensure data integrity. Limit what guest users can see and do to prevent unauthorized access to other parts of the app or data.

Data Storage Solution

Utilize Microsoft Dataverse or SharePoint Lists: These platforms are recommended for storing the data collected from the check-in form. They offer robust security features and seamless integration with PowerApps and other Microsoft services.
Configure Access Controls: Ensure that your data storage solution is set up to differentiate between guest users (customers) and staff, granting appropriate permissions to each group.

Staff Interface for Managing Check-Ins (Logged-In User View)

Develop a Secure Interface for Staff: This interface should allow staff members to view, manage, and process customer check-ins. Include functionalities like viewing customer details, updating check-in statuses, and managing the queue.
Implement Role-Based Access Controls (RBAC): Use RBAC within PowerApps to differentiate between guest users and staff. Ensure that only authenticated staff members can access sensitive information and functionalities.

Queue System and Real-Time Updates

Automate Queue Management: Utilize the check-in data (e.g., check-in time) to automatically organize and manage the queue. Display the queue order to customers in a privacy-conscious manner.
Display for Customers: Consider setting up a screen or a section within the customer-facing app to show the current waitlist and updates in real time. Ensure this display respects customer privacy, possibly by using reference numbers instead of personal information.

Implementation Steps:

Start with Basic Functionalities: Focus on building and testing the core features — the customer check-in form and the staff interface. Ensure these work flawlessly before adding more complex functionalities.
Test User Roles and Access: Rigorously test the app to ensure that guests can only access the check-in form and that staff can view and manage check-ins as intended. Adjust the RBAC settings as needed for optimal security and usability.
Iterate Based on Feedback: Collect feedback from both customers and staff during the testing phase. Use this feedback to refine and improve the app.

PowerApps and Microsoft Tools Integration:

Leverage Power Automate: For workflows like sending notifications to staff when a new check-in is registered or updating the queue status, Power Automate can be integrated with PowerApps for seamless automation.
Documentation and Community Resources: Utilize Microsoft's extensive documentation for PowerApps and Power Automate. The PowerApps community forum is also a great resource for support and inspiration.