cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nandayellow
New Member

Cant put the "from" and "body of the message" from outlook email to show on planner when email is flagged

Im using Create planner tasks for flagged emails in Office 365 and I want to show on Planner from who the email is and the body of the message or preview at least...but is always getting an error 400:  "Schema validation has failed. Validation for field 'PlanId', on entity 'Task' has failed: The specified identifier is invalid. Validation for field 'Title', on entity 'Task' has failed: The field cannot be longer than 255 characters. Validation for field 'BucketId', on entity 'Task' has failed: The specified identifier is invalid" HELP?
image1.jpgimage2.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
eric-cheng
Solution Sage
Solution Sage

Hi @nandayellow ,

 

There are a few issues here.  First you have exceeded the 255 character limit.  Second, you also have a bunch of HTML tags from the email body.

 

Please refer to the below flow.   I have purposely split up the steps into separate actions to make it easier to understand.  

 

1. Convert the HTML body to text

 

2. Use concat() to join the from address and email body text  

concat(triggerOutputs()?['body/from'],outputs('Html_to_text')?['body'])
 
3. Check the output from step 2 to see if it is 255 characters or more, if so, only get the first 255 characters, otherwise, just pass the entire string
 
if(lessOrEquals(length(outputs('Compose')),255),outputs('Compose'),substring(outputs('Compose'),0,255))

 

Please refer to this link for the details of the above formula.

 

ericcheng_0-1631273761144.png

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

 

View solution in original post

2 REPLIES 2
eric-cheng
Solution Sage
Solution Sage

Hi @nandayellow ,

 

There are a few issues here.  First you have exceeded the 255 character limit.  Second, you also have a bunch of HTML tags from the email body.

 

Please refer to the below flow.   I have purposely split up the steps into separate actions to make it easier to understand.  

 

1. Convert the HTML body to text

 

2. Use concat() to join the from address and email body text  

concat(triggerOutputs()?['body/from'],outputs('Html_to_text')?['body'])
 
3. Check the output from step 2 to see if it is 255 characters or more, if so, only get the first 255 characters, otherwise, just pass the entire string
 
if(lessOrEquals(length(outputs('Compose')),255),outputs('Compose'),substring(outputs('Compose'),0,255))

 

Please refer to this link for the details of the above formula.

 

ericcheng_0-1631273761144.png

 

--------------------------------------------------------------------------
If I have answered your question, please mark my post as a solution
If you have found my response helpful, please give it a thumbs up

Connect on LinkedIn

 

View solution in original post

nandayellow
New Member

THANK YOU 😊

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (941)