Solved: Re: ,Re: Create a PowerPoint slide in power Automa...

Anonymous · ‎09-02-2020

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

Anonymous · ‎09-10-2020

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

yashag2255 · ‎09-03-2020

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 · ‎09-10-2020

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 · ‎09-10-2020

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 · ‎09-11-2020

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 · ‎12-27-2021

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 · ‎03-18-2022

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.