cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lana
Helper II
Helper II

Combo box in Edit Form

I am working on SharePoint list called Quality list where users select Supplier_Name from a combo box which automatically sets Supplier Code and some other fields. The source for my ComboBox1 is another SharePoint list(SupplierList) which has more than 500 items, so my formulas are as follows.

 

Name:ComboBox1

Items: Filter(SupplierList, StartsWith(Title,Combobox1.SearchText)

SearchFields:["Title"]

DefaultSelectedItems: First([LookUp(QualityList,ID=SharePointIntegration.SelectedListItemID,'Supplier_Name')]))

 

Based on the selection in ComboBox1, I am setting Supplier_Code=ComboBox1.Selected.Supplier_Code in the Default Value property.

 

This works fine in the new form. Now in the edit form, how can I set the DefaultValue property for Supplier_Code to Parent.Default & change it to ComboBox1.Selected.Supplier_code when a user changes the value in ComboBox1.

 

Thanks in advance

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
WarrenBelz
Super User
Super User

Hi @Lana ,

Something like this should do the job

If(
   !IsBlank(ComboBox1.Selected.Supplier_Code),
   ComboBox1.Selected.Supplier_Code,
   Parent.Default
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

View solution in original post

3 REPLIES 3
WarrenBelz
Super User
Super User

Hi @Lana ,

Something like this should do the job

If(
   !IsBlank(ComboBox1.Selected.Supplier_Code),
   ComboBox1.Selected.Supplier_Code,
   Parent.Default
)

 

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Hi @Lana ,

Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Hello Warren,

 

Sorry I was able to try only today and it worked.

 

Thank you for your help!

 

 

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (4,397)