I currently have a filter which looks like this:
Filter(
If(StatusValue="Drafts",Filter('Enquiries List',Status.Value="Draft"),If(StatusValue="Submitted",Filter('Enquiries List',Status.Value="Submitted"),If(StatusValue="Approved",Filter('Enquiries List',Status.Value="Approved"),If(StatusValue="Quotes",Filter('Enquiries List',Status.Value="Quotes"),If(StatusValue="Feedback",Filter('Enquiries List',Status.Value="Feedback"),If(StatusValue="Gate 1",Filter('Enquiries List',Status.Value="Gate 1"),If(StatusValue="Launched",Filter('Enquiries List',Status.Value="Launched"),If(StatusValue="Declined",Filter('Enquiries List',Status.Value="Declined"),If(StatusValue="Archived",Filter('Enquiries List',Status.Value="Archived"),'Enquiries List'))))))))),Requested_x0020_By.DisplayName in RequestedByDropDown.SelectedItems)
When the dropdown (RequestedByDropDown) is blank I get no results (as designed). What I want is to return all values, and then just those that match the values in RequestedByDropDown. For this I think I should be using the search function. I have therefore tried:
Search(
If(StatusValue="Drafts",Filter('Enquiries List',Status.Value="Draft"),If(StatusValue="Submitted",Filter('Enquiries List',Status.Value="Submitted"),If(StatusValue="Approved",Filter('Enquiries List',Status.Value="Approved"),If(StatusValue="Quotes",Filter('Enquiries List',Status.Value="Quotes"),If(StatusValue="Feedback",Filter('Enquiries List',Status.Value="Feedback"),If(StatusValue="Gate 1",Filter('Enquiries List',Status.Value="Gate 1"),If(StatusValue="Launched",Filter('Enquiries List',Status.Value="Launched"),If(StatusValue="Declined",Filter('Enquiries List',Status.Value="Declined"),If(StatusValue="Archived",Filter('Enquiries List',Status.Value="Archived"),'Enquiries List'))))))))),
RequestedByDropDown.SelectedItems,
Requested_x0020_By)
The problem seems to be with the last value "Requested_x0020_By". Powerapp doesn't seem to like it. It is a column in sharepoint list that is either a person or group.
Any suggestions?
Thanks, James
