Hello everyone,
I'm currently building an app for a Risk Register using a SharePoint list.
I posted yesterday as I was struggling to figure out how to get two combo boxes to work for filtering my gallery but that was sorted.
However I have now realised that fixing the combo boxes has broken the Search Input, which I now need help with.
Here is my current formula in the gallery:
Filter(
'Risk Register',
(IsBlank(ComboBox1.SelectedItems) || IsEmpty(ComboBox1.SelectedItems) ||
RiskOwner.DisplayName in ComboBox1.SelectedItems.DisplayName) &&
(IsBlank(ComboBox2.SelectedItems) || IsEmpty(ComboBox2.SelectedItems) ||
RiskStatus.Value in ComboBox2.SelectedItems.Value)
)
That formula allows me to filter my gallery using two combo boxes either independently of each other or simultaneously.
I now need to incorporate this formula but cannot figure out how to do it:
Search([@'Risk Register'], SearchInput1.Text, "RiskDescription", "RiskDescription")
Any help is greatly appreciated!
