web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate How can I get file ext...

Power Automate

Answered

How can I get file extension?

(0) Share

Report

Report

Posted on by Rau

15

Hi all,

I am working on a flow that gets every incoming email with attachments and send the files to a SFTP.

I need to be able to look at the file extension but I don't know how can I do it, any suggestions?

I would like to select the PDFs and maybe some PNGs (but not sure).

Thank you!

Categories:

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

Expiscornovus 33,830 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @Rau,

The when a new email arrives should have an Attachments field (array). Within that array there should be a Attachment name field which you can use. With a lastIndexOf function you can find the position of the last dot and extract the file extension value via a slice function.

Below is an example.

slice(items('Apply_to_each')?['name'], lastindexOf(items('Apply_to_each')?['name'], '.'))

Was this reply helpful? Yes No
Rau 15 on at

Like (1)

Report
Copy link

Link copied!

It worked! Thanks and sorry for the late reply.

Was this reply helpful? Yes No

Join the conversation