Power Automate RPA Full Course – Day 2 | CSV Data Processing, Filters & Data Cleansing

Welcome to Day 2 of the Power Automate RPA Full Course using Power Automate Desktop (PAD).

In this session, we build a real-time business use case where an ERP-generated CSV file is processed using RPA to clean, filter, and prepare sales data automatically.

📌 Topics Covered in This Video:

✔ Understanding real business RPA use case
✔ Reading CSV file into DataTable
✔ Handling column headers correctly
✔ Removing empty rows from DataTable
✔ Handling rows with blank spaces
✔ Removing duplicate rows
✔ Understanding how duplicate logic works
✔ Filtering DataTable using conditions
✔ Working with date-based filters
✔ Best practice for file path using Environment Variables
✔ Using Input Variables for Cloud integration
✔ Data cleansing automation logic
✔ Preparing data for further calculations

🧠 Use Case Explained

ERP system generates daily CSV sales reports.
RPA bot will:

• Remove blank rows
• Remove duplicate transactions
• Filter required date transactions
• Prepare cleaned dataset for further processing

This reflects real enterprise RPA implementation standards.

🎯 Who Should Watch

• RPA Beginners
• Power Automate Desktop Learners
• UiPath / Blue Prism / Automation Anywhere Migrators
• Power Platform Developers
• Students & Working Professionals

🔔 Subscribe for Upcoming Videos

Next sessions will cover:

👉 Loops
👉 Conditional logic
👉 Calculated columns
👉 Excel automation
👉 End-to-end RPA project

💬 Comment

Post your doubts in comments — I will respond personally.

⏱ Chapters / Timestamps (You can adjust slightly)
00:00 Introduction & Agenda
01:00 Use Case Explanation
02:10 CSV File Structure Overview
03:20 Reading CSV File into DataTable
04:30 Column Header Handling
06:20 Best Practice: File Path as Variable
07:40 Environment Variable Concept
08:50 Removing Empty Rows
10:30 Handling Blank Space Rows
13:20 Removing Duplicate Rows
14:30 Understanding Duplicate Logic
15:20 Filtering DataTable by Date
16:30 Filter Result Validation
17:30 Preparing for Calculated Column