Export CSV using Power Automate with Dynamic Filters

[nat3]

Hi all, newbie Power Apps user here. I am really struggling here and would appreciate any feedback or guidance.

I have a gallery within Power Apps that has several dropdown filters (pictured below):

I followed Reza's video for exporting large data sets to the logged in user's email. When I only use one filter (modified to not use startswith and to return all values if the dropdown is blank), it works like a charm:

However, for the life of me, I cannot figure out how to add filters. I would like to also add filters that rely on dd_building_MI, are between dd_start, and dd_end. If any of the fields are blank, then provide everything. For example, if the campus dropdown is populated with 'ABC' and nothing is entered for the building dropdown, export the monthly inspections for campus 'ABC', regardless of the building. I attempted to add onto this code by using 'And' (see below), but it returns an error:

These are the field types:

And the dropdowns have the following items property:

Where am I going wrong here? 

[v-yueyun-msft]

Hi , @nat3 

According to your description, you are using the Get items to get the data in your SharePoint.

For example , if you want to add the MIBuildingHardcode field filter in the filter query, you need to add this here :

For this , you can refer to :

Power Automate SharePoint Get Items Filter Query + 12 Examples - EnjoySharePoint

So in Power Apps , you need to use this code to pass to your flow:

ExportMonthly.Run(" (MICampusHardcode eq ' " & dd_campus_MI.Selected.Value & "') and (MIBuildingHardcode eq '" & dd_building_MI.Selected.Value & "')"   )

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance! 

Best Regards,

Yueyun Zhang

[nat3]

Thank you @v-yueyun-msft. In your example, what would I replace the 'xxxx' with under Get Items? I tried two different approaches and neither worked (pictured below). Not sure if this is why I am getting an error within the Power Apps code (invalid number of arguments: received 2, expected 3): 

[v-yueyun-msft]

Hi, @nat3 

The xxx is replaced by the "dd_campus_MI.Selected.Value" and the "dd_building_MI.Selected.Value" directly in Power Apps.  

In power Automate , Filter query need :
(MICampusHardcode eq 'Value1') and (MIBuildingHardcode eq 'Value2')

This means it will filter the data when the [MICampusHardcode]="Value1" and [MIBuildingHardcode] ="Value2".(The Value is the data in your column instead of the control name)

So you just need to pass one Query to flow:

And the Query is all from the Power Apps.

For example , the first parameter to flow is all the string which need in "Filter Query":

Best Regards,

Yueyun Zhang

[nat3]

Thank you @v-yueyun-msft - no luck, as I am still receiving an error 😭:

Error on button:

[v-yueyun-msft · Accepted solution]

Hi , @nat3 

This error code means that in your power apps it lack parameters. If you update the flow , you need to click "refresh" button for the flow.

And in your screenshot , there are two parameters, in general you need to pass two parameters.

FlowName.run( Query , Email  )

Best Regards,

Yueyun Zhang

[nat3]

Thank you SO much @v-yueyun-msft - I followed your guidance and that resolved the issue. I passed through only one query parameter, hit refresh & voila!