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 😀
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
User | Count |
---|---|
181 | |
52 | |
41 | |
39 | |
33 |
User | Count |
---|---|
261 | |
81 | |
71 | |
69 | |
66 |