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
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')