Answered

Duplicating Entries

(0) Share

Report

Posted on by Claborde

I created a flow that when an entry is entered in the sharepoint list it will update the excel file. It keeps duplicating the entry, depending on how my entries are in the excel document.

All responses (7)

Answers (1)

Claborde 15 on at

Like (0)

Report

Re: Duplicating Entries

Going through and looking at history. I don't see anything that stands out. Depending how many entries are on the sheet, which is how many times it will duplicate that data entered. I think I must get the "apply to all" off, but I haven't figured that out.
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Re: Duplicating Entries

Hi @Claborde

Did you make sure that you cleared out all of the duplicate rows from the other day? Take a look at the history. You will be able to see how many runs the apply to each did and on what data, as well as looking at your filter history to understand why you have retrieved more data than expected.

Damien
Claborde 15 on at

Like (0)

Report

Re: Duplicating Entries

@DamoBird365,
I thought it was working but it did it again... Do I have to create an additional filter? (This is what I had in the filter array)
Claborde 15 on at

Like (1)

Report

Re: Duplicating Entries

Thanks for the help, that worked 😁
Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report

Re: Duplicating Entries

Hi @Claborde

No need to touch the apply to each if you apply a filter to the list rows as then you will only return 1 value.

Your filter would be:
Title eq 'dynamicfieldfortitle'
where you select the dynamic field Title from the SharePoint trigger

Title eq ''

Damien
Claborde 15 on at

Like (0)

Report

Re: Duplicating Entries

Could you help assist with that process? I am new to power automate.... One video showed where it was feasible to remove the flow from "apply to all" but it is not allowing me to do it.
DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report

Re: Duplicating Entries

Hi @Claborde

It's because you have an apply to each in yes, which will run by the number of items returned by list rows in table. To limit this, the easiest option without changing the apply to each would be to apply a filter to list rows so that it only returns the row where the Title eq 'dynamicfieldfortitle' OR you could use the dynamic fields from the Filter Array which should in theory only include 1 record.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien