
Announcements
Situation:
Have 2 SharePoint Sites and that both contain identical document libraries in terms of columns and metadata.
Site1 is where the documents are controlled from, they are create and updated in this library and then sent to the other site and document library for user consumption. Power Automate with the use of control flags can either copy the file directly into the other library or create a pdf from the source document and send that over.
I can delete files in both libraries with the use of deletion flag, but want to be tighter on this to prevent files being deleted in the control library and not in the user consumption library where you end having an orphaned document without a source.
Hello @365testuser
You could establish a recurrent flow that daily or weekly goes through all the "published" (end user consumption) documents and check that the source document still exists.
But you could also track deletions of source documents, register the fact in a list and then have the recurrent flow go through the list and ensure that the corresponding "published" document has been deleted ... and if not, delete it, and inform you so you can investigate why it was not deleted the first time (locked by user, etc.).
Kind regards, John