question

VickyBryson-7169 avatar image
1 Vote"
VickyBryson-7169 asked JoyZ commented

SharePoint List with Sub items

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

office-sharepoint-server-development
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

JoyZ avatar image
0 Votes"
JoyZ answered

@VickyBryson-7169,

I think we cannot create sub-items in SharePoint custom list/Microsoft list or Power Apps.

As a workaround, we suggest you create items with metadata including staff,unit,year,location and term and so on, then we could filter view based on unit and location column, see all staff members who have taught which unit and location.


If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

VickyBryson-7169 avatar image
1 Vote"
VickyBryson-7169 answered JoyZ commented

@JulieWang-MSFT thank you for your answer. I will create a database with staff details then I will create another list using look up with the staff database. I can then use Power BI for reporting of both lists. thanks

Vicky

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you for your sharing!

Have a nice day!

0 Votes 0 ·