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

(0) Share

Report

Posted on by CU29041349-0

556

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:

Power Platform integration

I have the same question (0)