How to write variable to a filtered Excel

Help
1

The Scenario is: get text activity is used and message is stored as a variable, then that value need to be written in Excel, however that excel need to be filtered based on some conditions, first I use excel application scope and use Select to filter excel and store as another datatable, however I don’ t how to write that value in afterfiltered datable and also the painpoint for me is that value is dynamically write in Column K, let’s say base on the filter there is two lines, and I need to fill in K2 and K3, can anyone help on that? Really urgent for me, thanks.

2

WF
WF418×782 13.9 KB

as both write cell in excel and workbook cannot be based on filtered dt, so any good ideas? May appreciate your help.Thanks!