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-
- When an email arrives V3
- Get the attachment
- List of rows present in a table (Pagination 10000)
- 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


Report
All responses (
Answers (