I am being asked to manage training records in SharePoint and updated through a power apps.
I will have 3 tables (SharePoint lists)
1) Employees and a list of job roles
2) Training and the job role(s) that are required to have done the training
3) Training record, this will be training record name, employee name and date completed. It may not have a row for every employee/training combo as this will be created when they compete the training.
My app will therefore let staff be selected from dropdown (easy), show a list of the training they are required to do (fairly easy!). The tricky bit I am not sure how to do is to then show the completion date against each training if it exists in table 3 for that employee/training combo. Then I want the date to be able to be added or updated, and on a save button either
A) Update existing date to newly selected date or
B) If no current record, and a date has been selected, create new list record for the employee-training combo with selected date or
C) if no current record and no new date set, do nothing
Any suggestions how to go about this appreciated, not sure if you can left join within Power BI, how to manage nulls, as none of this is a new record, or an edit record, and the number of training assigned will be variable.
Thanks
Leigh
