Hello everyone, I have imported one excel sheet using excel import module….the data was retrieved from the excel sheet correctly. But the problem is that im getting the duplicate records when i was taking one particular field from excel and putting that field in the masterdata. Could you please provide any solution for this. Thanks in advance, Apurupa
A way to prevent this in the future would be to use a “find or create” microflow, something like this:
For your current issue, if the duplicate records are identical, it should be possible to write a fix flow that removes any duplicates, for instance:
Retrieve all records
For each record, check if it's the only one with its unique key (assuming they have one)
If not, add them to a list of items to delete and remove them from the list you're iterating over
After the loop completes, delete the list of items to be deleted
Here i need to remove the duplicate records..how could i do that?