cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Filtering a gallery by a column value as a default

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.

11 REPLIES 11

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

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.

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (25,367)