Hi @RoB-E,
You will have to add conditional logic to the OData query in order to handle the empty combobox values. @iClarkSi's approach should solve that issue - I would recommend the following 2 improvements to the code: Avoid 1-time variables via the With function & remove empty false parameters within If statements.
With(
{
//Each individual filter is stored in a function scope variable
//Inspection & Field3 will only contain a odata query value if the combobox has a selected value
wInspectionType10Filter: If(
!IsBlank(Type_ComboBox.Selected.Value),
$"startswith(InspectionType10, '{Type_Combobox.Selected.Value}') and "
),
wField3Filter: If(
!IsBlank(Block_ComboBox.Selected.Value),
$"field_3 eq '{Block_Combobox.Selected.Value}' and "
),
wRemediatedFilter: "Remediated eq false"
},
email.Run(
//Pass through OData query
$"{wInspectionType10Filter}{wField3Filter}{wRemediatedFilter}",
User().Email
)
);
//Notify function below
As alternatives, (a) you could pass through the combobox values and move the OData building logic to your flow or (b) should you already display the records within the app, you can pass them to your flow instead of using a separate List Rows action within the flow.
If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.
Thanks!
