Power Apps Training App Template 08-11-2020 07:23 AM

[aprildunnam]

In this Template Tuesday video I demo my Training Assignment App. This template gives you a way to explore and manage required training tasks. You can explore different kinds of video training, assign training to users, and users can see and complete their training task assignments. Some key things you'll learn about: ✅ Show/Hide objects ✅ Adjust the X position of objects dynamically ✅ Gallery Styling ✅ Conditional Formatting Download the app here: https://github.com/aprildunnam/PowerA... This includes the Power App template itself as well as a Flow that you can install and run which will provision the underlying SharePoint lists.

watch?v=emJmyQZBwVg

[ewfefwef]

Great app and love how you provided the flow to create the lists.
Minor feedback. I found some list column names didn't match the code. Some space and some none. 'Assigned To Email' 'Training ID'

Just adjusted, easier to take space out of lists.

Also adjusted the TrainingID column to use Sharepoint lookup/join

Couldn't get Patch to work for assigning tasks so adjusted with this, worked.

Had to find the matching course by TrainingID in the joined table/list to patch the correct record.

Everything working well and easy to adjust.

Assign = 

ForAll(
ComboBox1.SelectedItems,
Patch(
'My Training', Defaults('My Training'),
{
Title: selectedCourse.Title,
AssignedToEmail: ThisRecord.Mail,
AssignedTo: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims: "i:0#.f|membership|" & ThisRecord.Mail,
Department: "",
DisplayName: ThisRecord.DisplayName,
Email: ThisRecord.Mail,
JobTitle: "",
Picture: ""
},
TrainingID: {
'@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Id: selectedCourse.ID,
Value:selectedCourse.Title
},
'Due Date':DatePicker1.SelectedDate,
Status:"Pending"
}
)
);
Reset(DatePicker1);Reset(ComboBox1);
UpdateContext({showAssign: false});Refresh('My Training')

[Geradav]

hey @aprildunnam 

Thanks for sharing! Great work and great tips you are providing.

It seems the link that should redirect to GitHub is broken.

Full link should be this one PowerApps/Required Training Template at master · aprildunnam/PowerApps · GitHub

David

[aprildunnam]

Thanks for noticing and posting the correct link!

[Boppersnr]

This is a brilliant piece of work, very useful and well done. Thanks a mill @aprildunnam. 

Would it be much work to also be able to attach Training documents instead of Videos? I see you use the Media/Video action for adding the video. Is there an option to have any type of media, like a pdf instead of a video and then you can add either a video or a document/guide?

Thanks.

[RobertRatcliffe]

The flow to create the lists for the PowerApp does not appear to work for me. Does the flow still work ?