Answered

warning the columns produced by this rule are all nested tables and or records, however the property expects at least some columns or simple values.

(0) Share

Report

Posted on by MatthewLeslie

I am trying to use an If statement to view if a check box is ticked, if it is display all vehicles. If it is not checked only display vehicles that meet the criteria in the filter. However I keep getting the error listed in the subject line.

Haha never thought id be the one making a post here but any help would be greatly appreciated. Thanks in advance.

Function:

If(Checkbox1.Value = true, Vehicles.VehicleNumber, Distinct(Filter(Vehicles, LocKey = DataCardValue11.SelectedText.Result || LocKey = 60000184 || LocKey = 60000205 || LocKey = 50000502 || LocKey = 60000688 || LocKey = 60000690 || LocKey = 60000691 || LocKey = 60000693 || LocKey = 60000705 || LocKey = 50000199 || LocKey = 50000199 || LocKey = 60000177), VehicleNumber))

Categories:

Building Power Apps

All responses (9)

Answers (1)

Sort by

timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MatthewLeslie

Just to confirm, is this the formula that you're using for the Items property of a gallery control?

I suspect that this might solve the issue. Specifically, if the Checkbox is true and you just want to display the VehicleNumber column from Vehicles, the ShowColumns function will do this.

If(Checkbox1.Value = true, ShowColumns(Vehicles, "VehicleNumber"), Distinct(Filter(Vehicles, LocKey = DataCardValue11.SelectedText.Result || LocKey = 60000184 || LocKey = 60000205 || LocKey = 50000502 || LocKey = 60000688 || LocKey = 60000690 || LocKey = 60000691 || LocKey = 60000693 || LocKey = 60000705 || LocKey = 50000199 || LocKey = 50000199 || LocKey = 60000177), VehicleNumber) )

Hope that helps.
MatthewLeslie 55 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @timl

To confirm with you, yes it is in the Items property of a drop drown.

Thank you so much for your attempt, however I am still receiving the error highlighted in the subject line 😞
I've tried numerous things this afternoon but am short of luck.
See attached a screen shot showing the Blue lines, if i had to hover over them the error in the subject line would show.

If you have any other ideas they'd be much appreciated .

kind regards,
MatthewLeslie
timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @MatthewLeslie

The blue lines indicate that the search expression is non delegable. If your source data contains fewer than 2000 records, this will not be an issue.

To diagnose this, could you add a label to your screen and set the text property to this:

DataCardValue11.SelectedText.Result

Does the label show the selected text that you expect? If not, I would maybe try DataCardValue11.Selected.Result
MatthewLeslie 55 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello again @timl

Yes the label does show the text I would expect. If I had to Run the filter only in the Item property without the If statement it works perfectly populating the drop down but as soon as I want to include the check box and if statement the blue lines appear.
Also if I change the Distinct to Sort it also works however this does not meet the performance I need the function to run with.
Also if I Tick the checkbox making the statement true, it works perfectly, Its just when I'm using the else section of the IF

How could I make the expression delegable and still reach my goal ?

Extremely appreciate your fast replies.

Please see attatched
timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks for the extra details

Taking this one step at a time, if you use just the 'else' part of the formula in the dropdown, what result do you see?

Distinct(Filter(Vehicles, LocKey = DataCardValue11.SelectedText.Result || LocKey = 60000184 || LocKey = 60000205 || LocKey = 50000502 || LocKey = 60000688 || LocKey = 60000690 || LocKey = 60000691 || LocKey = 60000693 || LocKey = 60000705 || LocKey = 50000199 || LocKey = 50000199 || LocKey = 60000177)

When you say that it doesn't work, do you mean that it's returning an error, or is it not returning the rows that you expect?
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
HI @MatthewLeslie,

Could you please share a bit more about the error message within your app?

I have made a test on my side, please consider take a try with the following workaround:

If( Checkbox1.Value = true, Distinct(Vehicles, VehicleNumber), Distinct( Filter( Vehicles, LocKey = DataCardValue11.SelectedText.Result || LocKey in [60000184, 60000205, 50000502, 60000688, 60000690, 60000691, 60000693, 60000705, 50000199, 50000199, 60000177] ), VehicleNumber ) )

Please consider take a try with above solution, then check if the issue is solved.

Best regards,
MatthewLeslie 55 on at

Like
a
(0)

Report
Copy link

Link copied!

@v-xida-msft Thanks a lot for your help man. Really appreciate it, your work around seems to have fixed the problem.

Enjoy your Day.

Kind regards,
MatthewLeslie
MatthewLeslie 55 on at

Like
a
(0)

Report
Copy link

Link copied!

I am now seeing the values i expect both when the checkbox is ticked and when its not so thanks. However I do get a delegation warning, should i worry ?
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @MatthewLeslie ,

Firstly, the Delegation warning issue is not an error, it just means that you could not delegate the data process to your data source, instead, you could only process data locally in your app.

In default, you could only process 500 records at most locally, you could change this limit, then you could process 2000 records at most locally.

If the amount of your data source records is not more than 2000, you could ignore this warning issue. If the amount of your data source records is more than 2000, you could consider bulk-load your data source records into a collections in your app, then use the collection data source in your app.

Please check and see if the following solution would help in your scenario:

https://powerusers.microsoft.com/t5/General-Discussion/Pulling-in-large-ish-SQL-tables/m-p/243777#M71518

https://powerusers.microsoft.com/t5/Building-Power-Apps-Formerly/Sort-gallery-with-multiple-fields/td-p/379730

Best regards,