Deleting Duplicate Data from Excel when combining 3 Sharepoint Lists

[erikah]

I am creating a Training Log that HR can use to collect agency training data. I have 3 separate Sharepoint List and I have been able to use Flow to put them in Excel. Everything is great, except, I'm having duplicate data. I realized that it will duplicate every time I run the Flow. This is a really big problem. To add to my confusion, I have another Flow that will update what is in Excel to a 4th Sharepoint list. This list is not showing the duplicates. I'm so confused. I have attached all the pictures. Thank you in advance for the help. 

[v-alzhan-msft]

Hi @erikah ,

Could you please explain your requirement for your flow?

What is your requirement for the Condtion3 in your first picture?

Could you please explain more about the flow in your third picture?

Please explain more details so we would better understan your requirement and try to provide a proper workaround for you.

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.

[erikah]

@v-alzhan-msft 

Of course! 

The requirements for Condition 3 (and all the conditions) is that if the Excel variables are not equal to the SharePoint variables, update the variables in the Excel doc. The flow begins by stating Get Sharepoint Lists and Add them to Excel. Since I have 3 lists, I did each list separately in order to get them all to add into the spreadsheet. That is why you see the flow go back and forth between Sharepoint commands and Excel. I want to continue to add all three lists into one Excel worksheet, I just can't figure out how to keep it from duplicating the data in Excel. Does that make more sense?