Share
ReportGreetings 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''.
Categories:
All responses (
Answers (
432
