web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Power Automate- Filter...
Power Automate
Unanswered

Power Automate- Filter & Copy Excel Table (Pivot File) to master Excel File

(0) ShareShare
ReportReport
Posted on by 5

Hello Developers, SMEs, MVPs, 

 

I am stuck with a used case and need your expertise. My Finance Team sends a monthly Pivot Excel file that also includes a data table (column in General Format since it is extracted from SAP). The file name changes every month. The data table has 5000 rows and 180 columns. 
I am using Power Automate to copy the existing rows in the data table (Table1) to a master file and consolidate the monthly data. 

 

The steps I am applying are as follows- 

 

  1. When an email arrives V3
  2. Get the attachment 
  3. List of rows present in a table (Pagination 10000)
  4. Condition - Account code 8789292 and Area Code O0098

 

Unfortunately, it is not filtering the column based on the condition. Could it be that the column format is General?

 

Appreciate your insight on this. 

 

THanks 

Nitz 

 

Categories:
I have the same question (0)
  • AlexEncodian Profile Picture
    4,409 Moderator on at

    @NChamroo 

    What's the exact query filter you are using?

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 307 Super User 2026 Season 1

#2
David_MA Profile Picture

David_MA 269 Super User 2026 Season 1

#3
Power Platform 1919 Profile Picture

Power Platform 1919 115 Super User 2026 Season 1

Last 30 days Overall leaderboard