Filter that shows all items

[TobiasSQA]

Hello.

I have an app where I'm filtering items based on a sharepoint choice column, this filtering is happening based on the selection of a dropdown, the dropdown takes items from the sharepoint list.

Any ideas on how I would add a selection to that dropdown that would then disable the filtering and just show all items.

Items are being shown on a map (Geospatial Feature), but in theory it should be the same as a gallery

Thanks in Advance 
TQA

[v-yujincui-msft · Accepted solution]

Hi @TobiasSQA ,

Do you want to show all items while using a Drop Down Control?
Maybe you might consider creating a collection and setting the Items property of the Drop Down Control to it.

I have made a test for your reference.

1. Here is my data source.

2. Select the Screen and apply the following formula on its OnVisible property as:

ClearCollect(collectionWithBlank,{Value:""}); Collect(collectionWithBlank,Choices(tmplist.status))

3. Select the Drop Down Control and set its items property to collectionWithBlank.

4. Select the Gallery and apply the following formula on its Items property as:

If(IsBlank(Dropdown2.Selected.Value),tmplist,Filter(tmplist,Dropdown2.Selected.Value=status.Value))

Result Screenshots:

Best Regards,
Charlie Choi

[TobiasSQA]

Hello Charlie 

Sorry for the late response, your solution worked flawlessly, thank you so much 🙏

Best Regards,
Tobias Andersen