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-
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
@NChamroo
What's the exact query filter you are using?