Strange problem with a Combobox inside of a gallery

(0) Share

Report

Posted on by ellbi

Hi,

I have a gallery in which there is a combobox. It is connected to a choices column.

The Items property is set to Choices(ChoicesColumn) and the DefaultSelectedItems is set to ThisItem.ChoicesColumn

In OnChange, I have this function to update the change in the database: Patch(Table; ThisItem; {ChoicesColumn: Self.Selected.Value})

Now the two strange things:

1.) When I open this screen the first time, every item in the gallery has the correct value selected in the combobox. But this correct value is shown twice in the combobox:
Screenshot 2024-06-22 233243.png

2.) When I change for example the second gallery item combobox value, the first items combobox looses it's selected value.

Any ideas? Thanks

Categories:

Building Power Apps

All responses (4)

Answers (0)

Sort by

SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ellbi

The reason why yo see the correct value twice is because the data structure is different.

ThisItem.ChoicesColumn // this only produce a string as output Choices(ChoicesColumn) // this produce a record for each choice as a output

Can you try this and see if this the value is only showed one time:

{Value: ThisItem.ChoicesColumn}

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube| [My blog]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
ellbi 8 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @SpongYe,
thanks for your answer. I wrote something wrong because had set [ThisItem.ChoicesColumn] as DefaultSelectedItems, so a table and not a string.
Nevertheless I tried your solution and it looked good at first. But after restarting the app, now the Combobox list is empty:

Which is the next strange thing.
SpongYe 5,909 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ellbi

That would mean the Value is not the column name.

Please adjust Value to the column name to the column within you Choices dataset.

If you have any questions or feedback, please let me know. Have a great day! 😊

-----------------------
PowerYsa Power Platform Enthusiast [LinkedIn] | [Youtube| [My blog]

I love to share my knowledge and learn from others. If you find my posts helpful, please give them a thumbs up 👍 or mark them as a solution ✔️. You can also check out my [@PowerYSA] for some cool solutions and insights. Feel free to connect with me on any of the platforms above. Cheers! 🍻
ellbi 8 on at

Like
a
(0)

Report
Copy link

Link copied!

@SpongYe

I did not change anything on the Items property. It is still only this:
So there is a value column which is also selected as field in the combobox:

When I refresh the underlying database table, the comboboxes suddenly show the values when expanding.
But then the first item in the gallery looses it's selected value in the combobox. For me it looks like there are some bugs involved.

Even with another sample app I am able to reproduce a related problem. Just a simple table with a customer name and a OrderState choice column. When starting the app:

After changing the third combobox to "New", the first Item lost it's selected value:
The Patch function in OnChange of the combobox looks like this:
Patch(Orders; ThisItem; {OrderState: Self.Selected.Value}) and works fine.