Download the PDF for all resources covered in this video - vtns.io/ytvstartlearningofficeaddins23 I scour all the Microsoft & community resources so YOU DON'T HAVE TO. Save time & stay informed. Each issue contains all the news you need in less than 5 minutes every other Tuesday plus my insights & guidance on a trending topic. Subscribe to my bi-weekly newsletter & join 9,000+ fellow M365 developers! vtns.io/ytvnewsletter! No clickbait · 100% free · unsubscribe anytime.
VS Code Extension is deprecated you can use office-addin-debugging npm package which is fine i was not able to setup debugger directly in vs code i have to use edge dev tools
You bet! If you like it, can you like the video & subscribe to the channel? It tells RUclips that others might like this as well and helps me grow 🙏. Also, mind sharing on whatever social platforms (if any) you're on? TIA!
@Andrew_Connell I paid for the course and ran out of time to thoroughly study the material due to other commitments. I've shared with coworkers but will also share away
Thanks! I haven't tried to access local storage within an Add-in, but because it's just hosted within a browser, I'd assume you could do it the same way you'd do it in a web app.
Nice video. Is it possible to create a PowerPoint add-in that fetches data from a SharePoint library (say a PowerPoint template) and clicking on that changes the slide template?
Thanks! Yes, you can do everything you asked about for sure, but I'm unsure exactly what things you can edit from the add-in. I believe so, but not 100% certain. If you can do it with the OpenXML SDK for the PPTX file, then you def. could.
Thanks a lot for the free course! Really helpful... However I didn't find the solution for the problem Im struggling... We've developed a custom add in with react js which, after deployment, it's working in web/new version outlook but never worked at classic version. Ive been researching for a month with no success... Any idea? Thans in advance!
Hey Andrew, I need to add authentication on top of excel add in using Auth0, I'm not finding any documentation/fruitful discussion in Auth0 community. If you have any idea or resource it'd be helpful. Thanks
Yup, you definitely can do that... Microsoft hired me to write this Microsoft Learning module for them a few years ago. I can't say how current it is or if there are bugs in it due to dependencies or tooling updates, but this might help - learn.microsoft.com/en-us/training/modules/office-add-ins-sso/?WT.mc_id=M365-MVP-21083. It's also available as playlist on RUclips from the Microsoft 365 Developer channel (I recorded & published it)... again, it's a bit dated because I haven't been hired to refresh the content in a few years - ruclips.net/video/kf_VMt_Eh0M/видео.html I've been thinking about doing some videos on Office Add-ins... sounds like you'd be interested in that! eh?
Hey, is it possible to develop word add-in that would intercept save button action (or perhaps create my own save button) that will actually create PUT HTTP request toward server from which file actually came with GET tokenized request. The goal is actually to provide clients to edit word documents without downloading them on their local PC. What type of add-in should I use here? Thanks in advance.
Microsoft doesn’t let us change the behavior of existing buttons and controls in the menu/ribbon. While you can create your own button in the ribbon/task pane to do something, I don’t think you can save the whole doc to another location, only the contents of the file.
@@Andrew_Connell I don't want to save doc to another location, I want to save it to same location from which I got document with GET tokenized request. Flow would be something like: User clicks edit in word inside some website It uses Office URI scheme to open it locally in Word User edits file in Word and can press custom save button to actually send PUT request to same site he got file from and he uses same token he got in GET request That should be some kind of ADDON actually and what really makes me confused id so many types of add-ins that exist, should I use COM, Office, VSTO...?
So, add-ins will let you access the content WITHIN the document, not the document itself. So I don't think you can do that. IMHO, I would not use COM/VSTO... that's old tech that's no longer supported or recommended.
No... all web resources used in an Office Add-in must be hosted by the provider (developer / you). The only thing you deploy to Office is your manifest that tells the Office client what your Add-in can do & where the resources are located. This means you have to deploy the web resources to your own server/host.
Hello, this was a great video ! I have a couple of question about office js and powerpoint. I have made an addin for powerpoint but i was just wondering do we always have to build with webpack? Is there a way to get the add in to work without building it? If so/not, why?? Thank you
Yes, there's no technical requirement when creating Office Add-ins that says you need to use webpack... it just needs to be a web app. Webpack was chosen for the toolchain Microsoft created. If you're using Yo Office to create your add-in, while I don't want to say it's required, it's going to be a good bit of work to remove it. But with that being said, you don't have to use webpack or Yo Office at all... you can build any web app and use it. Yo Office just adds the helpful debugging stuff for you, but you can implement that yourself if you want.
Ive been developing a mern fullstack office add in for word and am struggling to deploy it. do you have any advice or know where i can find helpful information
What seems to be the problem about the deployment? Is the issue with deploying the Add-in to your organization or the store? Or is it it an issue deploying the cloud resources that implement the Add-in?
@@Andrew_Connell i am trying to deploy it to my organisation centrally but is the deployment the same it would be the any other mern application. do i need to host the server and client online then after that do i need to make changes to the webpack or manifest file?
@@hunterx331 You'll need to deploy your cloud resources (those assets that run your add-in) somewhere. Once that's done, you need to update the manifest file to point to the location where the web/cloud resources are hosted. Once you've done that, you can then package the Add-in manifest again and deploy it to your organization.
Is it possible to develop a add-on to save the email and attachments to a EC server ? Or EC server will not allow to connect from Outlook add-on? Thanks in advance
Sort of... if you're in SharePoint Online, you could get the ID of the email that calls out to your custom API. Your API could then use the Microsoft Graph to get the details of the email and do whatever you want with it. What do you mean by "EC server"?
The steps to create an Add-in for all Office clients are the same. When you deploy & install it to Office, you're doing it for all your Office clients.
Download the PDF for all resources covered in this video - vtns.io/ytvstartlearningofficeaddins23
I scour all the Microsoft & community resources so YOU DON'T HAVE TO. Save time & stay informed. Each issue contains all the news you need in less than 5 minutes every other Tuesday plus my insights & guidance on a trending topic. Subscribe to my bi-weekly newsletter & join 9,000+ fellow M365 developers! vtns.io/ytvnewsletter! No clickbait · 100% free · unsubscribe anytime.
VS Code Extension is deprecated you can use office-addin-debugging npm package which is fine i was not able to setup debugger directly in vs code i have to use edge dev tools
Which VS Code extension are you referring to?
Thank you Andrew for making this free!
You bet! If you like it, can you like the video & subscribe to the channel? It tells RUclips that others might like this as well and helps me grow 🙏. Also, mind sharing on whatever social platforms (if any) you're on? TIA!
@Andrew_Connell I paid for the course and ran out of time to thoroughly study the material due to other commitments. I've shared with coworkers but will also share away
@@steveschaff8848 Thank you!
Hey Awesome tutorial ✨
I just have one question how do I use local storage on Macos/Windows version of Word?
Thanks!
I haven't tried to access local storage within an Add-in, but because it's just hosted within a browser, I'd assume you could do it the same way you'd do it in a web app.
Nice video. Is it possible to create a PowerPoint add-in that fetches data from a SharePoint library (say a PowerPoint template) and clicking on that changes the slide template?
Thanks! Yes, you can do everything you asked about for sure, but I'm unsure exactly what things you can edit from the add-in. I believe so, but not 100% certain. If you can do it with the OpenXML SDK for the PPTX file, then you def. could.
Thank you. It was really informative.
Glad it was helpful!
Thanks a lot for the free course! Really helpful... However I didn't find the solution for the problem Im struggling... We've developed a custom add in with react js which, after deployment, it's working in web/new version outlook but never worked at classic version. Ive been researching for a month with no success... Any idea? Thans in advance!
You’re welcome! As for the issue, hard to say without more info. Any error or messages?
Hey Andrew, I need to add authentication on top of excel add in using Auth0, I'm not finding any documentation/fruitful discussion in Auth0 community. If you have any idea or resource it'd be helpful. Thanks
Yup, you definitely can do that... Microsoft hired me to write this Microsoft Learning module for them a few years ago. I can't say how current it is or if there are bugs in it due to dependencies or tooling updates, but this might help - learn.microsoft.com/en-us/training/modules/office-add-ins-sso/?WT.mc_id=M365-MVP-21083.
It's also available as playlist on RUclips from the Microsoft 365 Developer channel (I recorded & published it)... again, it's a bit dated because I haven't been hired to refresh the content in a few years - ruclips.net/video/kf_VMt_Eh0M/видео.html
I've been thinking about doing some videos on Office Add-ins... sounds like you'd be interested in that! eh?
yes, currently working on web application with okta auth0 authentication, we want to integrate it with ms excel, so exploring on that
Hey, is it possible to develop word add-in that would intercept save button action (or perhaps create my own save button) that will actually create PUT HTTP request toward server from which file actually came with GET tokenized request. The goal is actually to provide clients to edit word documents without downloading them on their local PC. What type of add-in should I use here?
Thanks in advance.
Microsoft doesn’t let us change the behavior of existing buttons and controls in the menu/ribbon.
While you can create your own button in the ribbon/task pane to do something, I don’t think you can save the whole doc to another location, only the contents of the file.
@@Andrew_Connell I don't want to save doc to another location, I want to save it to same location from which I got document with GET tokenized request. Flow would be something like:
User clicks edit in word inside some website
It uses Office URI scheme to open it locally in Word
User edits file in Word and can press custom save button to actually send PUT request to same site he got file from and he uses same token he got in GET request
That should be some kind of ADDON actually and what really makes me confused id so many types of add-ins that exist, should I use COM, Office, VSTO...?
So, add-ins will let you access the content WITHIN the document, not the document itself. So I don't think you can do that.
IMHO, I would not use COM/VSTO... that's old tech that's no longer supported or recommended.
Thank you very much
@@ivobralic5867 You're welcome!
can you have an office addin that is self contained and does not use/need a web server ?
No... all web resources used in an Office Add-in must be hosted by the provider (developer / you). The only thing you deploy to Office is your manifest that tells the Office client what your Add-in can do & where the resources are located. This means you have to deploy the web resources to your own server/host.
Hello, this was a great video ! I have a couple of question about office js and powerpoint. I have made an addin for powerpoint but i was just wondering do we always have to build with webpack? Is there a way to get the add in to work without building it? If so/not, why?? Thank you
Yes, there's no technical requirement when creating Office Add-ins that says you need to use webpack... it just needs to be a web app. Webpack was chosen for the toolchain Microsoft created.
If you're using Yo Office to create your add-in, while I don't want to say it's required, it's going to be a good bit of work to remove it.
But with that being said, you don't have to use webpack or Yo Office at all... you can build any web app and use it. Yo Office just adds the helpful debugging stuff for you, but you can implement that yourself if you want.
Ive been developing a mern fullstack office add in for word and am struggling to deploy it. do you have any advice or know where i can find helpful information
What seems to be the problem about the deployment? Is the issue with deploying the Add-in to your organization or the store? Or is it it an issue deploying the cloud resources that implement the Add-in?
@@Andrew_Connell i am trying to deploy it to my organisation centrally but is the deployment the same it would be the any other mern application. do i need to host the server and client online then after that do i need to make changes to the webpack or manifest file?
@@hunterx331 You'll need to deploy your cloud resources (those assets that run your add-in) somewhere. Once that's done, you need to update the manifest file to point to the location where the web/cloud resources are hosted. Once you've done that, you can then package the Add-in manifest again and deploy it to your organization.
Is it possible to develop a add-on to save the email and attachments to a EC server ? Or EC server will not allow to connect from Outlook add-on? Thanks in advance
Sort of... if you're in SharePoint Online, you could get the ID of the email that calls out to your custom API. Your API could then use the Microsoft Graph to get the details of the email and do whatever you want with it.
What do you mean by "EC server"?
@@Andrew_Connell EC - Enterprise Cloud server. We were planned to store the files on the server
Sir, how to develop outlook addin for Apple iPad?
The steps to create an Add-in for all Office clients are the same. When you deploy & install it to Office, you're doing it for all your Office clients.