Share
Report
2Hi All,
I'm looking at importing a CSV file into a Dataverse table using Flow but I want to utilise the duplicate detection options I would normally get if done manually.
I'm partially on the right track I think as I create the Data Import and then the Import File -
On the Create Import File step, I get a generic error:
An unexpected error occurred.
With the following Output -
{
"statusCode": 400,
"headers": {
"Cache-Control": "no-cache",
"x-ms-service-request-id": "55223d0f-98a4-429e-adf2-f2c9f0eb0518,6d9433fc-5a28-4271-ba68-6da94654f428",
"Set-Cookie": "ARRAffinity=bbfc29b660328fb8c95bc7afe0f62bbff9944453af8a25c3765b11b5bf63ac935ab954b42cfa12ad9f33ddc80a07e15dd633bd57139a65479392e46e5242529408DC0212D00BE70B1901265142; path=/; secure; HttpOnly,ReqClientId=03b69755-cdee-4358-8967-1c8a72fb0e54; expires=Thu, 21-Dec-2073 10:21:40 GMT; path=/; secure; HttpOnly,ARRAffinity=bbfc29b660328fb8c95bc7afe0f62bbff9944453af8a25c3765b11b5bf63ac935ab954b42cfa12ad9f33ddc80a07e15dd633bd57139a65479392e46e5242529408DC0212D00BE70B1901265142; path=/; secure; HttpOnly",
"Strict-Transport-Security": "max-age=31536000; includeSubDomains",
"REQ_ID": "6d9433fc-5a28-4271-ba68-6da94654f428,6d9433fc-5a28-4271-ba68-6da94654f428",
"CRM.ServiceId": "framework",
"AuthActivityId": "d15fd870-e535-4b93-aca3-b52e07ce6a9e",
"x-ms-dop-hint": "48",
"x-ms-ratelimit-time-remaining-xrm-requests": "1,199.86",
"x-ms-ratelimit-burst-remaining-xrm-requests": "5996",
"OData-Version": "4.0",
"X-Source": "2402351721155594022675123462201311467925524514492481151802940192180225123239173229141,52199173011531127818221199109172188166471108920125114922426852813284249203110198",
"Public": "OPTIONS,GET,HEAD,POST",
"Date": "Thu, 21 Dec 2023 10:21:39 GMT",
"Allow": "OPTIONS,GET,HEAD,POST",
"Content-Type": "application/json; odata.metadata=full",
"Expires": "-1",
"Content-Length": "1023"
},
"body": {
"error": {
"code": "0x80040216",
"message": "An unexpected error occurred.",
"@Microsoft.PowerApps.CDS.ErrorDetails.ApiExceptionSourceKey": "Plugin/Microsoft.Crm.ObjectModel.ImportFileService",
"@Microsoft.PowerApps.CDS.ErrorDetails.ApiStepKey": "24cabb1b-ea3e-db11-86a7-000a3a5473e8",
"@Microsoft.PowerApps.CDS.ErrorDetails.ApiDepthKey": "1",
"@Microsoft.PowerApps.CDS.ErrorDetails.ApiActivityIdKey": "6d9433fc-5a28-4271-ba68-6da94654f428",
"@Microsoft.PowerApps.CDS.ErrorDetails.ApiPluginSolutionNameKey": "System",
"@Microsoft.PowerApps.CDS.ErrorDetails.ApiStepSolutionNameKey": "System",
"@Microsoft.PowerApps.CDS.ErrorDetails.ApiExceptionCategory": "ClientError",
"@Microsoft.PowerApps.CDS.ErrorDetails.ApiExceptionMessageName": "UnExpected",
"@Microsoft.PowerApps.CDS.ErrorDetails.ApiExceptionHttpStatusCode": "400",
"@Microsoft.PowerApps.CDS.HelpLink": "http://go.microsoft.com/fwlink/?LinkID=398563&error=Microsoft.Crm.CrmException%3a80040216&client=platform",
"@Microsoft.PowerApps.CDS.InnerError.Message": "An unexpected error occurred."
}
}
}
Not really sure what I'm doing wrong at this point and I'm not sure if I've missed any other steps so any help would be greatly appreciated 🙂
Cheers all
Sam
I have the same question (0)
All responses (
Answers (
