Remove .extension and leave the file name only

(0) Share

Report

Posted on by EdwardC

Hi there,

How do you remove an extension from 'File Name' dynamic value?

I tried doing replace but it didn't work...

Ex: File Name contains "Testing Doc.docx", I want to remove ".docx" and just leave "Testing Doc"

Thanks in advance!

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (0)

v-bacao-msft on at

Like (0)

Report

Hi @EdwardC,

I did a test on my side and found that the File name output by the file is created in a folder is not the name of the file, more like Id.

It seems that this Trigger doesn't work here. I recommend using When a file is created(properties only), you could also choose Folder here.

The Name that he outputs is the name of the file that does not contain extension.

Please take a try.

Best Regards,

Barry

Was this reply helpful? Yes No
EdwardC 69 on at

Like (0)

Report

I tried and File Name for me does return a proper name...
See below:
This was on an email that was sent to me from Flow.

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report
Hi @EdwardC,

I did the test on my side, Dynamic content-File name was encoded, and the encoded was removed, which is the name of the file.

If you want to remove the file extension, you could try this expression, this applies to file hits containing multiple ".":

replace(triggerOutputs()['headers']['x-ms-file-name'],concat('.',last(split(triggerOutputs()['headers']['x-ms-file-name'],'.'))),'')

Although I am confused about configuring a file name that does not contain an extension in Get item-Id, this expression could be referred to.

Please take a try.

Best Regards,

Barry

Was this reply helpful? Yes No
EdwardC 69 on at

Like (0)

Report

Thanks for the expression. I'm new to this whole expression with Flow.. is this how it's supposed to be done?

I just copied and pasted the expression in the formula field and clicked ok.

Was this reply helpful? Yes No
EdwardC 69 on at

Like (0)

Report

So youre extenion replacing expression worked.. but I guess Get Item ID requires a different value...
I tried using the File Name as the ID for Get Item and it returns false (can't find)..

Humm, this is tricky..

Was this reply helpful? Yes No
v-bacao-msft on at

Like (0)

Report

Hi @EdwardC,

So the direction you started is wrong. I also suggested in the previous post that I am confused why you should configure the file name in Get item-Id, which obviously does not get the desired result.

But your requirement is to get the file name without extension, so I provide such a method.

Or you could tell me what kind of Flow you need to create, and what kind of Flow you want to achieve.

Use When a file is created in a folder, you can't get the item ID. You could replace the trigger with When a file is created(properties only).

Then select "Enter custom value" in the Get item-List Name, fill in the Library Name, and fill the ID of the output of the Trigger in the Id.

Regards,

Barry

Was this reply helpful? Yes No
EdwardC 69 on at

Like (0)

Report
Hi Bacao,

I thought that Get ID field would work with the File Name - in theory at least.
Basically, I want a flow to trigger to:
Trigger when a new File is created
Send the File as Attachment on an Email to the creator
That's the quickiest summary.

But, the whole process isn't that simple.. :
User submits a PowerApps Form
The data is stored in Item List on SharePoint
A MS Flow triggers when a new item is created on the list, it pulls the data and puts it into a Word Doc and save it to a Document Library on SharePoint
A different Flow triggers when a new File is created on the Document Library
It'll get the File and send it as an Email attachment to the submitter

Now, since I'm the one that created all Flows, on Step 3, it'll reigster me as the one who created the file as the flow is runned by me. So, what I'm trying to do is Match the File Name with the Item List, get the email address of the submitter to send the email.

Also, I want to ensure that if two people submits the Form at the same time, it doesn't confuse which file to send to which user.

The reason why I don't use When a file is created(properties only) is because it doesn't come with File Content parameter that I need to send the doc

Was this reply helpful? Yes No