I have two screens.
The first screen is a combobox. The user selects what they want from the combobox and clicks a button to continue onto the second screen.
The second screen is filtered down by whatever was selected in the combobox from screen one.
Is there any select all functionality in the combobox as sometimes the user does not want to filter?
What formula is on the second combobox2?
You can try:
If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.
Based on the issue that you mentioned, do you want to filter the gallery based on the selected items from Combo Box?
Could you please share more about your scenario, is a SharePoint list Choice column? How many options could you select in the ComboBox, One or more options?
Combine that with your description, you want to display all the items if there is a select all option. I think that If function can achieve your needs.
I have a test on my side, please take a try as below.
When you select “All”, the gallery will display all the items which are like unfiltered.
Note: I have a SP list named ‘EventType’ containing a Choice column named ‘Event’ as my data source.
Thanks for your suggestions. Unfortunately @v-qiaqi-msft , the sharepoint column is a text field rather than a choice column.
The first screen on visible is:
ClearCollect( NewCollection10, Sort( Distinct( Filter( SPlist, Created >= Today() ), Manager ), Result, Ascending ) )
The combobox on screen 1 is then equal to collection10.
The final bit on screen 1 is the button to advance to the next screen also has this line of code to set the variable
On the second screen I have a second combobox and a gallery.
If( CountRows(ComboBox2.SelectedItems) < 1, SortByColumns( Filter( SPList, Created >= Today(), Manager in MySalesManager ), "CustomerAccount", Ascending, "SAPOrderNumber", Ascending ), SortByColumns( Filter( SPList, Created >= Today(), Manager in MySalesManager, OrderNumber in ComboBox2.SelectedItems.Result ), "CustomerAccount", Ascending, "SAPOrderNumber", Ascending )
Still scratching my noggin with this one