cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Create a PowerPoint slide in power Automate

Hi,

 

I am looking for a way to create a powerpoint slide from data received. I have seen the PlumSail options, but wondering it there is any other way of creating powerpoint slides. I do not mind a interim step.

 

Thanks

 

Mark

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Hi

 

In the end I created a powerpoint presentation that took all its data from excel sheet.

Then used powerautomate to generate the data in excel sheet from various data sources, this then auto updated into powerpoint.

 

Ta

 

Mark

View solution in original post

6 REPLIES 6

Hi @Anonymous 

 

I believe that creating a PPT directly (Like Excel Online, Word etc) is not directly supported. You can check out the third party connectors (Plumsail as you mentioned and also the Projectum Present it connector). If you think this should be added as a feature, you can raise an idea post or upvote similar existing ones here: https://powerusers.microsoft.com/t5/Power-Automate-Ideas/idb-p/MPAIdeas

 

Hope this Helps!

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Anonymous
Not applicable

Hi

 

In the end I created a powerpoint presentation that took all its data from excel sheet.

Then used powerautomate to generate the data in excel sheet from various data sources, this then auto updated into powerpoint.

 

Ta

 

Mark

Hi @Anonymous 

 

Sound very interesting 🙂. Can you please share some details on how you achieved it and also share the screenshot of the Power automate solution. It will for sure help others who have a similar requirement. 

Anonymous
Not applicable

Hi @CFernandes 

 

This is not strictly speaking a power automate solution. The PA flow just basically writes to a excel table in a standard way.

 

The groovy stuff is done in the Excel / powerpoint.  

Excel.

Simply create master data sheet within a table for PA to access.

Create 1 / many other sheets that have the layout / images / etc you desire, and back ref to the data sheet as required. (This I did to create complex looking forms etc)

 

Powerpoint

Create a slide as required, I used combination of blank ones (Used entire layout from Excel) and detailed ones with specific fields only linked.

Open excel, highlight the cell / cells you with to have in powerpoint.

Powerpoint select Paste special.

Select Excel object.

Select link data

Paste in.

Once pasted in you can resize, move about as if it was a picture. 

 

Save both files.

Now powerpoint will ask to update or not as it opens, do NOT have excel open when you do this. Say yes for first time. (Get a coffee) then save and say no until excel is reloaded with new data.

 

HTH

 

Mark

Do you have an example of the PowerPoint file that we can see? I have the data flowing into excel using Power Automate, but I don't understand the PowerPoint part of your description. Thank you for your help. 

Where were your Excel and PowerPoint files located? I am trying the same thing with Excel and PowerPoint files located in OneDrive, but not able to achieve it. I update the Excel by a Power Automate and then fetch the PowerPoint from OneDrive, but it does not come up as updated.

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (3,395)