
I have a flow that is triggered from a button in my Powerapp. The flow takes 6 or 7 parameters from the Powerapp which then become the filters for the recordset - in the Powerapp they are simply comboboxes which the user selects if they want to filter by Status or Incident type for example. The Flow processes these filters and the end result is an HTML table which is emailed to the end user.
Problem is the end user may want to start by seeing ALL the records so no filters should be applied; therefore I am seeking a way to filter ONLY those comboboxes that have been selected - for example if the user just chooses Incident (from the Incident or Hazard selection) they will get ALL Incidents; if they also select the Status as "In Progress" they will see all Incidents In Progress. I want this to be flexible so they can choose nothing, a few things or everything.
My FLOW Filter looks like this at the moment:
I think I just need to say something like If(!IsBlank(Combobox.Selected.Value then filter that value otherwise display all records) but I don't know how to do this in Flow as I am a newbie
any help greatly appreciated