Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

On the basis of extension of file save in a different folder

(0) ShareShare
ReportReport
Posted on by 19

Email came with multiple attachments(.pdf,.csv,.txt,.xlsm,.xlsx). But I am interested in .csv and .xlsm attachments only. Ignore all the other attachments. Only problem is that these two extension will save in two different folders(Azure File Storage). I am not able to design that logic in my power automate.

Till now, my logic is that, First I check all the attachments and get all the extension and then put condition.

 

shantanu97_0-1642848520738.png

Attachment Extension Formula:

substring(outputs('Compose'),indexOf(outputs('Compose'),'.'),sub(length(outputs('Compose')),indexOf(outputs('Compose'),'.')))
 shantanu97_2-1642848677536.png

Couple of questions:
1.How to get File Name & File content that contains only .csv file. Similar thing with .xlsm file.
2.What should I put in no condition. There might be scenario when there is no .csv & .xlsm file present in the email.


 

 

 

  • Gopala_Krishna Profile Picture
    Gopala_Krishna 1,459 on at
    Re: On the basis of extension of file save in a different folder

    @shantanu97 

     

    You can pass attachment name and attachment content in the Create File action inside the yes part of the condition

     

    In the No part of the condition you can either leave it blank if you don't want to perform any action, else you can specify action based on what you want to achieve.

     

    If the information shared helps you please consider giving a thumbs up and mark solution as resolved

    Please follow my website PowerCards for more information related to Power Platform

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard