Power Platform Community Forum Thread Details

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.

Attachment Extension Formula:

substring(outputs('Compose'),indexOf(outputs('Compose'),'.'),sub(length(outputs('Compose')),indexOf(outputs('Compose'),'.')))

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.

Categories:

General topics