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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Importing Desktop flow...
Power Automate
Unanswered

Importing Desktop flow duplicate key error

(0) ShareShare
ReportReport
Posted on by 4

Thank you all so much for any help.  I have a simple flow that opening an excel file, running a macro, closing the excel file, and then merging the PDFs created from the excel macro.  The issue I am getting is not on running the flow, but when created a solution and exported to a zip it will not allow any of my co-workers to import it.  See flow and error below.  The funny thing is I can select an different environment from Personal Production and it allows it to be imported then.  I or any of my co-workers do not have this solution currently in my personal production environment.  I have already selected to share it in the environment it does let me have it run in, but it does not show up in their Power Automate online or desktop.  So the only solution is to get them to import solution but error keeps occurring.  Thank you for any help.

Garyfri_1-1661444400190.png

 

 

Garyfri_0-1661443858004.png

From downloaded log

Error while importing workflow {04e03029-4b71-449e-b24f-2cee91c9d1ed} type RoboticProcessAutomationFlow name Daily_SOS: Cannot insert duplicate key exception when executing non-query: System.Data.SqlClient.SqlCommand Exception: System.Data.SqlClient.SqlException (0x80131904): Violation of PRIMARY KEY constraint 'cndx_PrimaryKey_Workflow'. Cannot insert duplicate key in object 'dbo.WorkflowBase'. The duplicate key value is (04e03029-4b71-449e-b24f-2cee91c9d1ed, 0, Jan 1 1900 12:00AM).
I have the same question (0)
  • Garyfri Profile Picture
    4 on at

    Following up. to ask for help.  Original post was marked for spam so not sure if people saw this.  Thank you for any help.

  • Pavel_NaNoi Profile Picture
    1,074 on at

    Looks like a duplication error of Dataverse, are you sure you're not importing an entire pre-built solution? It should be one you've created and have nothing but your desktop automation in it.

     

    If that is not the case, just use the other method of importing desktop automations via .txt files, CTRL+A in your automation, CTRL+C, paste that into a .txt file, send the file to your co-workers and ask them to copy everything out of that .txt file and to click on some blank space in a blank desktop automation and to CTRL+V to paste everything.

  • Garyfri Profile Picture
    4 on at

    no it is all my solution only.  I will try the other method you are speaking of.  I google the copy text and did not see any videos but will try it.  Thank you.

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 267 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 196

#3
Haque Profile Picture

Haque 182

Last 30 days Overall leaderboard