Answered

Combobox reset issue

(0) Share

Report

Posted on by Jayant_2203

Hi All,

I have a combo box which is in the form and the form is connected to SharePoint data source. We have a code on On Select property of combo box and it fetches data from share point list. Below is the code.

Set(initiatedata,Last(Filter(AssessmentMaster,Self.Selected.Value = PG.Value && Country.Value = Label12.Text && Year =DataCardValue11.Text )));

When select value is combo box and if the Value fetches data from share point data source it is working fine but if there is no value from share point data source it gets reset and no value is selected in combo box. Below is the gif that shows the issue.
How can i solve this?

Categories:

Building Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

proxyprochy 92 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello.

Check the PG ComboBox's Default value. It looks like it always gets the last record of your Sharepoint List, which doesn't seem to be found - so it just inserts blank.

DIY soulution for this might be setting the last checked item to be default;

PG_ComboBox.OnChange = UpdateContext({lastSelectedValue: PG_ComboBox.Selected.Value})
and
PG_ComboBox.DefaultSelectedItems = lastSelectedValue
v-albai-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Jayant_2203 ,

What's the Items property of your form? Do you want to show a blank form(Defaults(listname)) or show one of the other records when selected value is not found in your list?

Besides, what's the DefaultSelectedItems property of your combo box?

Best regards,

Allen