Button query passing to PowerAutomate to email a CSV, PDF, and embedded HTML of query list.

[Syndicate_Admin]

I have the following query for OnSelect for a button to pass my currently selected data to a PowerAutomate routine attaching the data to an email as PDF, CSV, and embedded HTML, but this query is not working. Any help appreciated.

ExportTasks.Run("Filter(
If(
//This is for ALL and ALL
ddType.Selected.Result = "All" & ddManuf.Selected.Result = "All", 'Computer Peripherals Inventory',

//This is for selected Manufacturer and ALL Asset Type
ddType.Selected.Result = "All" & ddManuf.Selected.Result <> "All",
Filter('Computer Peripherals Inventory', Manufacturer = ddManuf.Selected.Result),

//This is for selected Asset Type and ALL Manufacturer
ddType.Selected.Result <> "All" & ddManuf.Selected.Result = "All",
Filter('Computer Peripherals Inventory', 'Asset Type' = ddType.Selected.Result),

//This is for selected Manufacturer and selected Asset Type
ddType.Selected.Result <> "All" & ddManuf.Selected.Result <> "All",
Filter('Computer Peripherals Inventory', Manufacturer = ddManuf.Selected.Result & 'Asset Type' = ddType.Selected.Result)),

//This is for search bar
TextInput1.Text in 'Serial Number' Or TextInput1.Text in Model Or TextInput1.Text in Location)",User().Email);

[v-jingzhang]

Sorry this is out of the scope of Power Query. You can post this topic to Building Power Apps - Power Platform Community to seek for more professional suggestions.