EXCEL ONLINE script filter pivottable with Power Automate data

Goudriaan 

If for manual filter as here

script could be

function main(workbook: ExcelScript.Workbook) {

	const pivot =
		workbook
			.getWorksheet("Sheet1")
			.getPivotTable("ptSample")

	const filterFiled =
		pivot
			.getHierarchy("Category")
			.getFields()[0]

	const filterBy =
		filterFiled
			.getItems()
			.map( x => x.getName() )
			.filter(x => x.includes("Microsoft") )

	filterFiled
		.applyFilter( {
			manualFilter: { selectedItems: filterBy }
		} )

}

it also works if move Category in rows

If finally you would like to have collapsed fields as

we may add to the script the block at the bottom

function main(workbook: ExcelScript.Workbook) {

	const pivot =
		workbook
			.getWorksheet("Sheet1")
			.getPivotTable("ptSample")

	const filterFiled =
		pivot
			.getHierarchy("Category")
			.getFields()[0]

	const filterBy =
		filterFiled
			.getItems()
			.map( x => x.getName() )
			.filter(x => x.includes("Microsoft") )

	filterFiled
		.applyFilter( {
			manualFilter: { selectedItems: filterBy }
		} )

	pivot.
		getHierarchy("Product")
		.getFields()[0]
		.getItems()
		.map( x => x.setIsExpanded(false))

}