Skip to content
English - United Kingdom
Contact Us
  • There are no suggestions because the search field is empty.

How do I configure the ChangePilot App's default status filter to exclude Closed and Auto-closed items?

It is possible to configure the ChangePilot App (Power App) to always open not displaying items that are either Closed or Auto-closed. This is done by editing the Power App coding.

By default, the ChangePilot App (Power App) is configured to display all items, regardless of status. Users may decide to amend this default setting to open the App displaying items with 'non-closed' status.

Pre-filter out 'Closed' and 'Auto-closed' items in the ChangePilot App

  1. Navigate to https://make.powerapps.com and locate your ChangePilot PowerApp. Click the edit button.
  2.  Enter RecordsGallery in the search bar. Select records gallery:

  3. Ensure ‘Items’ is selected from the first dropdown menu then expand the right dropdown using the arrow to the far right.

  4.  Overwrite the text in that box with the text below:

    Sort(

        Filter(

            ChangeTracker,

            !(StartsWith(Status.Value, "Closed") || StartsWith(Status.Value, "Auto"))

            && (Status.Value in Status_Combo1.SelectedItems.Value || Status_Combo1.Selected.Value=Blank())

            && ('Service Category'.Value in SC_Combo1.SelectedItems.Value || SC_Combo1.Selected.Value=Blank())

            && (Tags_Combo.Selected.Value=Blank() || (CountRows(Filter(Tags.Value, Value in Tags_Combo.SelectedItems.Value)) > 0))

            && ('User Impact'.Value = User_Combo1.Selected.Value || User_Combo1.Selected.Value=Blank())

            && ('Admin Impact'.Value = Admin_Combo1.Selected.Value || Admin_Combo1.Selected.Value=Blank())

            && (Category.Value = Category_Combo.Selected.Value || Category_Combo.Selected.Value=Blank())

            && (SearchInput1.Text in 'Title (mctitle)' || SearchInput1.Text in MCID || SearchInput1.Text = Blank())

            && ('Standard Start' <= Today() + Dropdown1.Selected.Value)

            && (ExcludeItems <> 1 || ('Standard Start' > Today() && !IsBlank('Standard Start')))

        ),

        MCID,

        SortOrder.Descending

    )

  5. Then press the ‘Publish’ button, then ‘Publish this version’ to save and update the app for your users.