Skip to main content

Notifications

Power Automate - General Discussion
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:
  • AlexEncodian Profile Picture
    AlexEncodian 4,325 on at
    Re: Power Automate- Filter & Copy Excel Table (Pivot File) to master Excel File

    @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

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,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard