Hi hope someone can help.
I have a created a collection that stores data selected from a drop down list and then puts it into a gallery. However, i also need this collection to take the data from the text field next to it as well.
i.e. Drop down has a list of products and the text box to the side is where the quantity is entered.
The line is added to the collection when the user presses a + button. How can i get the quantity for that product added to the collection as well
The drop down is populated from one sharepoint list and the other connected to another sharepoint list (SharePointList2)
Below is how ive set the collection up so far:
OnStart:
ClearCollect(MyCollection, SharePointList1);
ClearCollect(DsiplayMyCollection,AddColumns(MyCollection,UniqueColumn, Code & " | " & IdentificationNo & " | " & Qty & " | " & BinName & " | "));
OnClick: (The commented out section here i tried to link it, but it was throwing errors with "Code" about it not being recognised)
If(
IsBlank(LookUp(SelectedItemsCollection, Code = Dropdown1_1.Selected.Code)),
Collect(SelectedItemsCollection,Dropdown1_1.Selected)
//Collect(SelectedItemsCollection,{DropdownData:Dropdown1_1.Selected, Qauntity: DataCardValue18.Text})
);
Gallery - Items:
SelectedItemsCollection
Gallery - Value:
UniqueColumn