abusen333Frequent Visitor5 years agoSolvedFiltered Row Content is changing every time when adding el workbook I have to change Content Filtered Rows"{3} number every time when I add new excel workbook , how can fix this problem? Show MoreFowmy5 years agoabusen333 I think you need to always get the last file from the folder. Currently, it takes the 4th by default and you change each time you add a file right?Go to the advanced editor and replace line number 5 with the following: Content = List.Last(#"Filtered Rows"[Content]),
Fowmy5 years agoabusen333 I think you need to always get the last file from the folder. Currently, it takes the 4th by default and you change each time you add a file right?Go to the advanced editor and replace line number 5 with the following: Content = List.Last(#"Filtered Rows"[Content]),
Fowmy5 years agoabusen333 I think you need to always get the last file from the folder. Currently, it takes the 4th by default and you change each time you add a file right?Go to the advanced editor and replace line number 5 with the following: Content = List.Last(#"Filtered Rows"[Content]),
FowmySuper User5 years agoabusen333 I think you need to always get the last file from the folder. Currently, it takes the 4th by default and you change each time you add a file right?Go to the advanced editor and replace line number 5 with the following: Content = List.Last(#"Filtered Rows"[Content]),
Related contentWorkbook into LakehouseSeparate workbook to guide dynamic changesScheduling Excel Workbook Connection (Dataflow) RefreshFilterODBC Connection to Excel Workbooks
