Create a record in Dataverse table using canvas screen data

[Bayan]

Hi Everyone 

Below values are added by me to canvas screen and doesn't belong to any table in dataverse (its not also a form). I need to store this data upon button click in a a table I have already created called "Orders" and it contains columns: ID, Total Price, Address, Note and No cutlery.

So is there any function can be used to take this data, create a new record in that table and store the data in based on customized mapping between the labels and columns ? 

Thanks in advance

[kanchankolekar]

Hello @Bayan 

You can create a new record in the table by using Patch() and SubmitForm(). If you are using form then you can use a SubmitForm(FormName) to store records in the table. On another hand, if you are using different controls to add a value to the table you can use Patch(Orders, Default(Orders),{ID: Textinput.Text, TotalPrice: Textinput.Text}) In this way.

Hope this is helpful for you 

Thank you

[Bayan]

@kanchankolekar Hi 
Thank u for your reply. but is not Default(Orders) is used on update record? I mean the documentation syntax says: Default(DataSource), while order table here is not the source of this data. am I wrong ?

[kanchankolekar · Accepted solution]

Hello @Bayan  With Default(Orders) we can create a new record instead of that we can use First() Function to match condition data that you want to update

[Bayan · Accepted solution]

It worked perfectly dear ! Thanks a lot 😀