jsmith2094
New Member
- Joined
- Aug 19, 2021
- Messages
- 35
- Office Version
- 365
- Platform
- Windows
HI,
not sure if this is the correct place to post.
I need an office script to use with power automate to filter a column called "Ref" and to only include anything that starts with IM or AF.
when I use the recorder it does not do it dynamically
can anyone help ?
here is the code:
function main(workbook: ExcelScript.Workbook) {
let tABLE1 = workbook.getTable("Table1");
// Apply checked items filter on table tABLE1 column Reference Num
tABLE1.getColumnByName("Reference Num").getFilter().applyValuesFilter(["AF-123456", "IM-123456"]);
}
not sure if this is the correct place to post.
I need an office script to use with power automate to filter a column called "Ref" and to only include anything that starts with IM or AF.
when I use the recorder it does not do it dynamically
can anyone help ?
here is the code:
function main(workbook: ExcelScript.Workbook) {
let tABLE1 = workbook.getTable("Table1");
// Apply checked items filter on table tABLE1 column Reference Num
tABLE1.getColumnByName("Reference Num").getFilter().applyValuesFilter(["AF-123456", "IM-123456"]);
}