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
Solved! Go to Solution.
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 ,
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!
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
201 | |
71 | |
51 | |
49 | |
20 |
User | Count |
---|---|
261 | |
123 | |
85 | |
79 | |
72 |