Power Platform Community Forum Thread Details

Hello, we have 5 microsoft forms that our customer submitted their data to. Five power automate flows are set up to transmit all submitted data into one big excel file. The microsoft data forms look good. The five flows look correct. However, two duplicated rows (duplicated id, completing time, source number, and all information) started to show up in the big excel table, for every new entry from the five microsoft forms, all starting from a specific date. I have rule out many potential reasons:

1) No “Apply to each” container exists

2) Run history shows only one run.

3) No duplicate IDs within any individual microsoft form, and user didn't submit twice.

4) no overlapping trigger logic. Each flow looks correct.

5) file is not moved, restored, or replaced, and file path remained unchanged.

6) use peek code, I didn't find any wrong codes.

According to AI, other reasons could be due to excel being open more often, which is true. The file is managed by only one staff, but more than 3 staffs now. That might make the excel connector "retries" the same request, which cause the duplicated data. AI suggests 1) add deduplication logic, and 2) enable concurrency control =1 on each trigger.

But I want to look for some suggestions here in the forum. Appreciated any feedback and ideas about why this might happen and how to solve this.

Thank you!

Categories:

General topics