I have a choice column in sharepoint list named "status" and the options are active, pending, completed. I want the gallery to only show active and pending. I can get it to come up with Filter ('SP Job Request',Status.Value="Active") but need to show active and/or pending. Can you please assist?
Thank you, works a treat 🙂
Try the following
Filter ('SP Job Request',Status.Value="Active" || Status.Value="Pending")
Or since there are only three possible values
Filter ('SP Job Request',Status.Value<>"Completed")