Flow won't save the attachement if filename is the same!

[astritarsllani]

Hello everyone, so i am new to Power Automate, but after watching a youtube video i managed to create a simple flow. 

- What i did basicly is everytime a recieve an email with a specific attachement, i put that email into a designated folder on Outlook, and the auto flow saves the file '' attachement '' to a folder on my computer.

- But what is happening is that sometimes i recive the file 2 times in one day, and the filename stays the same just the content in it changes.

- And since the name attachement on the mail is the same,  flow shows me un erreur '' The resource you are attempting to access is locked '' and the file is not saved beause i bealive since the ''flow'' knows its the same file name it dosent save it.

example: let say at 10am you send me an excel file with 10 names in it, and you name the file '' Monday ''. I recive the mail, drag it to the folder and my automated flow save the file, all good. Then what you do is send me the same file at 3pm but you just added 5 more names on the excel file and didnt change the file name. Well my automated flow wont save this ''2nd file'' because its the same file name.

Do you guys have any idea on how to make the flow save the file? for example just add '' (2) '' to the new one. Hope all this helps i tried to give you everything i could come up with.

Have a nice day.

[v-xiaochen-msft]

Hi @astritarsllani ,

You can append the time to the filename. 

concat('file_name','(',formatDateTime(utcNow(),'yyyy-MM-dd HH:mm:ss'),')')

Best Regards,

Wearsky

[astritarsllani]

@v-xiaochen-msft  thnx for the reply, i tried but i cant find how to add ''Compose''.

Can you kindly write le a step by step on how to add this?

[v-xiaochen-msft]

Hi @astritarsllani ,

This is just a sample. The compose is usde to show the file name output.

You could directly use this expression in your action's file name parameter.

Best Regards,

Wearsky

[astritarsllani]

do i need to put ur code you gave somewhere  here?

{

    "inputs": {

        "host": {

            "connectionName": "shared_onedriveforbusiness",

            "operationId": "CreateFile",

            "apiId": "/providers/Microsoft.PowerApps/apis/shared_onedriveforbusiness"

        },

        "parameters": {

            "folderPath": "/Steve/Outlook Attachment Export/Export quarantaine",

            "name": "@items('Appliquer_à_chacun')?['name']",

            "body": "@items('Appliquer_à_chacun')?['contentBytes']"

        },

        "authentication": "@parameters('$authentication')"

    },

    "runtimeConfiguration": {

        "contentTransfer": {

            "transferMode": "Chunked"

        }

    },

    "metadata": {

        "operationMetadataId": "4ca9bf5b-71e2-4d13-b1d4-7825a29e5251"

    }

}