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.

Categories:

Using flows

I have the same question (0)

All responses (7)

Answers (1)

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Claborde 15 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

DamoBird365 8,942 Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Claborde 15 on at

Like (1)

Report
Copy link

Link copied!

Thanks for the help, that worked 😁

Was this reply helpful? Yes No
Claborde 15 on at

Like (0)

Report
Copy link

Link copied!

@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)

Was this reply helpful? Yes No
DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Claborde 15 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No