Forum Discussion

Irwin1337's avatar
Irwin1337
Copper Contributor
Feb 26, 2024

[Need Help] - How to mirror a list?

Hi,


I have a sharepoint list that contains coloumns that are confidential information. At the same time much of the information are something everyone should see.

 

Is it possible to / how do I, create a mirror of my list that only contains the columns I select (or doesnt select) that I can share with everyone?

2 Replies

  • Rob_Elliott's avatar
    Rob_Elliott
    Bronze Contributor

    Irwin1337 in order to synchronise the 2 lists in SharePoint - one for the confidential data and one for the public data - you'll need to build a couple of flows in Power Automate. The first is to handle when new items are created or modified and the second is for when an item is deleted. There is a good page on how to do this at https://tomriha.com/how-to-synchronise-two-sharepoint-lists-with-power-automate/

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User.
    Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

    • Irwin1337's avatar
      Irwin1337
      Copper Contributor
      Hi,
      Thank you for your reply. After having looked more into it, I might need to create a library instead. Would it be possible to do something similar for that?

Resources