Power Platform Community Forum Thread Details

I would like to build a flow that will send a copy of a file from a source library to a destination library when a status column is marked final in the source library, and the when the status in the source library changes to some other status other than final will delete the file in the destination library. I am wondering if someone can point me to an example of this type of flow.

I can create a flow for the first part of the flow of copying the source file to the destination file but i am stuck with the next step of deleting it when the destination file when the source file status changes to something other than final

Categories:

Power Automate Desktop

I assume you're not actually doing this in Power Automate Desktop, but are instead using cloud flows. This forum is intended for desktop flow questions only. The correct forum for questions on cloud flows is here: https://powerusers.microsoft.com/t5/Building-Flows/bd-p/BuildingFlows

As to your question, you will likely need to have a way of mapping files in the source directory and the destination directory. Might make sense to have a separate table where you map an item/file Id from the source directory to the item/file Id in the destination directory. You should have the first part of your flow (the one that copies the file when the status is "Final") populate this table. And then you would be able to use this table in your second part of your flow - to check if a matching file exists and then to delete it. You should also make the flow remove the entry from the table when the file is deleted.

You can use a separate SharePoint list or a Dataverse table to implement this mapping. Otherwise, you can use a SQL database or even an Excel file to do it.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.