Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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);
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.