Power Query doesn't update existing Rows

[Syndicate_Admin]

Greetings Power Query community,

I have some issues with two Dataflows matching the same reqNR and updating the row in a Dataverse Table.
What I want to accomplish is:
Dataflow 1 creates some data.

Dataflow 2 matches the reqNR and updates the Rows with additional info.

Now Dataflow 2 is creating a new Row even if the reqNR is the same.

I don't get why the Flows behave like this, I think I'm the Problem here and I'm doing something wrong.

Can somebody please help me to resolve this?

Thanks in advance
Edit:
If I try to create a new Key for the Table, I get this Error Code after running the Dataflow again:
The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name''and''.

[v-yingjl]

Hi @Syndicate_Admin ,

When you try to create a new key for the table, based on the error message, seems like there are duplicated values in your table. Please try to check you tables value to remove duplicated records and check it again.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.