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}))
Solved! Go to Solution.
The Answer is YES.
Modify your patch statement like this:
ForAll(colResults, Patch('Transfer Sheet & Product Availability', Defaults('Transfer Sheet & Product Availability'), {QuantityType:QuantityType,Bin:bin,QtyAvailable:QtyAvailable,Item:itemnmbr,'Lot No':lotnumbr}, FormXXXX.Updates))
The Answer is YES.
Modify your patch statement like this:
ForAll(colResults, Patch('Transfer Sheet & Product Availability', Defaults('Transfer Sheet & Product Availability'), {QuantityType:QuantityType,Bin:bin,QtyAvailable:QtyAvailable,Item:itemnmbr,'Lot No':lotnumbr}, FormXXXX.Updates))
Thank you so much!
Check out new user group experience and if you are a leader please create your group
Did you miss the call?? Check out the Power Apps Community Call here!
See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.
User | Count |
---|---|
252 | |
235 | |
82 | |
36 | |
27 |
User | Count |
---|---|
317 | |
265 | |
122 | |
68 | |
44 |