Retrieve email address from 'Notes' field in Planner task

[Sresnd]

Hi, 

How can I get an email address listed in the 'Notes' field in a Planner task, so I can use this for notifying people when a task is complete?

Thanks in advance

[AhmedSalih]

Hello, @Sresnd , try this:

Regards,

Ahmed

If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.

My Blog: www.powerplatformplace.com

[Sresnd]

Hi AhmehSalih,

Thank you for your reply. Your solution seems to get the assigned persons email address, if I understand your reply correctly. What I want is to get the email (which is free text extracted from the submitted Form) from the "Notes" field 

 

[AhmedSalih]

@Sresnd, you will have to use this expression accordingly:

substring(YOUR-NOTE-TEXT,add(lastIndexOf(YOUR-NOTE-TEXT,'Email:'),6))

the String "Email:" is 6 characters and if you always have a space after the : then change 6 to 7.

Regards,

Ahmed

If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.

My Blog: www.powerplatformplace.com

Let me know if you have any question about is. 

Regards,

Ahmed

If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.

My Blog: www.powerplatformplace.com

[Sresnd]

Hi Ahmed, 

I get an error saying the expression is not valid:

[AhmedSalih]

@Sresnd, in the Expression, you have to replace the "YOUR-NOTE-TEXT" with your Note value from the Get Task Details Action using Dynamic.

Regards,

Ahmed

If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.

My Blog: www.powerplatformplace.com

[Sresnd]

@AhmedSalih the note value is free text, not a dynamic value. 

[AhmedSalih]

@Sresnd , I know, but you need to select it from the Dynamic tab. 

Delete the Highlighted yellow and leave the cursor there, click Dynamic and selected the Note value from the Get Task Details Action.

Regards,

Ahmed

If my reply helped you, please give a 👍. And if it has solved your issue, please consider a 👍 & Accepting it as the Solution to help other members of the community find it more.

My Blog: www.powerplatformplace.com