Extracting file name and using within flow

(1) Share

Report

Posted on by agour

Hello!

I have a flow where I wish to extract the filename of the file, but without the extension.

So if it was "somepicture.jpg", I want to use "somepicture" in the HTTP post later on.

My flow looks like this:

I have spent a lot of time trying to get this to work, and have tried multiple options for extracting the filename.

I am sure that I must be close.. but I can't quite figure it out.

Any ideas? I'm happy to do it another way, just as long as it works.

Thanks!

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (1)

v-yamao-msft on at

Like (2)

Report
Copy link

Link copied!
Hi @agour,

To extract the file name of the file without the extension, please try to combine functions split and first.

You could use the following code:

first(split(triggerOutputs()['headers']['x-ms-file-name-encoded'],'.'))

Then you could use the output from the Compose in the next action.

Please try it on your side.

Best regards,

Mabel Mao

Was this reply helpful? Yes No
agour 35 on at

Like (0)

Report
Copy link

Link copied!

Hi Mabel,

I tried your suggestion, which makes sense to me.

The output from the compose action is a random string of charectors. Any idea what is going on?

The actual filename was "McGoff_00018.jpg"

Thanks!

Was this reply helpful? Yes No
agour 35 on at

Like (0)

Report
Copy link

Link copied!

Bump - any further ideas? I still need to try and get this fixed

Was this reply helpful? Yes No
agour 35 on at

Like (0)

Report
Copy link

Link copied!

I have tried using Onedrive as the input, rather than ftp... and I still get the same issues.

I also tried using a replace function:

replace(triggerOutputs()['headers']['x-ms-file-name-encoded'], '.jpg', '')

And I still get the same strange string of charectors as the output..

Was this reply helpful? Yes No
Verified answer

agour 35 on at

Like (6)

Report
Copy link

Link copied!

Fixed it!

I don't know why - but using the dynamic expression for 'filename' always gives a garbled end result.

The only way to do it, was to initialise the variable first, and then later use it.

Was this reply helpful? Yes No
SantoshBuddha 27 on at

Like (8)

Report
Copy link

Link copied!

Using
base64ToString should give you the correct Name.
base64ToString(triggerOutputs()?['headers/x-ms-file-name-encoded'])

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Copy link

Link copied!

That was my solution to get the name of my pdf file. Thanks!

Was this reply helpful? Yes No
swatisuman0921 3 on at

Like (0)

Report
Copy link

Link copied!

Thanks @SantoshBuddha , this worked!!!

Was this reply helpful? Yes No