How to create new folder based on certain string on outlook header

(0) Share

Report

Posted on by CU19120412-0

Hi community, I need your help (I already search about this particular problem, and no one have the same issue as me, so I need your help).

So, I tried to create a flow based on trigger action If a new email arrives (V3), with trigger words in my email (e.g Welcome Back). I want to create new folder inside of my SharePoint based on the name inside of subject/header in outlook (e.g., Alan Walker - Welcome Back). I want to create a new folder with Alan Walker and save the attachment file that I received (with Welcome Back trigger words before) inside the Alan Walker folder.

Can someone solve this problem? I already tried creating Initialize Variable action but have a hard time extracting the Alan Walker before, so I can create a new folder based on that name.

Categories:

Building flows

Screenshot_19-12-...

I have the same question (0)

All responses (1)

Answers (0)

Expiscornovus 33,189 Most Valuable Professional on at

Like (0)

Report
Hi @CU19120412-0,

You could use slice & indexOf functions for this in an expression. With those functions you can find the place of the - character and slice away the part of the string after that character. I also used a trim function just to remove any unwanted space characters.

Try the below expression in your Initialize variable action

trim(slice(triggerOutputs()?['body/subject'], 0, indexOf(triggerOutputs()?['body/subject'],'-')))

Was this reply helpful? Yes No