Hello All,
I have a page on my app that is two parts, one part is a form pulling from sharepoint list and the other is pulling from a SQL data connection. After users fill out the form and select their item (on check creates a collection), I want them to be able to submit the form data and the collection to a sharepoint list as one item. Right now the code I have on the submit button is only populating the data for the collection. Is there somewhere in my submit code that I can have the form data be updated on submit as well? Or does the checkbox need to trigger the form data to create a collection? Please let me know if I can explain further.
SUBMIT BUTTON: ForAll(colResults, Patch('Transfer Sheet & Product Availability', Defaults('Transfer Sheet & Product Availability'), {QuantityType:QuantityType,Bin:bin,QtyAvailable:QtyAvailable,Item:itemnmbr,'Lot No':lotnumbr}))
