Unanswered

Power Automate fails to add to a Sharepoint list due to duplicate value issue even though the flow detects the record already exists and runs an Update Item.

(0) Share

Report

Posted on by P1c0Pugh

I have a flow which reads a table from an excel spreadsheet, reviews a SharePoint list and is it finds the same record (in this case device serial number) it will update the record, or create a new one. Almost every record in the excel should already exist so the update item flow works in every other case except this one.

I have deleted the record from the SharePoint list and it recreates it but also it doesn't fail to update every time by the looks of it.

Why is this record being detected as a duplicate when the same rules for over 2000 other records work as expected?

Also, i have noticed that the ID given back to the record suggests it is recovering the deleted entry rather that creating a new one. Is this possible?

Categories:

General topics

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Hardesh15 7,087 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@P1c0Pugh Please share your flow screens. This will help us to understand your flow design.

Please 'Thumbs Up' the posts that helped you and 'Accept as Solution' if my post answered your question.

@Hardesh /Gopenly.in

Was this reply helpful? Yes No
nilampathan 2 on at

Like (0)

Report
Copy link

Link copied!

Dear Team,

1) please recommended I have bulk of PDF invoices convert into excel

2) also how can i automate file that daily headcount sheet getting from email (multiple partner) how can automate this file
for example day 1 paste data day 2 append daily emails

Was this reply helpful? Yes No
P1c0Pugh 10 on at

Like (0)

Report
Copy link

Link copied!

The bit where it fails is in this section
The get items looks for the serial number of a device and if it finds it does the Update Item and if it doesn't it does the create. The update item correctly gets called.

Was this reply helpful? Yes No
P1c0Pugh 10 on at

Like (0)

Report
Copy link

Link copied!

The output from the run shows.

As you will see there are over 2000 items to update, the vast majority will be of type update, and this is the only record that fails.

Was this reply helpful? Yes No
P1c0Pugh 10 on at

Like (0)

Report
Copy link

Link copied!

this is the error

{
"status": 400,
"message": "The list item could not be added or updated because duplicate values were found in the following field(s) in the list: [Device Serial Number].\r\nclientRequestId: "

But there is no duplicate record.

It seems that for this record, it tries to update but has to create a new record first. As I said I deleted this record from the sharepoint list, and it recreated fine, but it recreated with the ID number 556 and I would have thought if it was deleted it would get created with a ID of nearly 3000 as this is how many records are in the list.

The excel file is an existing on, already has the table defined and is used in other flows fine.
}

Was this reply helpful? Yes No