Compare list attachments to file library to check for duplicate file names

(0) Share

Report

Posted on by dmooreii

Looking for flow logic to accomplish the following:

read attachments when a SharePoint list entry is added

Compare those filenames to filenames of contents of a document library

If duplicate is found, send an email with the duplicate filename and exit the flow

Categories:

Building flows

I have the same question (0)

All responses (15)

Answers (0)

Sort by

rmerydith 50 on at

Like (0)

Report
Copy link

Link copied!

@dmooreii This below should help you out. Make sure the trigger is when a new item is created, next get the attachment content from the created item, get files (properties only) from the document library. Use apply to each to loop through the files in the document library, compare them against the attachment name and send the email. Please change "is equal to" to "contains" This is very generic and basic. If you need further clarification, please let me know. Hope this helps.

Was this reply helpful? Yes No
dmooreii 98 on at

Like (0)

Report
Copy link

Link copied!

Under the condition check, there is no dynamic object available for "Attachment" anything

Was this reply helpful? Yes No
rmerydith 50 on at

Like (0)

Report
Copy link

Link copied!

Are you sure you have everything laid out like I have in the screen shot? It will be there if everything is correct. Have you searched for it?

Was this reply helpful? Yes No
dmooreii 98 on at

Like (0)

Report
Copy link

Link copied!

What do i need to use for Id and File Identifier for Get Attachment Content ?

Was this reply helpful? Yes No
rmerydith 50 on at

Like (0)

Report
Copy link

Link copied!

For ID, search for ID and For File Identifier, user identifier. You may need to search for these. Sometimes they can hide.

Was this reply helpful? Yes No
dmooreii 98 on at

Like (0)

Report
Copy link

Link copied!

Not working

body('Get_attachment_content')?['body']

Was this reply helpful? Yes No
rmerydith 50 on at

Like (0)

Report
Copy link

Link copied!

@dmooreii are you using the ID from the trigger?

Was this reply helpful? Yes No
dmooreii 98 on at

Like (1)

Report
Copy link

Link copied!

??? Trigger is "when an item is created".

Was this reply helpful? Yes No
rmerydith 50 on at

Like (0)

Report
Copy link

Link copied!

Yes. You want the ID in Get attachment content to be the ID from the Tigger (when an item is created).

Was this reply helpful? Yes No
dmooreii 98 on at

Like (0)

Report
Copy link

Link copied!

There is no way to set that in the trigger. Just have site address and list name.

Was this reply helpful? Yes No