Showing results for 
Search instead for 
Did you mean: 
Level: Powered On

Looking for the most efficient way to create/save new record

Data is housed in an on-prem SQL db.  Each record (in Table1) has over 250 fields that are all required.  I believe a collection is the correct route for saving records (using the collect method).  What's the best way to create a record, without having to hard code all 250+ data fields?


Level 10

Re: Looking for the most efficient way to create/save new record

I know in Sharepoint I just do ClearCollect(Alldata,datasource)  this returns all data in the list plus all columns.  Some things to think about though.


1.  I think there is a Column limit that can be returned.  Not sure how many but I think 250 may not be in that.

2. Collections atre non delegable so you may have issues with how much data you want to return.  Max would be 2000 records. 



Level 8

Re: Looking for the most efficient way to create/save new record



Have you ever used Edit Form?  Edit Form may be the best ways to create records without having to hard code all 250 fields. Do you think it works well for you?

Patch function and Collect function are also good ways, and Collect is better in performance. Though you need to add Textinput box manually to pass values to Data source.


You can create a Edit Form, and use SubmitForm function to create a record.

  1. Create a Edit Form
  2. Choose edit fields, and set Default Mode as New
  3. Create a submit button, set Onselect property as below.
SubmitForm(Form1); NewForm(Form1)

Annotation 2019-09-02 124312.png

You also can use Patch/Collect function and Textinput boxes to create new record as below,  which is a little more complicated, though, because you might need to create a lots of boxes manually.

Patch(Date Source,  Defaults(Data Source), {Field1: Textinput1.Text, Field2: Textinput2.Text, … })
Collect(Data Source, {Field1: Textinput1.Text, Field2: Textinput2.Text, … })

Best regards,


Helpful resources


PowerApps Monthly Community Call!

Join us next Wednesday for our Demo Extravaganza, October 16, 2019 8am PDT.


Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.


Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020


Power Platform World Tour

Coming to a city near you


PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!


Join PowerApps User Group!!

Connect, share, and learn with your peers year-round


Power Platform Summit North America

Register by September 5 to save $200

Top Kudoed Authors
Users Online
Currently online: 180 members 5,424 guests
Recent signins:
Please welcome our newest community members: