Unanswered

Merge data from Microsoft Forms into a PowerPoint Slide

Like (0) Share

Report

Posted on 24 Jan 2024 20:33:21 by dreamdelerium

I would like to create a template PowerPoint slide that would allow for a sort of Mail Merge of data into the template, coming from a MS Form or other UI that I can add data validation rules to. The slide will be template with field names like {{Start_Date}} and {{Slide_Title}} which would correspond to questions in the MS Form. When the user submits, I would like to trigger an event that will take the data and merge it into a PowerPoint template and save it as a copy (to not save over the template). Once the slide is complete, save it in SharePoint folder or download it. Is this something that can be done in Power Automate? I created a flow that would be triggered when the user submits the form. It creates a file in SharePoint, but I don't see how I can take the fields from the Form and merge it into a template. Thanks!

All responses (2)

Answers (0)

Abhoward17 6 on 20 Feb 2024 at 14:47:30

Like (0)

Report

Re: Merge data from Microsoft Forms into a PowerPoint Slide

@dreamdelerium I have been able to do this on a word document for free/without API connectors but not with powerpoint as of yet.

This video helped me set up the flow, but also explained how to set up the meta data needed to support.
Microsoft Forms to PDF without Premium Actions in Power Automate (youtube.com)
dreamdelerium 4 on 25 Jan 2024 at 14:28:07

Like (1)

Report

Re: Merge data from Microsoft Forms into a PowerPoint Slide

Thank you for your response. I took a look at the action you suggested but it seems to require an API key and need to connect to a third party server (www.encodian.com/apikey. I wont be able to connect to any third party solutions for this task. Is there a way to do this with a script or some other method? Thanks!