Answered

Removing File Extension

(0) Share

Report

Posted on by kkeirstead

Hi,

I have a flow right now that runs when an email attachment comes in, creates the file in a folder in OneDrive and appends the current date to the end of it. However when running the file it comes out as Test Flow.xlsx-MM-DD-YYYY.xlsx. How do I remove the .xlsx from the middle of the name?

What I have now for File Name is: [Attachment Name]-[utcNow('MM-dd-yyyy')].xslx

9-2-2020 5-57-02 PM.jpg

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Erica0214 on at

Like (1)

Report
Copy link

Link copied!

@kkeirstead ,

you could use the substring function to remove the extension.

For example:

I have a variable 'name with extension' whose value is "Book.xlsx"

substring(variables('name with extension'),0,sub(length(variables('name with extension')),5))

the result of above function is Book.

In your case, it could be :

substring([Attachment Name],0,sub(length([Attachment Name]),5))-[utcNow('MM-dd-yyyy')].xslx

Was this reply helpful? Yes No
kkeirstead 3 on at

Like (0)

Report
Copy link

Link copied!

Thank you! It simplified my thought process quite a bit.

Was this reply helpful? Yes No
Suggested answer

TomislavTasic 8 on at

Like (0)

Report
Copy link

Link copied!
You might have to work with files with different extension length (pdf, xls, doc, zip...).

Let's assume we have would like to get the files without the Title, so we use HTTP call to get them:

Method: GET

Uri: _api/web/lists/getbytitle('Template Documents')/items?$select=Id,Title,ContentTypeId,FileLeafRef&$filter=Title eq null

Afterwards we can use Compose step to get what we need using Expression:

From: body('HTTP_get_files_with_Title_equals_null')?['value']

Map (shown in the Code Snippet below):

{ "Id": item()?['Id'], "Name": item()?['FileLeafRef'], "ExtensionLenght": length(last(split(item()?['FileLeafRef'],'.'))), "Title": substring(item()?['FileLeafRef'],0,sub(length(item()?['FileLeafRef']),add(1,length(last(split(item()?['FileLeafRef'],'.')))))) }

From the code above you can see the expression you were looking for is the one I have used finally to set the file Titles:

substring(item()?['FileLeafRef'],0,sub(length(item()?['FileLeafRef']),add(1,length(last(split(item()?['FileLeafRef'],'.'))))))

Please check the images below.

Was this reply helpful? Yes No