Unanswered

How can I replace characters in subject?

(0) Share

Report

Posted on by Rau

Hello!

I am working in a flow that checks the inbox every 15 minutes and stores the incoming emails into a SFTP server, the folder where the emails are stored has the same name as the subject.

As you know, in Windows this character '/' indicates the beginning of a new directory.

I have a customer that sends the emails with the character said before and when the flow is going to create the folder, it detects de slash and creates 3 or 4 more folders that it should.

Here is how I configured it (under the red line is the path where the email has to go to):

Now, how can I replace '/' in the subject for '-'? I tried with the replace function but it didn't work (maybe I put it wrong) and using compose but Im pretty new using Power Automate and I don't know if I'm doing something wrong. Help is appreciated!

I have the same question (0)

All responses (2)

Answers (0)

Expiscornovus 32,852 Most Valuable Professional on at

Like (0)

Report
Re: How can I replace characters in subject?

Hi @Rau,

I assume this Create File action (SFTP - SSH connector) is part of/placed within an apply to each loop?

If that is the case you could use the following expression.

You can add this via the expression editor in the File Name field of the Create File action and type .eml after it:

replace(item()?['subject'], '/', '-')

Or directly copy paste the below into the File Name field of the Create File action

@{replace(item()?['subject'], '\', '-')}.eml

Was this reply helpful? Yes No
Rau 15 on at

Like (0)

Report

Re: How can I replace characters in subject?

Thanks for the response @Expiscornovus I will try your solution after holidays and I'll tell you if I did it.

Merry christmas and happy new year!

Was this reply helpful? Yes No