Filtering a gallery by a column value as a default

[ChrisShelley]

Good Evening,

I have a gallery that I only want to display information on a record if a value in record is marked as "Yes", I have attempted modifying the filter already present in the record with DataCardname="Yes" but no luck.

[v-xida-msft · Accepted solution]

Hi @ChrisShelley ,

Could you please show more details about the error message? Do you face a Delegation warning issue within your formula?

If the "ReadyForCompounding" column is a "Yes/No" type column in your SP List, I think the formula above I provided could not produce an error. It would cause a Delegation warning issue within your Filter formula.

Please note that the Delegation warning issue is not an error, it just means that you could not delegate the data process to your SP List itself, instead, you could only process your data locally in your app. You could only process 2000 records at most locally in your app.

If the amount of your SP List records is not more than 2000, you could ignore this warning issue.

Note: Please set the "Data row limit for Non-delegable queries" option to maximum value -- 2000 within Advanced settings of App settings of your app.

If you want to get rid of this Delegation warning issue, as an fixed solution, you could consider change the data type of your  "ReadyForCompounding" column from "Yes/No" into Choice type (with two available options -- "Yes" and "No"). Then you could modify your Filter formula as below:

SortByColumns(
               Filter(
                      [@'Product Tracker'], 
                      ReadyForCompounding.Value = "Yes",    // Modify formula here
                      StartsWith(Title, TextSearchBox1_2.Text)
               ), 
               "Title", 
               If(SortDescending1, Descending, Ascending)
)

above formula would not cause Delegation warning issue.

Best regards,

[ChrisShelley]

The logic test of <> worked! It is a delegation error but it is behaving the way it should. Thank you so much for your help, especially at the late hour.