Prevent duplicate files tracking a unique ID rather than file name in a library

(1) Share

Report

Posted on by RP5

I have a flow that copies a file to a duplicate library when a yes/no box is checked.

This allows up to consolidate all the files in one library but only copy a subset over to a sharing library.

The current behavior copies the file to the destination when the box is checked, and deletes the file in the destination library when the box becomes unchecked. If the file content is updated in the parent, the copy is set to overwrite in the destination.

The current issues are- if the file is renamed, a new file gets created, making a duplicate file in the destination library.

Each file has a unique ID generated when the file is created in the parent library.

I'd like flow to check the unique ID and NOT the file name to overwrite / update the file

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Sort by

abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @RP5

You mentioned each file has a unique ID generated when the file is created? Is that a custom unique Id? Please explain bit more about this.

Thanks

Was this reply helpful? Yes No
RP5 2 on at

Like (1)

Report
Copy link

Link copied!

Hello,

The "unique ID" is generated in a user defined column using a flow that is running in the library.

It triggers whenever a new item is added to the library.

The flow "updates file properties" in the unique ID column and combines a short string, designating the product line, asset type, with the sharpoint numeric ID in the primary library.

The unique ID allows me to trace it back to the parent library. This is needed because the destination library will be a consolidation point for mutiple teams/ product line assests are compiled.

Was this reply helpful? Yes No
abm abm 32,985 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi @RP5

Ok that make sense. So can't you filter using the unique id? A screenshot of your flow is helpful.

Thanks

Was this reply helpful? Yes No
RP5 2 on at

Like (0)

Report
Copy link

Link copied!

I'm not sure how to filter or if it would be applicable in this case-
there are 2 seperate flows
Flow 1 create unique ID for all itmes uploaded to the library

Flow 2 -If the file is modified AND has a Send to ShowPad column checked
THEN the item is copied to the test library and all properites are updated, if the send to showpad box is unchecked in the trigger modification, the file deletes- this is the desired behavior

The issue comes when the file name is modified- it creates a new file and

Was this reply helpful? Yes No