Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Syndicate_Admin
Administrator
Administrator

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

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);

 

1 REPLY 1
v-jingzhang
Community Support
Community Support

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. 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors