Answered

Online\Offline app - Filtering collection

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello

My app's database is SP list that contains Choices columns. The App has ability to work at Offline mode by pulling the relevant items to a collection.

My filter pane contains combo boxes for the choices column values.

I am failing to implement the mentioned CB for filtering the collection columns that pulled the information from the Choices column type.

Will appreciate your assistance.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

WarrenBelz 156,275 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

That is because the Choices() function only exists when looking directly at the SharePoint list - it is actually looking at the Field definition, not the Field content. A collection only contains the content. As you have "hard coded" the choices in SharePoint, do the same in the app (I do anyway - I do not use Choice columns unless storing multiple choices)

If( Connection.Connected, Choices(ListName.FieldName), ["Choice1","Choice2","Choice3"," . . . . "] )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz
I get your point. Looks like it still not working.
I do agree that it is always end up to be more convenient avoid using Choice columns.
For the online version I am using the following:
Or(
IsBlank(cb_Validation.SelectedItems),
IsEmpty(cb_Validation.SelectedItems),
Inspected.Value = Last(FirstN(cb_Validation.SelectedItems,1)).Value,
Inspected.Value = Last(FirstN(cb_Validation.SelectedItems,2)).Value,
Inspected.Value = Last(FirstN(cb_Validation.SelectedItems,3)).Value,
Inspected.Value = Last(FirstN(cb_Validation.SelectedItems,4)).Value )

Looks like it doesn't work for the collection.

Was this reply helpful? Yes No
Verified answer

WarrenBelz 156,275 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous ,

You do not actually need it if you are filtering a collection as the filter is processed "locally"

Filter( YourCollection, Or( Len(cb_Validation.Selected.Value) = 0, Inspected.Value in cb_Validation.SelectedItems ) )

You can also shorten your code a bit

Or( Len(cb_Validation.Selected.Value) = 0, Inspected.Value = First(cb_Validation.SelectedItems).Value, Inspected.Value = Index(cb_Validation.SelectedItems,2).Value, Inspected.Value = Index(cb_Validation.SelectedItems,3).Value, Inspected.Value = Index(cb_Validation.SelectedItems,4).Value )

I also have another approach in this blog of mine which can also be used directly on a list with Delegation only limited to the items returned on each of your item choices (it will work fine as long the total output is under this)

If( Len(cb_Validation.Selected.Value) = 0, YourCollection, Ungroup( ForAll( cb_Validation.SelectedItems As aSel, Filter( YourCollection, Inspected.Value = aSel.Value ) ), "Value" ) )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @WarrenBelz !

Works perfect

Was this reply helpful? Yes No