Hi, I want to create items in a list with sub items. Similar to a database. for example I have a staff member who may have taught multiple units over a period of years and terms. I want to create one items (staff member) with multiple sub items with would list the unit they taught, the year, location and term. I want to be able to search by the unit so I can see all staff members who have taught that unit and the location.
Can this be done in a SharePoint list or Microsoft List? Where I could report on it via Power Apps?
thanks,
Vicky Bryson