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).
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Check out the Power Apps Community Call for January 2021
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!