Best Microsoft Tools for Building Multi-User Request Forms with Power Automate
Question details
The user needs a reliable Microsoft solution to create a multi-user request form with controlled visibility, structured fields, and automated ERP outputs.
- Product
- Microsoft Power Platform
- Device & OS
- not provided
- Scenario
- Creating a scalable data-entry interface where multiple managers can securely submit requests without viewing others' data, which is then processed into an ERP-ready format.
- Observed behavior
- A shared Excel workbook is difficult to secure, lacks structured validation for complex fields, and is hard to manage when trying to restrict row-level visibility.
Verify your organization's Microsoft 365 licensing, as utilizing premium connectors in Power Automate or deploying Microsoft Dataverse may require standalone premium user licenses.
Build a Power App with SharePoint or Dataverse Storage
Combine Power Apps as the front-end interface with Power Automate as the backend workflow engine for full security control and custom data validation.
This approach effectively turns your form into a lightweight business application. By using SharePoint Lists or Dataverse as the database layer, Excel is removed from the data entry process and relegated to its proper role as an output and reporting tool.
Create a new Microsoft List or SharePoint List to store the submitted requests, defining structured columns for job types, payment lines, and manager details.
In your SharePoint List settings, navigate to Advanced Settings and adjust the 'Item-level Permissions' so users can only read and edit items they created, ensuring data privacy.
Create a Canvas App in Power Apps, connect it to your SharePoint List, and design the user interface with specific dropdowns, mandatory fields, and validation logic.
Create a Power Automate cloud flow using the 'When an item is created' trigger. Add actions to split the payment lines as needed, then use the 'Add a row into a table' action to write the processed data into an ERP-ready Excel file.
Use Microsoft Forms and Power Automate for Simple Collections
Deploy Microsoft Forms if your request process is straightforward and does not require complex relational data input or line-splitting within the form interface.
Evaluate Direct ERP Entry or Microsoft Access
Bypass middleware solutions by utilizing existing ERP portal capabilities, or build an isolated local database using Microsoft Access.
Manage Processed Data Efficiently with WPS Office
While Power Apps is ideal for capturing multi-user form data, managing the final exported ERP-ready spreadsheets does not require an expensive Microsoft 365 license. WPS Office offers a lightweight, highly compatible, and free suite to handle all your resulting Excel files, data analysis, and documentation workflows.
- 1. Download WPS Office: Download and install the free WPS Office suite on your PC or Mac.
- 2. Open your exported data: Launch WPS Spreadsheet and open the .xlsx file that Power Automate generated from the user requests.
- 3. Analyze and format: Use built-in data validation, conditional formatting, and filtering to review the structured data before uploading it to your ERP system.
Frequently Asked Questions
Why shouldn't I just use a shared Excel workbook for multi-user requests?
Shared Excel files lack robust row-level security, making it extremely difficult to prevent managers from viewing or editing each other's confidential submissions. They are also prone to accidental data corruption and synchronization issues when multiple users edit the file simultaneously.
Can Power Automate push data directly into my ERP system instead of an Excel file?
Yes. If your ERP system offers an API or has a dedicated premium connector in Power Automate (such as Dynamics 365, SAP, or a custom HTTP connector), you can configure the flow to push validated data directly to the ERP, eliminating the Excel intermediary.
Do I need premium licenses to build a Power Apps request form?
If you connect your Power App to standard connectors like SharePoint Lists or OneDrive, standard Microsoft 365 business licenses are usually sufficient. However, if you choose to store your data in Microsoft Dataverse or connect to SQL Server, premium licenses for users will be required.
How do I ensure managers only see their own requests in SharePoint?
In your SharePoint List, click the gear icon for 'List settings', navigate to 'Advanced settings', and under 'Item-level Permissions', set 'Read access' to 'Read items that were created by the user'. This instantly restricts visibility based on the creator.
