to create two different views of the same issue tracking list based on the “Status” column. You can certainly achieve this using SharePoint and Power Apps. Working List (Active Issues): Create a SharePoint list (e.g., “Issue Tracking”) based on the out-of-the-box SharePoint app template for issue tracking. Add sample issue items to the list, ensuring that some are marked as “Active” and others as “Closed.” Share the list with the relevant users (e.g., Kenny Smith). In Power Apps, select Integrate -> Power Apps -> Create an app from the list page. Inside the app studio, you’ll see all the issues listed. To filter and show only active issues, update the formula for the default Items property of the items gallery (usually named BrowseGallery1): SortByColumns( Filter('Issue Tracking', 'Issue Status'.Value = "Active", StartsWith(Title, TextSearchBox1.Text)), "Title", If(SortDescending1, Descending, Ascending) ) This formula filters the list items based on the “Issue Status” column, showing only those with a status of “Active.” Closed Issues List: Create another page or view in SharePoint (e.g., “Closed Issues”). On this page, display the same “Issue Tracking” list, but this time filter it to show only items where the “Status” column is “Complete” or “Closed.” You can achieve this by customizing the view settings in SharePoint directly. By following these steps, you’ll have two separate views of the same issue tracking list: one showing active issues and the other showing closed issues. Users can easily navigate between these views based on their needs.
