Hi I have created a SharePoint list of our permits and I want to use a power app to present the status of these to show our bosses. I have created a simple gallery from the list, however, I only want it to show open permits and not ones completed or unstarted.
Currently, the formula reads as" Filter('Permit Tracker'.Status."Open") " where the list is called Permit Tracker and I want to filter based on the "Open" choice in the "Status" column. Any help would be appreciated.