Forum Discussion

joao_PT's avatar
joao_PT
Copper Contributor
Jan 28, 2025

2 microsoft lists ?

I have a excel file with the following info:

sheet 1: List of requests

sheet 2: List of proposals

The columns in each sheet are completely different. 

I'd like to use sharepoint (micrososft lists) instead of using excel. Do I need to use 2 different sharepoint files ?  it is possible to "aggregate" them 

in excel is easier to change between sheet, but in the sharepoint do i really need to change the page ? 

  • Hello,

    Yes this is possible. :) 

    You can decide if you want to have two different SharePoint Lists or using the same.
    If you would like to use the same list, you would need to have a two different content types applied to it. 

    Content type 1: Requests
    Content type 2: Proposals

    Within each content type, you will apply the fields that you require. 

    When creating a new item within the list, you will always get the option to create A (a request) or B (a proposal).

    Finally, you can create two different views within the list, that will show either the proposals or requests. 

    If you would like, I can help you out through a MS Teams call. :) 

    Yours sincerely,
    Aref Halmstrand

    Please mark as solved if this was helpful. 😊

Resources