Duplicate Attachments

[Anonymous]

Hi all,

I using a flow to get attachments from a share point document library. 

Problem is, I am getting a duplicate attachments with same name and content type. is there anyway I can filter distinct attachments from share point library?

I have already tried: Union function, length function in condition, unfortunately its not working

Any help would be appreciated

Regards

Ahmad

[fchopo]

Hello @Anonymous 

Could you share your flow or explain in more detail what's the target of the flow?

Regards,

Ferran

[v-duann-msft]

Hi @Anonymous 

Thank you for posting.

According to your description, you would like to get file from sharepoint but failed due to duplicate file. If any misunderstanding, please kindly let me know.

Normally, we couldn’t upload totally same file into library. Otherwise, there will be error notification pop up from sharepoint. Even though I click on ‘add file’, I will only get the latest version of this file.

So I couldn’t reproduce your scenario from the beginning. Meanwhile, I’m curious about your flow. Is that possible that you can share me your flow steps?

I tried to get files from sharepoint using ‘manually trigger a flow’. I can grab that file I want by selecting it directly.

Hope to hear from you soon.

Best regards,

Anna

[Anonymous]

I am trying to extract files from share point library by filtering name of my file in get file properties action.

Next I am using get file meta data action to get attachments from share point library and then using get file content action to get content of the file.

Now, in last I am using append to array variable to fetch schema of my file content.

Regards

[fchopo]

Hello @Anonymous 

You could do something like this:

1) Initialize and array variable where the attachments will be stored.

2) Initialize a variable with the number of iterations, so we can use it in the filename.

3) Get the SharePoint list items (Business Trips).

4) For each item:

  4.1) Get the attachments.

  4.2) For each attachment.

    4.2.1) Get the file content of the attachment

    4.2.2) Append this attachment to the array variable, where the name of the attachment is "Name-iteration_number".

    4.2.3) Increment the iteration Number

Hope it helps!

Ferran

[Anonymous]

I am using share point library (not list) to extract files.

So, basically what I am doing is:

1- get file properties to filter name with user name so it gets me all same email files from share point library

2- get file metadata to get file attachments

3- get file content to get file content

Next, Append to array variable to fetch the file content schema

Problem is, I am not able to filter distinct files attachment

Thanks

[fchopo]

Hello @Anonymous 

I don't really get your point (now I'm realizing that you are storing eml files in a SharePoint library, and you probably want to get those attachments. Am I right?).

In any way, the procedure would be the same, replacing the "Get items" by "Get files".

Regards,

Ferran