Finance | Project Operations, Human Resources, ...

Duplicate records allowed inserting records using Power Automate F&O connector

(2) Share

Report

Posted on by CU29041349-0

610

Hello:

Fairly new to Power Automate, or at least not have much experience with it. Here's my issue. I have a custom table with two field making up the unique index. I also have a data entity built against said table. When I use Open in Excel to attempt to load records containing the same key values, I'm met with an error stating so.

I created a Power Automate flow which uses the F&O "Create a record" connector. I won't bore you with the details, but it essentially reads from a csv, parses it, and calls the connector. When this connector is used to insert records with existing index values, it does not error out or fail, but runs successfully to completion. When I check the table, I now have multiple records with the same index key values. Unsure if this connector is not meant for what I'm using it for or there's some sort of bug. Looking for any insight.

Thank you!

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Sahan Hasitha 2,683 on at

Like (3)

Report
Copy link

Link copied!

hi

The reason you are seeing duplicate records is that the Power Automate Create a record action always inserts new rows and does not check for existing key values. Unless your custom table’s composite index is set as Unique = Yes (or used as the ReplacementKey), F&O will allow duplicates. To fix this, you should first ensure the two-field index on your custom table is defined as a unique index so that the system throws an error when duplicates are attempted. On the Power Automate side, instead of always creating records, you can build an upsert pattern by first querying the table with the two key fields; if a match exists, update it, and if not, create it. For larger CSV imports, using the Data Management Import project is also a better option because it validates keys and prevents duplicates automatically.

1 people found this reply helpful.

Was this reply helpful? Yes No
André Arnaud de Cal... 303,718 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Moved the question from the Dynamics 365 General to the F&O forum.

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 303,718 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please check your index definition on the table in Dynamics 365 F&O. Did you set the property Allow Duplicates to No?

The Power Automate Dynamics 365 Fin&Ops connector is using OData. It wil ALWAYS check for possible duplicates based on indexes that do not allow duplicates. This is performed on SQL server level. So most likely, the Allow Duplicates is not having the correct property value.

Most likely, you will see the same behavior when adding record in a form or with X++ coding.

Was this reply helpful? Yes No
Suggested answer

Sagar121 1,160 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Probably your index will have allow duplicates here. I don't see issue with power automate becuase ultimatley table should reject it. Try to create record from table browser and check if duplicates are allowing.

Was this reply helpful? Yes No