Answered

duplicated data in

(0) Share

Report

Posted on by TarekEzz

hi everyone

am creating a flow that will take an employee list from Sharepoint
and store it in an Excel table, every time the bot runs will take all the data in the SharePoint list. thus, there will be a lot of duplicated data (every everytime it runs)
so am trying to make it after it stores everything, to delete only the duplicated and leave the original one
does anyone have an idea how to do that?
after that, I wanna add a part where it will make the bot run, and every month it will create a new excel table with the new month name ( so the data won't be too much in the future ) is that possible?

appreciated the help

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Offcourse, you can build a flow that loops through each SharePoint item and checks if it exists in excel. If yes, it updates otherwise create.

However, wouldn't be easier if it just deletes everything from excel and inserts the records again during each run? That will be simpler to achieve.

Was this reply helpful? Yes No
TarekEzz 16 on at

Like (0)

Report
Copy link

Link copied!

That's a brilliant idea. much appreciated.
so should I make it delete the data first, then store it again? so this way everytime it runs it will clean up then it will store everything from beginning?

if may i ask you, if you have an idea of how to make save the Excel file monthly and create a new one every month
or should there be another bot for this part?
since this sheet by time will have a lot of data and it would not be easy to find something or search inside it .

Was this reply helpful? Yes No
Verified answer

SudeepGhatakNZ 14,394 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Yes that is another option you have.

You can build a recurrence flow that generates a new file every month (by including the date in the file name).

That way you wont have to delete records, you can just create a new file each time

Was this reply helpful? Yes No