Share
ReportHI Team,
I am preparing a flow for below steps:
1. Open the excel file from One drive
2. copy the rows where "Reporting Month" equal to "Current month - 2"
3. Add the rows below table and paste the copied rows only along with formula (if any)
4. Change the "Reporting Month" as "Current month -1" for Copied rows only
5. Remove the data from "Target" and "Achieved" columns for Current Month
2. copy the rows where "Reporting Month" equal to "Current month - 2"
3. Add the rows below table and paste the copied rows only along with formula (if any)
4. Change the "Reporting Month" as "Current month -1" for Copied rows only
5. Remove the data from "Target" and "Achieved" columns for Current Month
I have created below flow:
Flow ran successfully, but in the output its coly all the rows instead of filtered row, also Not copy the formula which is available in the cells.
Please assist.
Regards,
Abhishek Goel
Categories:
All responses (
Answers (
566
