Combobox not updating value when form in Edit mode

(2) Share

Report

Posted on by lg270492

133

Hi all,

Really getting frustrated with this issue so praying one of you clever people can help me :)

I have a PowerApps form where i have edited some datacards to use a combobox rather than the standard text input field. The comboxboxes are pulling data from other SP lists (not the list I patch too when submitting my form). The comboboxes are working fine when the form is in new mode, they send the selected record to my SP list but when I put the form in Edit mode to change something, it does not pull the previously submitted information from them comboboxes.

Really appreciate any help you can give on this!!

Thanks in advance!

Categories:

General Questions

All responses (4)

Answers (1)

lg270492 133 on at

Like (1)

Report

Combobox not updating value when form in Edit mode

You sir are a legend! Thank worked, thank you!!

Appreciate your support!!!!
Verified answer

GregBurden-Lowe 17 on at

Like (1)

Report

Combobox not updating value when form in Edit mode

Hello

not sure of the structure of your app but I've used something like this before...

You just need to make sure that the defaultselecteditems property is pointing to the right place.

You may need to play around with the formula but it's something like:

ComboBox A (Customer DB)

DefaultSelectedItems: If(BOZ_SHP.Mode = FormMode.Edit,Filter('Customer DB', CustName = ThisItem.CustName),Blank())

ComboBox B (Material DB)

DefaultSelectedItems: If(BOZ_SHP.Mode = FormMode.Edit,Filter('Material DB', MatDes = ThisItem.MatDes),Blank())

ComboBox C (Carrier DB)

DefaultSelectedItems: If(BOZ_SHP.Mode = FormMode.Edit,Filter('Carrier DB', CarrierName = ThisItem.CarrierName),Blank())

The If formula will just check if it's blank and if it isn't it should return the previously selected value.
lg270492 133 on at

Like (1)

Report
Combobox not updating value when form in Edit mode

Hi,

Thanks for your reply and i fully understand your point so apologies for not sharing more!

So... I have combobox A,B & C:

Combobox A Items = Customer DB (SP List): Column = CustName

Combobox B Items = Material DB (SP List): Column = MatDes

Combobox C Items = Carrier DB (SP List): Column = CarrierName

All 3 of the comboboxes are inside a form in powerapps which is connected to another SP List (Blackout Forms). When I submit the form, the data from the comboboxes is sent to the Blackout Forms SP List no problem, but when the form is in Edit mode, I cannot retrieve the previously submitted values.

An example of what I have tried on the combobox defaultselected items property:
If(BOZ_SHP.Mode = DisplayMode.Edit,Filter('Carrier Names','Vendor Name' = ThisItem.'Carrier Name'))
{'Vendor Name':ThisItem.'Carrier Name'}

Hoping this adds more context and you are able to give me some advice on how to make it work :)

Thanks in advance!!
Michael E. Gernaey 41,020 Super User 2025 Season 1 on at

Like (3)

Report

Combobox not updating value when form in Edit mode

Hi,

I don't mean to be rude, but everyone thinks they can just say words and share no images, no code, no nothing and we can solve it.

Share, share share

What do you mean its pulling from other lists? If you say it works in New, thatn that means it just loading itself up.

If you are in edit you have to put code IN the default property or defaultselecteditems properties to get it to show you the correct data.

Please share and show what you have.