You’re offline. This is a read only version of the page.
Announcements
I am having a strange filtering issue.
I need to filter my gallery on a choice field where the value does NOT equal "Completed".
Currently in the list there are items with 1 of 4 statuses (Completed, New, Rejected and Redirected).
If I set the gallery to Filter(finticket, Status.value <> "Completed") it only returns the items with the status 'Rejected', but does not return the items with status of 'New' or 'Redirected'.
If I specifically set the status to return the New or Redirected items it works fine. I cannot figure out why it's not returning the New and Redirected items using the Not equal filter. It does the same thing if I do a ClearCollect to bring the items into a collection.
Use:
Filter(finticket, Status.value = "Rejected" || Status.value="New" || Status.value="Redirected")
The <> is not delegable to Sharepoint and that why the results might seems strange.
Hope it helps !
Share
Report
5,836
All responses (
Answers (
