Power Platform Community Forum Thread Details

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?

Categories:

Using connectors

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.

--------------------------------------------------------------------------
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