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.
Solved! Go to 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.
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.
Check out our new profile badges recognizing authored solutions!
We are excited to announce the Power Apps Super Users!
Did you miss the call? Check out the Power Apps Community Call here.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!