Create a PowerPoint slide in power Automate

[Anonymous]

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

[yashag2255]

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 · Accepted solution]

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

[CFernandes]

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]

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

[mike1084]

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. 

[CuriousToKnow]

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.

[jmbyers523]

👏 genius

[Anonymous]

Hey @yashag2255 
Have they released this feature?

[igor_noberto]

From what I understood, you updated the excel data using Power Automate, but to update the visual in Power Point, you have to open manually both files to sync data between them.

Right?

[viplavmulkacpm]

Doesn't this require the excel sheet to be opened once for the data to be updated on PPT?

[aabrhn1999]

can you give me an example of this?