Unanswered

Refresh of the view used for Combo box is not working

(0) Share

Report

Posted on by ssg_fc

There is a combo box within my Power App and the data source is a Azure SQL DB view. The view has 5 values (1 value is recently added). But the combo box is not displaying the newly added value in the list drop down. Only 4 values are displayed.

Any insights on this refresh issue or why the new value is not displayed? I appreciate your inputs.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

HenWang Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ssg_fc ,

What is the code inside Items property of your combobox control?

If possible, you can try refresh your AZ SQL db data source or even re-add the data source to see whether the new value can show up. Below is the way to refresh the data source:

Best Regards,
Hen Wang

Was this reply helpful? Yes No
ssg_fc 24 on at

Like
a
(1)

Report
Copy link

Link copied!

@HenWang Yes I manually refreshed the view connection but it did not pull the new record. This is what I see in defaultselecteditems property -

First(Filter('[DB_View].[Employee List]',CustCol_13 = ThisItem.RATE_CODE_ID0 ))

Was this reply helpful? Yes No
HenWang Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @ssg_fc ，

Thanks for the info. And the defaultSelectedItems might not help on the value to show in the drop down list. You need to check the Items property like below snap:

As you can see, the formula inside the Items property returns a table with three rows actually. You can check it from your side as well. I just doubt the formula used here is not referring to the complete value in your data source.

And I can see that your DefaultSelectedItems's formula is actually referring to first record of the records whose RATE_CODE_ID0's value is equal to CustCol_13, maybe this record has value among your 4 values above, but this is not the formula which makes this combobox to display the whole 5 values in drop down list.

Best Regards,
Hen Wang

Was this reply helpful? Yes No
ssg_fc 24 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @HenWang - I see the view name under the items property.

Was this reply helpful? Yes No