I have sharepoint list called Job requests. There is a field in their which is called Status with outcomes:
Pending
Delivering
Completed.
I have a gallery which i use the following on to display Pending jobs, but now need to display Delivering Jobs too
SortByColumns(Filter('Job Request',Status.Value ="Pending"),"Created",SortOrder.Ascending)

Plus their is a dropdown, at the end which only appears if users has created job, which allows them to change the status. Which it does but defaults to Pending which timer ends