Forum Discussion
FSHNL21
Sep 03, 2024Copper Contributor
Is copilot capable of rebuilding an EXISTING PowerPoint presentation based on a referenced POTX
Copilot told me it is possible "Yes, it is indeed possible to use Copilot for M365 in PowerPoint to open an old presentation and prompt Copilot to rebuild it using a specific company template.......A...
- Apr 09, 2022
This is just playing with dynamic array solutions. Each formula needs to be applied row by row. BYROW is the obvious solution but only accepts one array whereas MAP accepts multiple parameters but will not extract the row to search from an array.
= BYROW(dateArr, LAMBDA(keyDate, XLOOKUP("", keyDate, status,"-",-1,-1) ) ) = BYROW(firstDateArr:dateArr, LAMBDA(a, XLOOKUP(a firstDateArr, a dateArr, status,"-",-1,-1) ) )
The trick in the second formula is the intersection of the original arrays with the dynamic row 'a'.
Alternatively, using MAP,
= MAP(firstDateArr,keyDatesϑ, LAMBDA(crit,datesϑ, XLOOKUP("", datesϑ(),status,"-",-1,-1) ) ) = MAP(firstDateArr,keyDatesϑ, LAMBDA(crit,datesϑ, XLOOKUP(crit, datesϑ(),status,"-",-1,-1) ) )
The trick here is that the array of key dates has been passed as a thunk, so allowing MAP to work with it. In the formula, each scalar thunk is expanded to a row array by the term datesϑ().
keyDatesϑ = BYROW(dateArr,Thunkλ); Thunkλ = LAMBDA(x,LAMBDA(x))
To create a two-dimension array of results is possible but lacks elegance.
FSHNL21
Sep 04, 2024Copper Contributor
Hi Ankur, thanks for your reply. Much appreciated. I tried it but did not get the desired result. This is what happened:
My prompt: Change this presentation using the powerpoint template [url to POTX on SharePoint]
Copilot "Creating a new presentation will replace your existing slides, so you may want to save a copy first. Do you want me to make changes?"
My prompt: Yes, please
Copilot "Sorry, I can’t do that just yet. For now, I can only create a presentation from a Word or PDF document. Start typing the name of a file, or copy and paste a link, and I’ll make some slides for you to edit."
I also tried with other wordings like Rebrand, Rebuild.
My prompt: Change this presentation using the powerpoint template [url to POTX on SharePoint]
Copilot "Creating a new presentation will replace your existing slides, so you may want to save a copy first. Do you want me to make changes?"
My prompt: Yes, please
Copilot "Sorry, I can’t do that just yet. For now, I can only create a presentation from a Word or PDF document. Start typing the name of a file, or copy and paste a link, and I’ll make some slides for you to edit."
I also tried with other wordings like Rebrand, Rebuild.
Ankur_B
Sep 04, 2024Iron Contributor
Kindly try below steps:
1. Open PowerPoint Template which you want to use for creating a presentation
2. Type Create a presentation from "use the file" then it will prompt a message "Creating a new presentation will replace your existing slides, so you may want to save a copy first. Do you want me to make changes?" Then click yes
1. Open PowerPoint Template which you want to use for creating a presentation
2. Type Create a presentation from "use the file" then it will prompt a message "Creating a new presentation will replace your existing slides, so you may want to save a copy first. Do you want me to make changes?" Then click yes
- FSHNL21Sep 09, 2024Copper ContributorThis is great for creating NEW presentations, however it does not help for rebranding/rebuilding/changing an EXISTING presentation. Tx anyway for your feedback!