Combo box glitch when embed PowerApps in PowerBI

(1) Share

Report

Posted on by CU11091434-0

Hi there,

I developed a PowerApps using Gallery to create editable grid. However, most of the time the combo box did not load the default value which is extremly frustrating.

In Power Apps Studio when I clicked Play, this is the initial loading of the records:

When the PowerApps is embedded in PowerBI, most of the time the initial load returns blank for these two combo box for some really strange reason.

If anyone encounter similar behaviour, please let me know how to handle this!

Thanks!

Categories:

General Questions

All responses (1)

Answers (0)

Suggested answer

Ammar Zaied 97 on at

Like (0)

Report
Combo box glitch when embed PowerApps in PowerBI

Hi, can try with the different approachs:

Make sure the DefaultSelectedItems property of the ComboBox is set correctly. It should match the items in the ComboBox, particularly when you are working with complex types (like records).

The Items property of the ComboBox should be bound to the correct data source, and the field being selected should match the values used in DefaultSelectedItems. If there's any mismatch in data types or format, the ComboBox will not populate the default value.

Ensure that the data type of the field used in DefaultSelectedItems matches the data type in the Items property of the ComboBox. Mismatches (e.g., a string in one place and an integer in another) can prevent the ComboBox from displaying the default value.

Sometimes, the ComboBox may not pick up the latest values from the data source, especially if the data is changing frequently. You can add a Refresh() function on form load or before the ComboBox is displayed:

Preloading the data using Collect() or ClearCollect() into a local collection and then binding the ComboBox to that collection might solve the issue if it’s related to loading speed.