I receive a blank value when I use the syntax "Combobox.Selected.Result" but it starts working as expected after I choose another selection.
Many thanks.
Hi @mmxupp you can set the DefaultSelectedItems Property to something like the following:
My Table is as follows:
Your code would look something like (to get the first record in your table):
First(CollectVideoName)
Or if you prefer to use filter this also will work:
Filter(CollectVideoName,Name= "YourDefaultSelectedName")
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
@AndrewR1 It doesn't error.
Example
1. default
2. when I select
I want to get value by default not select.
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
Hi @mmxupp can you send a screen shot of your table structure and the Items code of your gallery?
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
I am using the table structure Combo box.
I have set the default selection in Combo box, and it works to show default selection, but I want it to provide value to filter in gallery, yet it's currently returning a blank value.
I tried to using dropdown, and it works, but it lacks a search feature that I need.
Hi @mmxupp can you share some more information around this for me please I would need to know what the combo box table structure your using?
Could you please elaborate with some more details about your use case?
The only way that I could replicate this is if my combo box items table looked like the following:
and then when I selected Andrew as there is no result for Andrew this will not show anything until I select MMXUP
Also out of interest is multi selection on?
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
Hello @mmxupp
Try to use Combobox.Selected.Value
Also, please share the Items property of your combobox if the above doesn't work.