I am creating a power app to process our inventory and customer orders.
My SharePoint list for products far exceeds what PowerApps will call, so I created a collection called AllProducts that runs upon launch.
Dropdown input fields don't return enough results, so I need to use a combo box (multiselect is disabled). The combo box is used on the product name and I need the SKU and UOM to autopopulate in the form from the collection.
I've tried to use variables and a collection to get the respective data, but I'm not getting the right syntax. What do I use to set the default property for those fields?
Hi @crystalhowat ,
From your screenshot, SKU seems to be a TextInput control. To set the default property of this control based on ProductName combobox selected item you can use:
For UOM, which seems to be a comboBox control, I need to see the Items property to tell you what to do.
A combobox selects an entire record. All of the fields in that record should available simply by referencing it.
Yes, I missed that part that the data came from the same collection. I still have my doubts about UOM, I don't know why but I think that is a choice / lookup column in sharepoint and the data came as records. Hope I'm wrong !
I think I changed the field of UOM to a combo box just to see if that would change it. It is a record and it doesn't like the LookUp formula that did work for SKU. That was a text record. Any ideas how to get that one to work?
Okay, I'm silly and I figured out that I just needed to reference the UOM as UOM.Value and the error went away.
But, once I make a change to that combo box, nothing appears. It only references the first item in the collection. I appear to be stuck once again. Please help!!!
I am not adverse to setting up a video conference if anyone out there is interested in helping me figure this out. I'm normally very good at tinkering until I get it to work.
I tried putting the lookup for the SKU in the OnChange and OnSelect properties as a variable setting and it worked and the UOM also updated even though I didn't make any changes there. But it only worked once and then I don't know what happened (facepalm).........
Check out the News & Announcements to learn more.
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Check out our new Discover Your Career Path blog post series and get all the details.