How to do more with forms in Power Automate
Here are some less-common things you can do with a form in your automated flows:
- Change the format of dates in a flow
- Change the response submission time zone
- Add a group form to a flow
- Send an email based on a conditional form response
- Convert an attachment on a form to PDF or other file type
- Upload form responses to a Power BI dataset
- Create a lead from a form response
Learn how to customize date formats in a flow.
By default, the form shows the response submission timestamp in the UTC time zone. Learn how to convert the time zone.
If a group is the owner of the form you want to add to a flow, Power Automate doesn't list it in the Form Id.
Go to the form. Copy the Form Id from the URL of the form, and then add it as a custom value.
When you use a form in a flow, you can add a condition that's based on how a user responds to a question in the form. The condition can test a text value or a numerical value. The condition creates two parallel branches, If yes and If no, to which you can add actions.
For example, you can use a condition to email details about a specific event or a general calendar of events, depending on how customers respond on an interest form. To learn more, follow the step-by-step instructions in Create an automated workflow for Microsoft Forms.
Add your form to a flow, and then add the following actions.
- Data Operation - Select
- Data Operation - Create HTML table
- OneDrive for Business - Create file
- OneDrive for Business - Convert file
Learn how to turn Forms surveys into insights with Power Automate and Power BI.