I’ve built a page to view the status of every form response (similar to the Leave Request template). As well as clicking through the buttons to view the form responses in each category; all, pending, approved and denied, I’d also like to add a search bar in to filter through responses. The formula I’m using which is working is:
Search(
Filter('Hire Authorisation Submit',_requestTypeFilter = "All" ||
Status.Value = _requestTypeFilter),
'Hire Authorisation Search Bar'.Text,"field_6","field_7","field_8","field_9","field_4")
However, I’d also like to add field_5 into the formula for the search bar, the only issue is, within Sharepoint, this column is a Choice column. I’ve had a play around using the ‘Value’ item before and after “field_5” within the formula, however, I can’t find a way to add it in with the formula working.
Do you have any ideas on how I’d be able to do this, please?
