Hi,
I am attempting to take an email attachment and apply the Predict action (form processing) for each attachment. I've tried to follow the instructions here https://docs.microsoft.com/en-us/ai-builder/form-processing-model-in-flow but when I use the expression base64(items('Apply_to_each')) it doesn't work.
I get this error message in the output: "{\"operationStatus\":\"Error\",\"error\":{\"type\":\"Error\",\"code\":\"InternalServerError\",\"message\":\"Status code action Unknown is not handled. error message : File content could not be parsed, was the mime type correct?\"}}"
The input message seems to look ok:
item/request | "{\n \"base64Encoded\":… \"application/pdf\"\n}" |
Has anyone out there managed to sucessfully apply the predict action (form processing) to an email attachment?
Thanks
Rob
Solved! Go to Solution.
Hi @RobBoyers ,
Could you try if the following function will work:
base64(outputs('Get_attachment')?['body'])
I am trying to make more tests on this issue, will back if I have got any updates.
Best regards,
Mabel
Hi, thanks for reaching out. I'm still struggling I'm afraid.
If it helps, My trigger action is Outlook: When a new email arrives, from a specific address with the subject of invoice. Has attachment = yes, Include attachments = yes.
Loop for each: select an output from previous step: 'Attachments'
Should be pretty simple, I must be missing something obvious here.
Hi,
I have made some progress with the input syntax but it appears the Predict step is struggling to handle pdf files.
I used the expression
{"host":{"apiId":"subscriptions/24fa6447-0d7f-439d-9ee6-3b1984fec8b6/providers/Microsoft.Web/locations/westeurope/runtimes/europe-002/apis/commondataserviceforapps","connectionReferenceName":"shared_commondataserviceforapps","operationId":"Predict"},"parameters":{"modelId":"a3933888-a893-e911-a81c-000d3a479be2","item/request":"{\n \"base64Encoded\": \"W3siQG9kYXRhLnR5cGUiOiIjTWljcm9zb2Z0Lk91dGxvb2tTZXJ2aWNlcy5GaWxlQXR0YWNobWVudCIsIklkIjoiQUFNa0FHTXpNVFZtT0RBeExUVTVPR010TkRRM01DMDVaRFV6TFRabVl6UmlabVEzTW1Wa1lnQkdBQUFBQUFDOTNEZWVmY2dFUXI4Y1EtaHB6YUlDQndBUE95UmpMQmp3VEwweG5OTEM1MU1CQUFBQUFBRU1BQUFQT3lSakxCandUTDB4bk5MQzUxTUJBQURyUjA3ZUFBQUJFZ0FRQURSTjBfVm1rYnBMbDl5WmNRdWZIVG89IiwiTmFtZSI6Ikludm9pY2UucGRmIiwiQ29udGVudFR5cGUiOiJhcHBsaWNhdGlvbi9wZGYiLCJTaXplIjoxMDU4MDQsIkNvbnRlbnRCeXRlcyI6IkpWQkVSaTB4TGpjTkNpWGk0OC9URFFveElEQWdiMkpxRFFvOFBDOUJkWFJvYjNJZ0tHSmlkV3hzWlhJcEwxQnliMlIxWTJWeUlDaEhjbUZ3WlVOcGRIa2dRekZHYkdWNFVtVndiM0owS1M5RGNtVmhkR2x2YmtSaGRHVWdLRVE2TWpBeE9UQTJNVGN4TVRJNU5UQXJNREVuTURBbktTOU5iMlJFWVhSbElDaEVPakl3TVRrd05qRTNNVEV5T1RVd0t6QXhKekF3SnlrK1BnMEtaVzVrYjJKcURRb3lJREFnYjJKcURRbzhQQzlNWlc1bmRHZ2dNalUyTnk5R2FXeDBaWElnTDBac1lYUmxSR1ZqYjJSbFBqNXpkSEpsWVcwTkNuaWNWSTdOQ3NJd0VJVHZDL3NPK3dScG1teCtlcTNGNGxFYjhBSGl6NlVxcGVEenUwMlZJcnVIK1dDWW1RbEJxK0JJTDdjS1UydkZ3VkIrSUV3SWphZkFUc1dHaEpuamo4YVZmTkJmRXVNZmJMNHp3ck5rV1dkS2svUnM3cVduT21qcVhnakg4dFcrWnFvTnBadm9mdEIwbjBWMDEvZXBiM2NEWmFHeWwrWXN1VzFDY05FcGJ4d0Z5OHBicG5SQitBQUFBUC8vaXRaZ1VHRUlZL0JtY0dVSVpmQmhjR2Z3WXZEUTFEWFNZR0JtTUdTSUFJcUZNWGdBeVpnWXpWaUZFQzllTHRjUWNtdzJNekxTc3pReFZqQTNBbnJHMkJSc013QUFBUC8vQXRxc0Q3UXhFR2luUDhoT1E1Q2QrZ3d1UUJFUHlpd3pzZFF6TXdGNjA4QmN6OERZREd3WkFBQUEvLzhDV3FZTjlFNDRFQVl4QkZKb3ZESFllRE5MWXowalkzT3c4UUFBQUFELy93SWFid3dNSlE5Z2FGSEJBaU16UFNOTG9BWG1sbm9teHBaZ0N3QUFBQUQvL3dJSEZpaG8zSUFrS0xwOFFOWlJaZzB3RlJnYkdpcVltUUZUQlNReEFBQUFBUC8vQW52RGxFRWNHaG5pd0tSaFFwRWRvUFJyYktwbmFtd01OaDhBQUFELy93S2Fid0JPVXN5YXBpYWdoT2ZERUFBTU5Gamtxd0tETGlZR25ON0NVSzAxSlRHaG01cm9HUmtaSzVnWldzTHRCZ0FBQVAvL0F0cHRybWx1ckFFMDNoOXFueUZERUdVaGFHQ0lZZ1VBQUFELy93SmFJY3dnd2lBRmhLSlFLeVNCZkJrZ0ZHWVFwamdnZ1RiQmNpMEFBQUQvL3dMYUpBazAzUXFjRU1KQkFXZ01zczBBR0lCaHdMQ0QySzBHekZjZ1BtWEpCR1N6Z1NrODF3SUFBQUQvL3dMYURMY1ZuTnBkR1B3b3Q4SFUwZ2llVlFFQUFBRC8vOEtTQ0xVb1NnMUc1aVo2bHVibUNxWVdKdkNvQWdBQUFQLy9BbHFpQTh4TmtjQUE4Z0htS1dBQW1zQ0t2QUJnVVFoTWdoUjV5ZGpjQk1VNkFBQUFBUC8vQXFjTUdCUmhrR0NRQmtJSnl0SzRpYUdlcFlVRmlqVUFBQUFBLy84Q1dxTUs5STgvS0lXREU0UTZNSHJDS1MwbmdLa2MyUklBQUFBQS8vK0NwbkloSUNrRkpFWEJQQm5LWXNnU1dCUVpBWVBNREZGV0FBQUFBUC8vQWljREQzQ2xGTVRnRG8yZkdFMmdRQkJEQU9XUmcyUVRBQUFBLy8raWdZZE16STMxTEkwdFVLd0JBQUFBLy8vQ2lCeGpZT1JBaWp0b2hXc0taSHVDL2V3Qkx1azlLSEtEc1FHd1pESTFWVEExTVlPN0FRQUFBUC8vd2hxb2tHS1JzcUlRSEtaSUZnRUFBQUQvL3dKYUpBb3NvcWdacHFhRzVucW13RFlFc2pVQUFBQUEvLy9Da1kyaFBnS1hUdjZVSjM0a0N3RUFBQUQvL3dKYTJBb3Nra0MrRVVUUHdqZ01CTFlYZ2VuYlVBR1RBYllGVlBvWkc0T2FlR1lHUmdvbUNrV3B2RnhwV3JCR0pWUXFGOVI0TTREeGNxQThRMk5FT3hLVkExY0hhVlJDL0cxSllwbHNhS1puWUdZQjlqWUFBQUQvL3dLM0V2MkJpZE1IM2pyRVVWa0h3cUxXbURUYlRDek45Y3dnalNrQUFBQUEvLzhDV2hhandSQU5qTDFRQmhkb0xXQU
{"statusCode":400,"headers":{"Cache-Control":"no-cache","Set-Cookie":"ReqClientId=40abb475-1cba-4e49-8642-b4421b1cc6bc; expires=Fri, 21-Jun-2069 21:33:01 GMT; path=/; secure; HttpOnly,orgId=2e569944-1e69-404d-8df5-6e9b8ec42aaf; expires=Fri, 21-Jun-2069 21:33:01 GMT; path=/; secure; HttpOnly,ApplicationGatewayAffinity=7374892e0d5a6889c14a9b9e9065db1068800941fd22098d3410ac68d1f59365;Path=/;Domain=rboyerssandbox.crm4.dynamics.com","Server":"","x-ms-service-request-id":"d512e04a-bfb5-446b-8f48-ed1d9b4f368d","REQ_ID":"d512e04a-bfb5-446b-8f48-ed1d9b4f368d,d512e04a-bfb5-446b-8f48-ed1d9b4f368d","AuthActivityId":"7ff5b68e-ad66-48e0-b987-de8139f8afd3","x-ms-ratelimit-burst-remaining-xrm-requests":"59999","x-ms-ratelimit-time-remaining-xrm-requests":"11,997.82","OData-Version":"4.0","Public":"OPTIONS,GET,HEAD,POST","Date":"Fri, 21 Jun 2019 21:33:03 GMT","Content-Length":"3480","Allow":"OPTIONS,GET,HEAD,POST","Content-Type":"application/json; odata.metadata=minimal","Expires":"-1"},"body":{"error":{"code":"0x80040265","message":"{\"operationStatus\":\"Error\",\"error\":{\"type\":\"Error\",\"code\":\"InternalServerError\",\"message\":\"Status code action Unknown is not handled. error message : File content could not be parsed, was the mime type correct?\"}}","innererror":{"message":"{\"operationStatus\":\"Error\",\"error\":{\"type\":\"Error\",\"code\":\"InternalServerError\",\"message\":\"Status code action Unknown is not handled. error message : File content could not be parsed, was the mime type correct?\"}}","type":"System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=9.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]","stacktrace":" at Microsoft.Crm.Extensibility.OrganizationSdkServiceInternal.Execute(OrganizationRequest request, InvocationContext invocationContext, CallerOriginToken callerOriginToken, WebServiceType serviceType, Boolean checkAdminMode, ExecutionContext executionContext, Dictionary`2 optionalParameters)\r\n at Microsoft.Crm.Extensibility.OData.CrmODataExecutionContext.Execute(OrganizationRequest request, ExecutionContext executionContext)\r\n at Microsoft.Crm.Extensibility.OData.CrmODataServiceDataProvider.ExecuteOperation(CrmODataExecutionContext context, EdmOperation edmOperation, Dictionary`2 parameters, Dictionary`2 boundParameters)\r\n at Microsoft.Crm.Extensibility.OData.ActionController.ProcessOperationRequest(String operationName, Dictionary`2 operationParameters, EntityReference entityReference, String boundEntityName, String boundEntityType)\r\n at Microsoft.Crm.Extensibility.OData.ActionController.<>c__DisplayClass11_0.<PostBoundAction>b__0()\r\n at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute[TResult](ILogger logger, EventId eventId, ActivityType activityType, Func`1 func, IEnumerable`1 additionalCustomProperties)\r\n at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute[TResult](ILogger logger, XrmTelemetryActivityType activityType, Func`1 func)\r\n at lambda_method(Closure , Object , Object[] )\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass10.<GetExecutor>b__9(Object instance, Object[] methodParameters)\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ExecuteAsync(HttpControllerContext controllerContext, IDictionary`2 arguments, CancellationToken cancellationToken)\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Controllers.ApiControllerActionInvoker.<InvokeActionAsyncCore>d__0.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Controllers.ActionFilterResult.<ExecuteAsync>d__2.MoveNext()\r\n--- End of stack trace from previous location where exception was thrown ---\r\n at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()\r\n at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\r\n at System.Web.Http.Dispatcher.HttpControllerDispatcher.<SendAsync>d__1.MoveNext()"}}}}
Hi, I am not getting Predict option while adding next step.
You have to create your flow within a solution else you don't get the predict action.
An update on the syntax you need to use;
Hi,
As suggested, i have created a model driven app and try to create a flow within app but no use.
Please suggest where i can define flow in solution.
Hi,
Go to make.powerapps.com > solutions > create your solution. Then click 'New > Flow'.
You have to use make.powerapps.com, this doesn't work in the classic solution builder.
Rob
I have a very similar flow built in solutions which when I trigger manually works, however when it is triggered by a new email arriving it fails.
Here is the error I recieve...
@kcg633755 wrote:I have a very similar flow built in solutions which when I trigger manually works, however when it is triggered by a new email arriving it fails.
Here is the error I recieve...
"code": "0x80040265","message": "{\"operationStatus\":\"Error\",\"error\":{\"type\":\"Error\",\"code\":\"InvalidPredictionInput\",\"message\":\"Bad JSON escape sequence: \\\\Z. Path 'base64Encoded', line 110, position 118.\"}}",Any idea why it is failing with the email trigger?
Sorry not much idea. Normally escape sequence error means somewhere in your data there are special characters which is making the code treat it like a separator.
Recently, I found my flow to be failing. It was throwing an error "Unexpected character at ..." I looked into the email attachment output and found it's JSON schema. I replaced my request payload in Predict with the below:
{
"base64Encoded":"EXPRESSION"
"mimeType":"application/pdf"
}
where the EXPRESSION is string(triggerBody()?['Attachments']?[0]?['ContentBytes'])
(Assuming you are extracting the contents of the first attachment)
That solved my error. If you are encountering such kind of errors, I suggest you analyse the input of the predict step and check it's schema.
Same issue for me as well. But it is solved with "string(triggerBody()?['Attachments']?[0]?['ContentBytes'])" EXPRESSION.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
41 | |
40 | |
38 | |
34 | |
30 |
User | Count |
---|---|
47 | |
36 | |
34 | |
25 | |
24 |