'%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 Send Power Pages Emails Only After Complete Form Updates
Question details
The user needs to prevent duplicate emails from being sent during multistep Power Pages form submissions or administrative approval updates.
- Product
- Power Pages
- Device & OS
- not provided
- Scenario
- Configuring Power Automate email notifications for multistep form submissions without sending premature or duplicate emails.
- Observed behavior
- Duplicate Power Automate emails are triggered incorrectly when users complete intermediate steps or when administrators approve or reject submissions.
Ensure you have environment maker permissions in Microsoft Power Platform to edit Dataverse tables and modify Power Automate flow trigger conditions.
Configure Dataverse Status Flags and Power Automate Trigger Conditions
Use status values in Dataverse to distinguish a completed form submission from intermediate steps or administrative changes, and apply trigger conditions to your flow.
Multistep Power Pages forms update the Dataverse record at each step. If your flow triggers on every update, it will result in duplicate emails. By defining a specific 'Status' column and utilizing Power Automate trigger conditions, you can ensure the workflow only fires when the final step is submitted.
In the Power Apps maker portal, navigate to Dataverse > Tables, select your table, and add a Choice column named 'Submission Status' with options like 'Draft', 'Submitted', and 'Approved'.
Configure the final step of your Power Pages multistep form to automatically update the 'Submission Status' column to 'Submitted' upon completion.
Open your flow in Power Automate. Select the Dataverse 'When a row is added, modified or deleted' trigger, click the three dots (...), and go to Settings.
Under Trigger Conditions, click 'Add'. Enter an expression to ensure the flow only runs when the status changes to 'Submitted'. For example: @equals(triggerOutputs()?['body/your_status_column_logical_name'], 1).
To prevent administrative approvals from triggering the email, add a Boolean column 'Notification Sent' in Dataverse. Update this flag to 'Yes' at the end of your flow, and add a secondary trigger condition so the flow only runs when this flag is 'No'.
Looking for a Seamless and Free Office Alternative?
While Power Pages handles your complex web forms, you often need a reliable office suite to analyze exported form data, draft administrative reports, and prepare presentations. WPS Office provides a lightweight, free, and familiar alternative to Microsoft Office.
- 1. Download the Installer: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Install the Software: Run the downloaded setup file and follow the on-screen instructions to install WPS Office on your device.
- 3. Open and Edit Your Files: Open your exported .xlsx form data or .docx reports directly in WPS Office with complete format compatibility.
Frequently Asked Questions
Why does my multistep Power Pages form send multiple emails?
Multistep forms save data back to the Dataverse table at the end of each step. If your Power Automate flow is triggered on 'Row Modified' without specific status conditions, the completion of every individual step will trigger a new email.
How do I find the correct Dataverse column logical name for my trigger condition?
Go to the Power Apps maker portal, select Dataverse > Tables, open your table, and navigate to Columns. Click on your status column and look for the 'Logical name' in the properties pane, which typically starts with a publisher prefix like 'cr_'.
Can I use a 'Processed' flag to prevent duplicate emails?
Yes. You can add a Yes/No (Boolean) column named 'Email Sent' in Dataverse. Once your Power Automate flow successfully sends the email, have it update this column to 'Yes'. Adding a trigger condition to check that 'Email Sent' is 'No' will prevent future updates from re-triggering the email.
