How to Capture the PowerPoint File Name with Microsoft Forms Responses
Question details
The user needs to identify which specific PowerPoint presentation a Microsoft Forms response originated from when the same form is embedded in multiple files.
- Product
- Microsoft PowerPoint, Microsoft Forms, Power Automate
- Device & OS
- not provided
- Scenario
- Tracking and organizing form submissions that are embedded across various PowerPoint presentations using a Power Automate flow.
- Observed behavior
- The 'Get response details' action in Power Automate does not automatically identify or pass the host PowerPoint file name as a response field.
Ensure you have active access to your Power Automate account and hold edit permissions for both the Microsoft Forms being used and the corresponding PowerPoint presentations.
Use Separate Form Links and Map Them in Power Automate
Since Microsoft Forms cannot inherently pull the host file name, you can duplicate the form or use unique tracking links mapped to specific presentations.
Microsoft Forms does not currently support automatically capturing the host application's name or passing hidden URL variables. The most reliable workaround is to create a unique identifier at the source level before the response reaches Power Automate.
Go to Microsoft Forms and copy your original form so that you have a dedicated version for each PowerPoint presentation.
Open your PowerPoint files and insert the unique form link that corresponds to that specific presentation.
In Power Automate, create an automated cloud flow using the 'When a new response is submitted' trigger for your forms.
Add a 'Switch' or 'Condition' action in your flow to check the Form ID. Route the data to your destination (like Excel or SharePoint) while manually appending the corresponding PowerPoint file name based on which form triggered the flow.
Add an Explicit Identifier Question to Your Form
Prompt respondents to manually select or input the name of the presentation they are viewing.
Try WPS Office for Your Presentation Needs
While advanced workflows like Power Automate require the Microsoft ecosystem, if you are looking for a fast, lightweight, and highly compatible tool to design stunning presentations, WPS Office is an excellent free alternative.
- 1. Download WPS Office: Visit the official WPS Office website to download the free suite for your device.
- 2. Install and Launch: Run the installer and open WPS Presentation.
- 3. Open Existing Presentations: Seamlessly open, edit, and save your existing .pptx files with full formatting preservation.
Frequently Asked Questions
Can Power Automate extract the URL of the PowerPoint file where a form is embedded?
No, the Microsoft Forms triggers in Power Automate only capture the form data and respondent details. They do not capture the hosting environment or parent application's URL.
Is there a way to pass hidden variables in Microsoft Forms URLs to track the source?
Unlike some third-party survey tools, Microsoft Forms does not currently support passing hidden fields or URL parameters to pre-fill data. You must rely on separate forms or explicit questions.
Where can I get help for complex Power Automate flows?
For advanced automation design and troubleshooting, it is highly recommended to visit the official Microsoft Power Automate Community forums where experts can review your specific flow logic.
