ComboBox - Content dependant on Edit\View DisplayMode value.

(0) Share

Report

Posted on by DarkStranger

I have a ComboBox in a gallery with the below parameters...

DisplayMode: If(ThisItem.ID=EditRecord,DisplayMode.Edit, DisplayMode.View)

ITEM: ["Desktop PC", "Evoko", "Printer"]

Currently, if the ComboBox is set to "Edit", the user can select from one of the predefined items and then the user can patch that item to a SP List. If the ComboBox is set to "View", i want it to display the "ThisItem.EquipmentType" value found in the SP List. I tried changing the "Default" to "ThisItem.SIB85_Device_Type", similar to the labels found in the same gallery, but this doesnt work and gives the error...

Expected Record Value... It was expecting a record, but the rule produces text values.

How can I get the ComboBox to display the SP List ThisItem value is the display mode is "View" and the "Items" values if the display mode is "Edit".

I hope that makes sense & thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@DarkStranger

Change your control from a combobox to a dropdown. A combobox brings only two things to the table - 1. the ability to search and 2. the ability to multi-select. Based on your information, I am not seeing a need for either.

A combobox is more complex than a dropdown in that, first of all, the Default property does nothing! You have to use the DefaultSelectedItems property to set a default...and you must set it to a record that matches the Items property.

If you change your control to a dropdown, you will go much further.

BUT...if you persist with the combobox, then you need to set the DefaultSelectedItems property to:

{Value: ThisItem.SIB85_Device_Type}

You'll notice this is a record with a Value column...because, your Items property of the Combobox produces a table with a single column called Value...so the record will match.

I hope this is helpful for you.

Was this reply helpful? Yes No
DarkStranger 88 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for replying. I have been testing with both the "ComboBox" & "DropDown" and found the below...

ComboBox: I had tried "{value: ThisItem.SIB85_Device_Type}" for "DefaultSelectedItems" and although showing in the SP List, it doesnt show in the "ComboBox", nor shows an error.

DropDown: If i put "["Desktop PC", "Evoko", "Printer"]" in the "Items", it puts "Desktop" in every gallery row... although by adding "ThisItem.SIB85_Device_Type" to the "Default" parameter it does show the SP List entry. I could add "["", "Desktop PC", "Evoko"] before desktop to fix the issue, but curious as to why the 1st entry of the items list is populated to every gallery row.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

@DarkStranger

If you are dealing with blank entries in your underlying records, then do the following (with the Dropdown):

Change the AllowEmptySelection property to true.

This will allow your dropdown to show blank if the underlying record has a blank in it.

If you don't set that property, then the dropdown will automatically select the first item in the Items property records.

Was this reply helpful? Yes No
DarkStranger 88 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks,

Was this reply helpful? Yes No