'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Build External Forms and Automated Workflows with Microsoft Tools
Question details
The user needs to identify the best Microsoft tools for building customized external forms, setting up automated follow-up emails, and creating multi-page information experiences.
- Product
- Microsoft Power Apps, Power Automate, Microsoft Forms
- Device & OS
- not provided
- Scenario
- Creating customized data collection workflows for external users that require branching logic and automated email follow-ups.
- Observed behavior
- Microsoft Forms lacks advanced customization, while Power Apps combined with Power Automate offers robust functionality but introduces complex licensing requirements for external guest users.
Verify your Microsoft 365 tenant licensing structure, specifically checking if your organization allows Azure Active Directory (Azure AD) guest access and if you have available licenses for external Power Apps users.
Use Power Apps and Power Automate for Maximum Customization
Combine Power Apps for multi-page external forms and Power Automate for robust background triggers and customized email workflows.
Power Apps provides advanced customization for multi-page forms, while Power Automate seamlessly integrates to send automated follow-up emails based on user inputs.
Note that sharing Power Apps with external users requires specific guest licensing configurations via Azure AD B2B collaboration.
Log into Power Apps and create a Canvas App designed with your required multi-page form experience.
Navigate to the app settings and share the Canvas App with guest users by inviting them to your Azure AD tenant.
Open Power Automate and create a new automated cloud flow triggered by the OnSubmit action from your Power App.
Add an action in your flow to 'Send an email (V2)' using dynamic content gathered from the Power App form fields.
Use Microsoft Forms with Power Automate as a Licensing Workaround
A more accessible option if external licensing is a blocker, combining generic Microsoft Forms with automated email triggers.
Need a Simpler Solution? Try WPS Office
If Microsoft's Power Platform licensing requirements are too complex for your external data sharing needs, consider WPS Office. It provides a lightweight, free alternative for managing documents and analyzing exported form data with full Microsoft Office compatibility.
- 1. Download and Install: Get WPS Office for free from the official website and install it on your device.
- 2. Manage Data Easily: Open exported CSV or Excel form data in WPS Spreadsheet to analyze external responses.
- 3. Share Documents: Share your consolidated reports and documents with external users without worrying about premium guest licenses.
Frequently Asked Questions
Can external users fill out Microsoft Forms without a license?
Yes. Microsoft Forms can be set to 'Anyone can respond,' which allows external users to submit data without needing a Microsoft 365 license. However, it lacks the advanced customization found in Power Apps.
How do I share a Power App with an external guest?
You must invite the external user to your Azure Active Directory as a guest. Once they accept the invitation and have the appropriate Power Apps license assigned, you can share the Canvas App with them via the sharing menu.
Does Power Automate require premium licenses for sending emails?
Sending standard automated emails via the Outlook or Office 365 connector is generally included in basic Microsoft 365 licenses. However, connecting to certain premium external databases or third-party services requires a Power Automate Premium license.
Can Microsoft Forms handle multi-page customized experiences?
Microsoft Forms supports basic branching logic to show or hide questions based on previous answers, enabling a somewhat dynamic experience. However, it does not support complex multi-page data flows, custom user interfaces, or interactive data validation like Power Apps.
