in canvas app gallery , how to filter on Status

[biconix1]

I don't know why I am struggling so much on this....

In my gallery I want to show only records whose status is active. I have tried 

Filter('Students', statecode = 0) and Filter('Students', Status = "Active")

I get an Error: Incompatible types for comparison. These types can't be compared. OptionSetValue(Status(Students)), Number) 

We can't evaluate your formula because the values being compared i the formula aren't the same type

How does one filter on Active records?

[Drrickryp]

@biconix1 

Filter(
       Students,
       If(
          Dropdown1.Selected.Value = "Active",
          'Field Status' = [@'Field Status'].Active,
          Dropdown1.Selected.Value = "Inactive",
          'Field Status' = [@'Field Status'].Inactive
       )
)

[Jenisha_Dhas]

Hi @biconix1,

In PowerApps, to show only active records in gallery you can use the Search function in combination with the Filter function.

1. Select the gallery control
2. Go to the Items property
3. Enter the following formula: Filter(Search(DataSourceName, "Active", ColumnName), ColumnName = "Active")

Replace "DataSourceName" with the actual name of your data source, and "ColumnName" with the actual name of the column that contains the status of the record (e.g. Active/Inactive).

This formula first performs a search on the data source for records where the value in the specified column contains the string "Active". The resulting set of records is then filtered again to only show records where the value in the column is equal to "Active".

This is an alternate way to show only active records in a PowerApps gallery, and you can use either the Filter function or the Filter and Search functions combination, depending on your specific requirements.

[biconix1]

i need to clarify that I am using a Dataverse table such that the Status field is a choice field where the labels and values are Active,0 and Inactive, 1

I think I found the answer. the Status value should be Text(Status) = "Active"

[Craig_Cowley]

Hi @biconix1 

Not sure if it's what you want to do, I followed a this video by @RezaDorrani 

(14) PowerApps Multiple Filters on Gallery - YouTube

Craig

[Ethan_R]

Hi @biconix1 ,

You can try the following:

//Using Field value
Filter(
     Students,
     Status = 'Status (Students)'.Active
)


//Using Dataverse Table System Views - assuming 'Active Students' as View name
Filter(
     Students,
     'Students (Views)'.'Active Students'
)

Hope this helps

[biconix1 · Accepted solution]

i resolved this by using this statement: Text(Status) = "Active"