Complete MS Word Template Project for 2024 with Power Platform and SharePoint

  Рет қаралды 2,341

Andrew Hess

Andrew Hess

Күн бұрын

We are going to create an entire project using MS Word Templates, SharePoint, Power Apps, and Power Automate. I believe this will be a 3 part project so stay tuned for the next 3 weeks!
In this video we set up a Document Library in SharePoint with Word Templates. Today we use out of the box templates that Microsoft gives us in Word.
We use a certificate template and a memo template.
And today we use content types for our templates! In SharePoint, content types serve as reusable collections of metadata (columns), workflows, behaviors, and other settings that can be applied to certain types of documents or items. By using content types as templates, organizations can ensure consistency and adherence to compliance requirements across their documents and lists, making it easier to manage and search for content. They enable the customization of information management policies, document templates, and forms on a granular level, enhancing the efficiency of document management processes and collaboration within the platform.
Chapters:
0:00 Introduction
0:22 The Entire Project
1:50 Create a SharePoint Site
4:40 Creating Site Columns
7:19 Creating Site Content Types
9:26 Making a New Document Library
12:50 Adding the Content Types with Templates
15:12 Adding Quick Parts
19:49 Testing

Пікірлер: 27
@andrewhess123
@andrewhess123 5 ай бұрын
Next week, we will integrate Power Apps!
@Untethered365
@Untethered365 5 ай бұрын
Very cool! I was wondering when Power Platform comes in so looking forward to that.
@andrewhess123
@andrewhess123 5 ай бұрын
There was a ton of set up, people had asked me not to skip steps. So trying to take it a little slower, and go into full detail of the setup @@Untethered365
@mehtabidreesi7942
@mehtabidreesi7942 5 ай бұрын
Sir please make a video in which like a project in which you use 1- Collections 2- Third party integration 3- Lookup and filter 4- Variable 5-Expand and Collapse in PowerApps 6- Patch and Submit button 7- For All or Loops 8- Variable and compose function in power automate Please Sir
@TheBigBosske
@TheBigBosske 5 ай бұрын
I had no idea you could force to open in App, great tip here. One remark, why not having two Sharepoint libraries for integration purpose. One with main data for the main category/template structure ("Main category" list, put main data for "Memo", 'Certificate", "Decisions", "^NameFile.docx", etc. or by clients' design - "Client A", "Client B") then use another list in which you have the 'ad hoc' data (date, reference number... and a column linking to the main cat). In Power App; user can then select first the main cat and get a prefilled form to key-in ad hoc. Not sure if you follow me :) I had no knowledge of Power App when I started my project, so I was not keen having hundreds of choices in the dropdown list. But yeah, in regards user side, the most important is to keep them away from Sharepoint and provides templates/ad hoc document through an App; the way Sharepoint handles files opening is really bad. As always, great tutorial! I can see you have done it all here (from user administration to integrated site columns with content control, nice!
@andrewhess123
@andrewhess123 5 ай бұрын
I think that idea is good too. There are so many ways to do these templates as soon as I create a video, I'm ready to change my idea! Splitting between libraries could be a good idea too. And yes I follow you, totally agree again. It's so hard to stick with 1 idea and say it's the best 😆
@mehtabidreesi7942
@mehtabidreesi7942 5 ай бұрын
@@andrewhess123 Sir please make a video in which like a project in which you use 1- Collections 2- Third party integration 3- Lookup and filter 4- Variable 5-Expand and Collapse in PowerApps 6- Patch and Submit button 7- For All or Loops 8- Variable and compose function in power automate
@CesareVesdani
@CesareVesdani 2 ай бұрын
What are the very best Word document templates for letters and memos that you can create?
@DrVaruntyagi
@DrVaruntyagi 5 ай бұрын
Hello andrew, I have been following your videos to create a workflow surrounding templates for discharge summaries. This will ease up some burden on us junior doctors. I was hoping if you could guide me for it? Will be really helpful for the entire team. Thanks.
@andrewhess123
@andrewhess123 5 ай бұрын
Currently I work for the Government and my time is limited. Are these videos enough to guide you? Or are you looking for more than just these youtube videos? I could always tailor a video to your needs?
@thomasgoerlach5766
@thomasgoerlach5766 4 ай бұрын
Many thanks for this nice explanation. I would like to apply this idea to generate invoices, which consist of several line items. Do you have an idea how this could be implemented following your approach?
@andrewhess123
@andrewhess123 4 ай бұрын
Hi thomas, so I have a video that uses Templates with Repeating rows, is that what you are looking for? kzfaq.info/get/bejne/octmlriI387ViKM.html
@thomasgoerlach5766
@thomasgoerlach5766 4 ай бұрын
@@andrewhess123 Hi Andrew, thanks for the answer. In principal yes, but I would like to avoid the premium license. It seems the only way to do is to build in Power Apps the invoice template and to transfer it to a PDF?
@andrewhess123
@andrewhess123 4 ай бұрын
Avoiding the premium with dynamic lists seems like you should create an HTML Table and use the PDF option in Power Apps. Another option is to use Power Automate and only use 1 premium license on a schedule instead of many Power Apps premium licenses, to keep costs lower.@@thomasgoerlach5766
@andrewhess123
@andrewhess123 5 ай бұрын
If you gain anything out of this video, I think one of the most important things to do as a SharePoint Developer is to not put spaces in column names, lists or libraries. At @10:17 I explain into detail why.
@TheBigBosske
@TheBigBosske 5 ай бұрын
Yes!! One way to get the column name is to go to list Settings and select the column, then name will show in the URL. Another great important thing, make all column as basic text.... don't even bother having Dates, Numbers, etc., this will only make your life complicated.
@andrewhess123
@andrewhess123 5 ай бұрын
Totally agree!@@TheBigBosske
@buildinglegacywithderricka6492
@buildinglegacywithderricka6492 Ай бұрын
Is there a way to use a drop down list to say select Project type if there were 5 and you didn't want to type it in everytime?
@andrewhess123
@andrewhess123 Ай бұрын
Yes one option I would make a Power App that's connected to the SharePoint list or Integrate a Power App in the SharePoint list.
@paulburns2814
@paulburns2814 5 ай бұрын
Hi Andrew, another very informative video; can you help as I can't open the document in the 'App' opens fine in the browser. Not sure if I've done something wrong or due to my laptop set up?
@andrewhess123
@andrewhess123 5 ай бұрын
Hi Paul, long time no see! Hmmm... when you create a new document can you open the template? Or if you go to Library Settings, and then the Content Type, can you Edit the template there and open in the app?
@paulburns2814
@paulburns2814 5 ай бұрын
Thanks Andrew, I finally managed to get it to open in the App, my system was at fault! My own work has been very busy for the past year so, trying to learn this has had to been put on hold, whilst I make a living. Work has a habit of blocking my hobbies!@@andrewhess123
@nevinroyath5928
@nevinroyath5928 5 ай бұрын
Another brilliant video Andrew! Quick question, is there an easy way to change the name from Certificate.docx and memo.docx after you populate the metadata. For eg. if I want to use the Certificate template three times, will the Name column be Certificate1, Certificate2, Certificate3 etc. or is this something I need to change after I enter the metadata? Hope that all makes sense! Really love your content. Have been following you since your first video was released. Keep up the good work!!
@andrewhess123
@andrewhess123 5 ай бұрын
I would use the date in the name, that way each document is unique. I believe you could probably pull in the name as a quick part metadata too directly in the template. We could probably update it in the Power App or Power Automate also. I'll have to see if I can cover it in the next video. Appreciate the support Nevin!!
@nevinroyath5928
@nevinroyath5928 5 ай бұрын
Awesome can't wait 😎
@kland1558
@kland1558 5 ай бұрын
Is there a reason you don't use the OOTB message column? Also, does this work with other document types, PDF, etc.?
@andrewhess123
@andrewhess123 5 ай бұрын
Yeah I thought about that maybe I should of used the OOTM message column, no specific reason on that. If I were to do PDFs I would do this a different way, this method is specific for MS Word and using Quick Parts. Thanks for the question and watching kland!
Populate a Word Template table Dynamically with Power Automate
18:38
Wait! Solve Delegation Easily! In Power Apps Search
29:57
Andrew Hess
Рет қаралды 3,5 М.
Double Stacked Pizza @Lionfield @ChefRush
00:33
albert_cancook
Рет қаралды 121 МЛН
小宇宙竟然尿裤子!#小丑#家庭#搞笑
00:26
家庭搞笑日记
Рет қаралды 17 МЛН
Как бесплатно замутить iphone 15 pro max
00:59
ЖЕЛЕЗНЫЙ КОРОЛЬ
Рет қаралды 8 МЛН
НРАВИТСЯ ЭТОТ ФОРМАТ??
00:37
МЯТНАЯ ФАНТА
Рет қаралды 8 МЛН
Fill Out Word through Power Apps No Premium Licenses Needed
24:37
SharePoint Fundamentals: Content Types and Document Templates
8:32
Daniel Anderson
Рет қаралды 2,9 М.
Stop, Intel’s Already Dead!
13:47
Linus Tech Tips
Рет қаралды 247 М.
What's going on with Windows Laptops?
10:30
Marques Brownlee
Рет қаралды 2,8 МЛН
Simple Leave Request App for Teams | Power Apps or List Form
30:39
Andrew Hess
Рет қаралды 1,8 М.
How to Use Microsoft Planner to Manage Your Project (2024)
27:15
Scott Brant
Рет қаралды 121 М.
Populate a Word Template with Power Automate | How to Tutorial
18:29
Новые iPhone 16 и 16 Pro Max
0:42
Romancev768
Рет қаралды 2,4 МЛН
Это - iPhone 16!
16:29
Rozetked
Рет қаралды 445 М.
Сколько реально стоит ПК Величайшего?
0:37