web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Import Into Dataverse ...
Power Automate
Unanswered

Import Into Dataverse Table using Flow with Duplicate Detection

(0) ShareShare
ReportReport
Posted on by 2

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

SamConroy1_0-1703758483479.png

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.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
Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard