cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MShelnutt
Helper IV
Helper IV

Ideas for creating an Employee Training Site

Hi everyone.

I am a beginner Power Platform user.

I have built a Company Training SharePoint page, which links to many courses.  I am creating Quizzes using Forms, and I have a SP list for Tracking the Employee trainings.  

What I want to do is create ways to link everything together automatically.

Best way to allow employees access to the training and final quiz,

then record that activity and results in a log and maybe print a certificate for them(?)

We would like to be able to go to a source (it used to be an Excel sheet called Training Matrix, which has all the trainings across the top, and the employees down the left side, and a colored box for their trainings completed) to see the employees and their trainings.

 

Any ideas?  Anyone already done something like this and can share stuff?  I am open to all suggestions.

Thank you,

 

17 REPLIES 17
DamoBird365
Super User
Super User

Hi @MShelnutt 

 

I have an example of a certificate being created here 


I would recommend you consider a list for storing the results. You can then create bespoke filters so that you can view results for a particular group or training course based on the data you capture. 

You can embed ms forms in SharePoint pages using web parts so you could use that to direct staff? Maybe even consider a non teams site like a comms site so that users have read access and therefore no access or need for chat.

 

Hopefully that’s a starter for you.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here

 

@DamoBird365 

That sounds very promising.  Do you have a recipe I can follow to build this?  I am not confident in my skills.  Functions etc., always get me in trouble as I don't "speak the language".

 

Thanks!

DamoBird365
Super User
Super User

Hi @MShelnutt 

 

I got your message on my site. Are you looking for a further explanation on how to build the automated pdf from forms?

 

Would a video be of interest if I explained the build end to end?

 

Damien

@DamoBird365 

Of course!  I love walk through videos.

Thank you, looking forward.  Will it be on your Youtube channel?

DamoBird365
Super User
Super User

Hi @MShelnutt 

 

I'll work on it and let you know when ready on here.

 

Cheers,

 

Damien

DamoBird365
Super User
Super User

Hi @MShelnutt,

 

Here is my demo for the MS Form to PDF conversion without using premium actions.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here

@DamoBird365 

Hi, I'm having trouble following your video.  Something between the Word Template and the SharePoint is not working like your demo.

 

 

Hi @MShelnutt 

 

I left you a comment in return. I think. Did you create the word doc before or after the columns. If before, try re-uploading the doc.

 

Damien

@DamoBird365 

My steps:

1.  Create a quiz in Microsoft Forms

2.  Create a SharePoint list to log employee training with columns: Title (Course Name), Name, Date, Rating, Pass?

3.  Download a template from Word, save in OneDrive as Certificate Template.

3. Should be save in SharePoint. You create columns in SharePoint and the template file needs to be there to inherit the new columns. 

Damien

@DamoBird365 

How do I save in SharePoint?-

MShelnutt_0-1617292112074.png

 

DamoBird365
Super User
Super User

Hi @MShelnutt 

 

For the file you have screenshot, either edit in browser and save a copy or download and then edit from your desktop, you can then drag onto the browser into your document library.

 

If the file is already on your one drive, you can copy to:

DamoBird365_0-1617305566303.png

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here

@DamoBird365 

I got to 8:50 and my dynamic content is not populating.

MShelnutt_0-1617623191044.png

 

MShelnutt_1-1617623253887.png

 

DamoBird365
Super User
Super User

Hi @MShelnutt 

 

good effort on getting that far. So we can see the word document has your metadata columns, you’re looking for the dynamic data from the form?

 

You’re missing an all important get response details action, usually added after the when a response is submitted trigger. You’ll see it in the video but guess you’ve missed it. Once added, you’ll be able to grab those dynamic fields you’re looking for.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien


P.S. take a look at my new blog here

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors
Users online (2,179)