extracting parts of email address for planner

[karlh]

I made a flow that creates a planner task from an email and I would like to have parts of the email address in my task title.

For example, this is the email address: "name@whatever.com"

Currently my Task title would look like this: "name@whatever.com: Subject"

But I'd like it to look like this: "name: Subject"

Any ideas on how I could do that?

[yashag2255]

Hi!

Step1 : You can create a new variable of type integer (let us name it as test) and assign it with the expression : 

indexOf(body('Get_email')?['From'], '@')

Step2 : Create another variable of type string and assign it with the expression : 

substring(body('Get_email')?['From'],0,variables('test'))

you can put the step 2 directly in the planner title as an expression input. 

Please mark this as a solution if it helps you/ answered your question. 

[karlh]

Thank you for your response!

It says: "The template validation failed: 'The action(s) 'Get_email' referenced by 'inputs' in action 'Initialize_variable' are not defined in the template.'."

How do I know the correct termination for "when a new email arrives"?

{
    "inputs": {
        "host": {
            "connection": {
                "name": "@parameters('$connections')['shared_office365']['connectionId']"
            }
        },
        "method": "get",
        "path": "/Mail/OnNewEmail",
        "queries": {
            "folderPath": "Inbox",
            "importance": "Any",
            "fetchOnlyWithAttachment": true,
            "includeAttachments": true
        },
        "authentication": "@parameters('$authentication')"
    },
    "recurrence": {
        "interval": 5,
        "frequency": "Minute"
    },
    "metadata": {
        "flowSystemMetadata": {
            "swaggerOperationId": "OnNewEmail"
        }
    },
    "splitOn": "@triggerBody()?['value']"
}

[gamoraes · Accepted solution]

Hi @karlh 

Just change the From with this expression:                                                                                         \/

Where the expression is

first(split(triggerBody()?['From'],'@'))

And see the magic.

Happy Flowing!

[karlh]

---

@gamoraes wrote:

Hi @karlh 

Just change the From with this expression:                                                                                         \/

Where the expression is

first(split(triggerBody()?['From'],'@'))

And see the magic.

Happy Flowing!

---

Thank you so much!  it did the trick