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
Solved! Go to 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
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
@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 ?
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
It worked perfectly dear ! Thanks a lot 😀
User | Count |
---|---|
160 | |
91 | |
68 | |
64 | |
63 |
User | Count |
---|---|
210 | |
157 | |
93 | |
81 | |
71 |