Hi @mmxupp ok so firstly could you send me a screen shot of the combo box with the values assigned to it? It would also be useful for me to be able to see the error message that it is giving you on the collect for your combo box table.
Secondly I wouldn't structure the Filter like you have I would do something like the following(My example is a movie SP list with a combo box as the genre types):
SortByColumns(
If(
ComboBox1.Selected.Genre = "All Items",
Movies,
Filter(
Movies,
ComboBox1.Selected.Genre in Genre.Value
)
),
"Title",
SortOrder.Ascending
)
So in your Case it would be:
SortByColumns(
If(
Raised_com_1.Selected.Result= "-SELECT ALL-",
[@Sharepoint],
Filter(
[@Sharepoint],
Raised_com_1.Selected.Result in 'Raised by'.Value
)
),
"No_x002e_",
SortOrder.Descending
)
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. Remember, you can accept more than one post as a solution. If the content was useful in other ways, please consider giving it Thumbs Up.
Thanks
Andrew