How to get the selected value of a combo box that can have 2 types of items

(0) Share

Report

Posted on by johnjohnPter

1,809 Super User 2024 Season 1

I have a combobox representing Locations with this formula for the Items:-

If(
 IsBlank(DashBoardStreetComboBox_1.Selected),
 Sort(
 Distinct(
 colOptionsForChoices,
 'Location Name'
 ),
 ThisRecord.Value,
 SortOrder.Ascending
 ),

 Filter(
 Locations,
 StreetTitle = DashBoardStreetComboBox_1.Selected.Value
 ).Title
 )

in other word if the user does not select any street, to show all the Locations from the colOptionsForChoices collection, if the user select a street to only show the location related to the street.. the above formula is not raising any error. but when i tried to select the selected value for the Location combobox, i got this error:-

any advice

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (0)

MTNK 819 Super User 2025 Season 2 on at

Like (0)

Report

@johnjohnPter
As I understand, you would like to auto populate one item for a Combo box(with 2 items as drop down selection) based on other column selection.

Was this reply helpful? Yes No
johnjohnPter 1,809 Super User 2024 Season 1 on at

Like (0)

Report

@mtsts I want to select the selected Location item from the LocationCombobbox, this item can be from :-

1) colOptionsForChoices collection

2) OR from the Filter(Locations..)

so the value can be the Title of the sharepoint list item or the Value of the collection item... did u get my point?

Thanks

Was this reply helpful? Yes No
MTNK 819 Super User 2025 Season 2 on at

Like (0)

Report

@johnjohnPter I did not get it. Please do share the images for the columns with dropdown options. It would be easy for me to understand your question and help you.

Was this reply helpful? Yes No
johnjohnPter 1,809 Super User 2024 Season 1 on at

Like (0)

Report
@mtsts here are the Streets & Locations comboboxes, as follow:-

and here is how i am building the collection on the screen onvisible property,:-

//store the options to popualte the dropdowns based on the available data onky ClearCollect(colOptionsForChoices,Filter('Work Orders', ('Work Order Status'.Value = "Assigned" Or 'Work Order Status'.Value="New") And (Street = colSelectedStreetName Or IsBlank(colSelectedStreetName)) And (Direction = colSelectedDirectionName Or IsBlank(colSelectedDirectionName)) And ('Location Name' = colSelectedLocationName Or IsBlank(colSelectedLocationName)) And ('Work Order Type'.Value = colSelectedTypeName Or IsBlank(colSelectedTypeName)) And ('Technician Name'.Email = colSelectedTechnicianName Or IsBlank(colSelectedTechnicianName) Or 'Work Order Type'.Value ="Posting" Or 'Work Order Type'.Value ="UnPosting" Or 'Work Order Type'.Value ="Campaigns Photos" ) And (Brand = colSelectedBrandName Or IsBlank(colSelectedBrandName)) And ('Work Order Status'.Value = colSelectedTStatusName Or IsBlank(colSelectedTStatusName)) ));

is the case clear for you now?

thanks

Was this reply helpful? Yes No
MTNK 819 Super User 2025 Season 2 on at

Like (0)

Report

@johnjohnPter

Here is the another solution -

You can try this way to check -

It sounds like you want to select an item from a LocationCombobbox based on either the Title of a SharePoint list item or the Value of an item in the colOptionsForChoices collection.

Let’s break it down:

1.
Selecting from colOptionsForChoices Collection:
If you want to select an item from the colOptionsForChoices collection, you can directly use the Value property of the collection item. For example:

UpdateContext({ SelectedLocation: colOptionsForChoices.Selected.Value });

2. Selecting from Filtered Locations:
If you want to select an item from a filtered set of locations (e.g., using Filter(Locations, ...)), you’ll need to specify the condition for filtering. Assuming you have a filter condition (let’s call it LocationFilter), you can do something like this:
UpdateContext({ SelectedLocation: First(Filter(Locations, LocationFilter)).Title });

Remember to adjust the variable names (SelectedLocation, colOptionsForChoices, Locations, etc.) according to your app’s context.

Let me know if you need further assistance!

Was this reply helpful? Yes No
MTNK 819 Super User 2025 Season 2 on at

Like (0)

Report

@johnjohnPter

Here is the another solution -

You can try this way to check -

It sounds like you want to select an item from a LocationCombobbox based on either the Title of a SharePoint list item or the Value of an item in the colOptionsForChoices collection.

Let’s break it down:

1.
Selecting from colOptionsForChoices Collection:
If you want to select an item from the colOptionsForChoices collection, you can directly use the Value property of the collection item. For example:

UpdateContext({ SelectedLocation: colOptionsForChoices.Selected.Value });

2. Selecting from Filtered Locations:
If you want to select an item from a filtered set of locations (e.g., using Filter(Locations, ...)), you’ll need to specify the condition for filtering. Assuming you have a filter condition (let’s call it LocationFilter), you can do something like this:
UpdateContext({ SelectedLocation: First(Filter(Locations, LocationFilter)).Title });

Remember to adjust the variable names (SelectedLocation, colOptionsForChoices, Locations, etc.) according to your app’s context.

Let me know if you need further assistance!

Was this reply helpful? Yes No
johnjohnPter 1,809 Super User 2024 Season 1 on at

Like (0)

Report

@mtsts sorry but what is the relation between my question and your final answer??

Was this reply helpful? Yes No
MTNK 819 Super User 2025 Season 2 on at

Like (0)

Report

@johnjohnPter I am trying to help you. If it does not work for your question, you can try another solution.

Was this reply helpful? Yes No
johnjohnPter 1,809 Super User 2024 Season 1 on at

Like (0)

Report

@mtsts i think you did not get what i need, this formula does not seems to work:-

colOptionsForChoices.Selected.Value

as colOptionsForChoices is a collection and not a Combobox control!

Was this reply helpful? Yes No