Unanswered

Error Message: The list item could not be added or updated because duplicate values were found in the following fields in the list: [auditType].

(0) Share

Report

Posted on by Jamil1

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:

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (1)

Jamil1 19 on at

Like (0)

Report

Problem solved!

Was this reply helpful? Yes No
v-jefferni on at

Like (0)

Report

Hi @Jamil1 ,

I haven't seen this error before, could you please share your solution to help other users who may be experiencing this issue?

Best regards,

Was this reply helpful? Yes No
Verified answer

Jamil1 19 on at

Like (2)

Report

Problem: enforce unique values "yes" (audit type)

Was this reply helpful? Yes No
PaulUK86 43 on at

Like (0)

Report

I have the same problem, however mine only works when selecting no to unique value. Instead of updating, it then creates a new line (even when using update item). Any advice on this would be appreciated?

Was this reply helpful? Yes No