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
Solved! Go to 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
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
Hello Charlie
Sorry for the late response, your solution worked flawlessly, thank you so much 🙏
Best Regards,
Tobias Andersen
User | Count |
---|---|
256 | |
106 | |
86 | |
51 | |
43 |