Power Platform Community Forum Thread Details

I have 2 files and want to delete/remove rows from one when value is found in a different file.

Categories:

Power Automate does not provide out-of-the-box actions for manipulating rows and columns in CSV files. This is because the content of a CSV file is essentially a form of text with a specific format. If you intend to automate table processing for CSV files, it requires using a combination of complex string manipulation functions to parse the CSV file. If possible, I would recommend converting the CSV file to an XLSX file and formatting the data into a table before using Power Automate for automated data operation.

I think this link will help you a lot:

https://powerusers.microsoft.com/t5/Building-Flows/How-to-Read-CSV-file-using-Power-Automate/td-p/1923395

Best Regards,

Bof