Answered

Impossibility to delete a desktop flow

(0) Share

Report

Posted on by NC-23071219-0

Hello,

I recently created some desktop flows for a debug usage, and don't need them anymore. I wanted to delete them from my environment, but here I encounter the following error : The DELETE statement conflicted with the SAME TABLE REFERENCE constraint "flowsession_flowsession_parentdesktopflowrunid". After making my own researches, I found ot that this constraint is created when the desktop flow is used by another desktop flow. My problem is that my flows are 100% not used by another flow :/ so this makes no sense to me.

Moreover, I investigated the tables in Power Apps, and it tells me that there are no elements using this dependency.

Categories:

Power Automate Desktop

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

Pstork1 68,717 Most Valuable Professional on at

Like (0)

Report

Are you trying to delete them using the Cloud web site or inside the Power Automate Desktop client? I suspect you are trying to do it from the Cloud and have some instances of the Desktop flow that are still running. Cancel those running flows and then try to delete the desktop flow using the Power Automate Desktop client.

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
NC-23071219-0 24 on at

Like (0)

Report

Hello Pstork1,

I tried to delete the flows from both cloud and desktop client, and both aren't working, with the same error. I have for sure no instance currently running, as I haven't shared my flows and they are not part of any cloud flow.

Was this reply helpful? Yes No
Verified answer

NC-23071219-0 24 on at

Like (0)

Report

OK I finally found the answer to my problem :

I had some entries in the table flowsession (you can see the table in Power Apps -> Tables -> display all tables -> filter on name : flowsession), using the ID of my flows in the column ParentWorkFlowID (you can find your flow ID in Power Automate Desktop by opening the properties of your flow and copying it from the Detail tab).

After deleting these entries, I was finally able to delete my flows. However I have no idea how these entries have been created, so how they were created will remain a mystery to me.

1 people found this reply helpful.

Was this reply helpful? Yes No