Hi all,
Background: I have an Excel table that has interview responses populated into it. Each applicant has 2 rows of data in the table as they are interviewed by 2 people. The flow below makes the application numbers unique and merges the 2 rows of data into one. However, if I run the flow more than once, there will be duplicates of ID generated in the consolidated final table. How do I filter out the duplicated IDs?
Please see the screenshot of the flow below: https://ibb.co/hBNVc7h
Refer to this link for my previous question: https://powerusers.microsoft.com/t5/Building-Flows/Combine-raw-data-from-Excel-table-using-ID-into-another-table/m-p/753974#M103991
@Paulie78 has kindly responded with a detailed way on how to resolve the previous issue.
