Answered

Combobox in form goes blank after submitting form

(0) Share

Report

Posted on by lalford09

163

I have a form with multiple combo boxes in that all work fine, however there is one specific combobox called cmb_ikc_assignedP1 that keeps becoming blank when I change another item in the form and then press the submitform button.

I have tried multiple workarounds but with no luck, below is my current formulas for this combo.

DefaultSelectedItems - [Parent.Default]

Items - Filter(LOGSTABLE,
Parent_ID = var_Ref && Change_Type = "Approved" && (User_Role = "Audit Team" || User_Role = "Audit Director" || User_Role = "Audit Owner" || User_Role = "Audit Lead" || User_Role = "Other")).User_Email

Update of the card - cmb_ikc_assignedP1.Selected.User_Email

The reason that is the items for the combo is because it populates based on users in that table that are listed under this Reference (Parent_ID = var_Ref)

Any help would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

DJ_Jamba 2,837 Super User 2025 Season 2 on at

Like (0)

Report

Hi @lalford09

Is the combo box empty after you have submitted the form?
If so, what is the default mode of the form after you have submitted it (New, Edit, View)?

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on at

Like (0)

Report
HI @lalford09,

I guess the LOGSTABLE is noe the data source you populate the form Item property with, right? It is a new list that differs from the one of the Form.

Generally, it works in a new form, but not for an edit form because the way you set the default value is wrong.

You need to retrieve the value from the source you set for the Items property.

Set the DefaultSelectedItems property as:

LookUp(Filter(LOGSTABLE,Parent_ID = var_Ref && Change_Type = "Approved" && (User_Role = "Audit Team" || User_Role = "Audit Director" || User_Role = "Audit Owner" || User_Role = "Audit Lead" || User_Role = "Other")).User_Email,User_Email=ThisItem.assignedP1Column)

Was this reply helpful? Yes No
lalford09 163 on at

Like (0)

Report

@v-qiaqi-msft works perfectly, thank you

Was this reply helpful? Yes No
lalford09 163 on at

Like (0)

Report

Hi @v-qiaqi-msft

I was hoping you could help as I have just found a similar issue in the same form, but instead of a blank value returning, it is keeping the original value that was in the combo box instead of the new value:

Update of the status combo card: cmb_ikc1_statusp1.Selected.Value

Items: ["Pending Review", "Returned to Preparer", "Pending Approval"]

DefaultSelectedItems: [Parent.Default]

Thanks in advance.

Was this reply helpful? Yes No