Share via

Microsoft Lists, aggregate different lists into 1 main one to supervise

Anonymous
2022-03-07T10:06:01+00:00

Hi everyone,

So for work, I would love to create about 10 Microsoft Lists of content schedules with draft dates, published dates, status, title, which project, etc. (like the template more or less) for each country that we work in, and each country office will only be able to edit their table (more or less easy part). But then I would love for all this data from all those lists from the different countries, to show up (to feed, to aggregate, merge, ... not sure of the right term) into a main list that allows our team at HQ to monitor all the country offices progress in just one place, that only my team and I will be able to consult. I would like this data to be transferred automatically into this main table and that when a country office adds or modifies content from their side/list, it updates automatically the main HQ one. Is this at all possible with Microsoft lists? or if you have any other viable alternatives, knowing that we have two working languages, French and English and I would like for other countries to edit content (in the list) from different countries but just their own.

Thank you very much in advance, i know this might seems complicate, but i really hope there is a solution, otherwise I will adapt with something else :)

Have a great day!

Alex

Microsoft 365 and Office | Install, redeem, activate | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2022-03-07T12:49:59+00:00

    Hi Alex,

    Good day to you and hope you are doing well.

    According to you description, it seems like you want to create 10 Microsoft Lists for different countries to store data, and then you want all data from these 10 lists to show in a main list, any new data added into each of the list will be updated in the main list automatically.

    May I know if my understanding of the scenario is consistent with yours?

    If yes, as far as I know, I'm afraid there is no out of box feature in Microsoft List which cannot meet this kind of requirement. Very sorry about the inconvenience.

    I also wish to try best to help you. Per my search, you may try to use Power Automate flow to firstly merge different lists into one Excel file, then use flow to create a new list from the Excel file and get updated data automatically.

    Here are some similar threads for your reference:

    Merge Multiple SharePoint Lists to one Excel file Dynamically

    Solved: Update Sharepoint list item from Excel - Power Platform Community (microsoft.com)

    If you need further help on creating flow or you want to learn more about flow, considering we have a dedicated channel Microsoft Power Automate Community where engineers and members in that community are proficient in the knowledge of flow, to make sure you get the best support experience and professional assistance, we sincerely recommend you post a new thread in that community, they will also focus on your specific situation and provide specific suggestions.

    Your patience and understanding are highly appreciated. Hope you have a nice day and stay safe!

    Best regards,

    Tina

    2 people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-03-08T08:45:57+00:00

    Thank you very much for your fast reply :)

    0 comments