Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

From CSV delete rows that match another CSV file values (like vlookup)

(0) ShareShare
ReportReport
Posted on by 13

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

 

rogerlopez21_0-1708322457674.png

 

 

rogerlopez21_1-1708322470083.png

 

  • Re: From CSV delete rows that match another CSV file values (like vlookup)

    Hi @rogerlopez21 ,

     

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard