Is it possible to:
1 make a collection from an edit form and
2 save the collection as a new record in a table (Excel) which is separate from the form's datasource?
Thanks in advance
Solved! Go to Solution.
Thanks for your reply.
I have a form pulling data from a gallery (Gallery1.Selected). The datasource of the gallery is an Excel Table1.
The form has 5 datacards from the Gallery with text inputs.
I am trying to make a collection from the 5 datacard inputs so that I can save them to a new Excel Table2 as separate rows, (instead of submitting the form to the original datasource).
I hope this makes sense!!
I'm sorry your solution doesn't work for me. The form datasource is not the same as gallery1. I'm trying to collect and patch the form data to a new datasource (not the gallery1 datasource).
Check out new user group experience and if you are a leader please create your group
Check out how to claim yours today!
We are excited to announce that Demo Extravaganza for 2021 has started!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks