Unanswered

Create a record in Dataverse table using canvas screen data

(0) Share

Report

Posted on by Community Power Pla...

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

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

kanchankolekar 69 on at

Like (0)

Report

Hello @Anonymous
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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@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 ?

Was this reply helpful? Yes No
Verified answer

kanchankolekar 69 on at

Like (1)

Report

Hello @Anonymous 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

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (1)

Report

It worked perfectly dear ! Thanks a lot 😀

Was this reply helpful? Yes No