Check for duplicates in Excel update a row

(0) Share

Report

Posted on by ClaireAllen

762

Hello Community,

I have built a flow that gets information from a SharePoint list and updates a row in Excel,

But, what I would like to do is check for Duplications, rather than the data be overwritten or having to add a condition to look to see if the SharePoint ID is equal to null which is what I have done, as shown below

How do you check for Duplications?, I would like to send an email or summary on the duplicated items if possible.

This is my current workflow, which works at the moment, but I would like to improve this by checking for Duplicated items

I'm updating the SharePoint ID from a List, into the Excel Table

Screenshot 2020-09-15 145418.png Screenshot 2020-09-15 145436.png

Any assistance to resolve the issue for checking duplicated items would be appreciated.

Thank you & regards

Claire

All responses (8)

Answers (0)

ClaireAllen 762 on at

Like (0)

Report

Re: Check for duplicates in Excel update a row

Hello @v-alzhan-msft

So my workflow is still different to yours
I followed your steps,
Step 1, I've added a Recurrence rather than a manual options
Step 2, when I was configuring the Get Items, the system again automatically added a apply to each when I entered the Filter Query
Step 3, hopefully this is correct? but I still have 3 Apply to each due to Step 1
Step 4, I'm now not sure if I have entered the correct information, as I am confused with the condition above
Step 5, Error on Run (I have used this expression before on a previous flow without any problems?

Kind regards
Claire
ClaireAllen 762 on at

Like (0)

Report

Re: Check for duplicates in Excel update a row

Thank you @v-alzhan-msft
I will re-build my flow to be the same as yours and will advise the outcome

Thank you
Claire
v-alzhan-msft on at

Like (0)

Report

Re: Check for duplicates in Excel update a row

Hi @ClaireAllen ,

Your flow is different with mine:

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ClaireAllen 762 on at

Like (0)

Report

Re: Check for duplicates in Excel update a row

Hello @v-alzhan-msft

Thank you for coming back to me, I did refer to your screen shot, and this is the message that I received, which is where the third apply to each was added by the system.

This is my current workflow,

I tried to add the extra condition in as you mentioned, but the workflow failed.
I did ask a question on a previous post, as I was a little confused on how the flow would run, which was:-
By adding the extra condition in as advised, my understanding is that if the Excel Column and SharePoint Column match to update the Row, but they won't match until after the flow has run and put the ID from SharePoint into that Column, so do I need to add the condition somewhere else?

I appreciate your assistance.

Kind regards
Claire
v-alzhan-msft on at

Like (0)

Report

Re: Check for duplicates in Excel update a row

Hi @ClaireAllen ,

Please make sure that you has refer to my screenshot below to create the flow, and it would be impossible that the additional apply to each would be added.

Please check your flow or share the full screenshot of your flow so I could find the problem in it.!

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ClaireAllen 762 on at

Like (0)

Report

Re: Check for duplicates in Excel update a row

Hello Community,

Can anyone help me with my issue?
I'm trying to check for duplicates in my workflow which is in the message thread.

Any help would be appreciated to get this working.
Thank you
Claire
ClaireAllen 762 on at

Like (0)

Report

Re: Check for duplicates in Excel update a row

Hello @v-alzhan-msft ,

Thank you for the advise,
I tried to remove the third apply to each, but when I added the additional information in the condition it automatically enters another Apply to each
Now that I have added the extra condition in, my Flow does not work, my Excel list does not update with the SharePoint ID as it did before.
By adding the extra condition in as advised, my understanding is that if the Excel Column and SharePoint Column match to update the Row, but they won't match until after the flow has run and put the ID from SharePoint into that Column, so do I need to add the condition somewhere else?
Sorry I'm a little confused.

Thank you
Claire
v-alzhan-msft on at

Like (0)

Report

Re: Check for duplicates in Excel update a row

Hi @ClaireAllen ，

I see you have three Apply to each in your flow, you need to remove the extra one.

And You need to have a column in excel would be same with the column in sharepoint for identify the special row.

You could take a try to refer to screenshot below to create the flow:

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.