Forum Discussion
[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_ElliottBronze 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)- Irwin1337Copper ContributorHi,
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?