Using sharepoint to store and analyse employee training records

%3CLINGO-SUB%20id%3D%22lingo-sub-2154732%22%20slang%3D%22en-US%22%3EUsing%20sharepoint%20to%20store%20and%20analyse%20employee%20training%20records%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2154732%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20currently%20have%20a%20sharepoint%20document%20library%20site%20that%20we%20store%20employee%20training%20records%20(competencies)%20which%20has%20been%20extremely%20useful.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20now%20trying%20to%20workout%20a%20way%20that%20we%20might%20be%20able%20to%20use%20this%20site%20to%20further%20manage%20the%20records%2C%20i.e%20each%20employee%20has%20a%20role%20and%20these%20roles%20are%20made%20up%20of%20competencies%2C%20we%20need%20to%20be%20able%20to%20flag%20which%20employees%20are%20missing%20competencies%20for%20their%20specific%20role.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20something%20that%20can%20be%20done%20using%20sharepoint%20or%20another%20product%20i.e.%20Powerautomate%2C%20Powerapps%20or%20PowerBI%20%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2154732%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%20Powerapps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2155766%22%20slang%3D%22en-US%22%3ERe%3A%20Using%20sharepoint%20to%20store%20and%20analyse%20employee%20training%20records%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2155766%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F974198%22%20target%3D%22_blank%22%3E%40scottfos%3C%2FA%3EI%20think%20the%20best%20option%20will%20be%20to%20use%20PowerApp%20for%20this%20use%20case%20though%20you%20could%20manage%20a%20few%20of%20them%20through%20Liberty%20Validation%20and%20advance%20setting%2C%20to%20apply%20some%20custom%20view%20and%20indexing%20as%20mention%2C%20the%20best%20and%20simple%20way%20will%20be%20to%20get%20used%20of%20the%20PowerApps%20as%20your%20hand%20is%20free%20when%20it%20comes%20to%20customization.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi All, 

 

We currently have a sharepoint document library site that we store employee training records (competencies) which has been extremely useful.

 

I'm now trying to workout a way that we might be able to use this site to further manage the records, i.e each employee has a role and these roles are made up of competencies, we need to be able to flag which employees are missing competencies for their specific role.

 

Is this something that can be done using sharepoint or another product i.e. Powerautomate, Powerapps or PowerBI ?

 

Any help would be greatly appreciated.

2 Replies

@scottfosI think the best option will be to use PowerApp for this use case though you could manage a few of them through Liberty Validation and advance setting, to apply some custom view and indexing as mention, the best and simple way will be to get used of the PowerApps as your hand is free when it comes to customization.

@scottfos a couple of SharePoint lists, one for Competencies and one for Employee data with the competencies they have, with a Power Apps app as your form with both lists as the data source is certainly do-able and is the route I would recommend you investigate.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User