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
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.