I am trying to create a simple Manual trigger flow to get rows from the MySQL table and insert those rows in the SharePoint list. I am getting the error message "The list item could not be added or updated because duplicate values were found in the following fields in the list: [auditType]."
Each customer has several audit_type with different id (MySQL table ID), for example:
Id | Customer name | Audit type |
1 | A | S1 |
2 | A | S2 |
3 | B | S1 |
4 | B | Recerti |
Any assistance would be appreciated!
Step:
