Answered

extracting parts of email address for planner

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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?

Categories:

Building flows

All responses (4)

Answers (1)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

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.
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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']" }
Verified answer

gamoraes 1,040 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous

Just change the From with this expression: \/

Where the expression is

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

And see the magic.

Happy Flowing!
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@gamoraes wrote:
Hi @Anonymous

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