Obtaining Filename - OneDrive for Business

[AH-CSUCI]

Hello, Power Automate Community:

My objective is to create a flow that creates a copy of a file from OneDrive for Business and moves the copy into an archive folder. When creating the new file, I want to append the current date to the new filename. I have figured out how to append the date (and extension) to the file created by taking the file content, but I want to initialize a variable to concatenate using the original file's name. How would I initialize this variable with the original file name?

Thank you.

[lbendlin]

You use "Get File Metadata" (for example)  and then you can access these fields as needed.

[AH-CSUCI]

Thank you for this information. It's odd that I receive the following error when attempting to obtain the file name using the Get File Metadata step:

{

  "status": 400,

  "message": "The file id '/Certs/AccomplishmentsFall2021-Spring2022.docx' is not valid.",

  "source": "api.connectorp.svc.ms"

}

I am able to obtain the file content of the exact same file using the "Get File Content" step.

Any further suggestions? Thank you for your assistance.

[v-liwei-msft · Accepted solution]

Hi @AH-CSUCI 

I totally agree with @lbendlin 's idea that the name of the file can be obtained using Get file metadata.

Could you please show detailed screenshots of your flow?

How did you enter the file ID in Get file metadata?

Best Regards,

Levi

[lbendlin]

In that case use "Get file metadata using path"

[v-liwei-msft]

Hi @lbendlin 

Please show your screenshots, thank you very much!

Best Regards,

Levi

[lbendlin]

[AH-CSUCI]

Thank you all.

The solution worked. I had just been pointing to the wrong file, which I had ended up deleting. I need more coffee, it seems.

Thanks again,