Unanswered

Extracting Information from a Planner task Description

(0) Share

Report

Posted on by Ariadne

Hello Everyone,

I've created an automation that creates a Planner task when a form is responded (Microsoft forms), every fields from form goes to the task description, but then I created another flows, that sends an email when a task is completed and now I need to take only one field in the task description and put it in the email. What could I do? I've separated the fields values in the task description with ";". Should I create a variable?

Note: When the automation takes the task description to the e-mail it comes a long text separated only with spaces. For example:

Task Description:
Name: Ariadne;
Age: 22;

E-mail Body:

Name: Ariadne; Age:22; ......

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Paulie78 8,424 Moderator on at

Like (1)

Report
Copy link

Link copied!
You could replace the semicolons with HTML line breaks in a compose action, with an expression like this:

replace(outputs('taskDescription'), ';', '<br />')

you need to replace outputs('taskDescription') with whatever contains your string. Then you can use the outputs of this compose in your email, and it will have line breaks instead of semi colons.

Was this reply helpful? Yes No
Ariadne 5 on at

Like (0)

Report
Copy link

Link copied!

Hello @Paulie78,

Thank you for your response, it's a very interesting ideia, but I need to send only some informations from the task description, for example:

Taks Description:
Name: Ariadne;
Age: 22;
e-mail: test@e-mail.com;
Subject: Login Problems;
Description: I can't login in my account;
Resolution: Hey Ariadne, I've solved your problem, try to log again.

E-mail body that I need to send:
Subject: Login Problems;
Description: I can't login in my account;
Resolution: Hey Ariadne, I've solved your problem, try to log again.

So I don't want to send all information present in the task description. There is another posibility?

Was this reply helpful? Yes No
Paulie78 8,424 Moderator on at

Like (0)

Report
Copy link

Link copied!

Should be, what bits of information do you want?

Was this reply helpful? Yes No
Ariadne 5 on at

Like (0)

Report
Copy link

Link copied!

Hello @Paulie78,
There are 4 fields, they don't have an exactly size, because it depends on the problem I will receive, but they are all in text format and they all have ";" in the end.

Was this reply helpful? Yes No
KateTsk 6 on at

Like (0)

Report
Copy link

Link copied!

Hello, do you have any updates about this? I'm also having trouble extracting certain fields from the description. In my case I'm pulling out the e-mail of the person who submitted the form and adding into the description, along with the other responses collected in the form. What I want to do afterwards is, when the task is completed I want to send an e-mail to the person who submitted the form and inform about completion.

Would be great if anyone can suggest what is the best way of achieving it.

Thanks!

Was this reply helpful? Yes No