Answered

How to patch data to a Dataverse table

(1) Share

Report

Posted on by Gilmour

362

Hi, I have never used Dataverse tables with PowerApps, and I assumed that PowerApps formulas would be the same whether I used them with SharePoint as a data source, or Dataverse.

I.e., function Patch. I am trying to patch the value stored in a text label in a form to a Dataverse table field named 'ParentID'. The syntax I'm using is Patch('MyDataverseTable',ThisItem.'ParentID',TextLabel) and PA won't accept it, whether the form Default Mode is New or Edit.

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Gilmour

Using Patch to edit an existing record can often look something like this:

Patch(MyDataverseTable, LookUp(MyDataverseTable, PrimaryKeyField = ThisItem.PrimaryKeyField), {'ParentID': TextLabel.Text})

Replace 'PrimaryKeyField' with the primary key column name of your Dataverse table, and 'MyDataverseTable' with the name of your actual Dataverse table. ThisItem.PrimaryKeyField refers to the unique identifier of the record you want to modify.

Here, we're telling PowerApps to find a record in 'MyDataverseTable' where the primary key is equal to ThisItem.PrimaryKeyField and then update the 'ParentID' of that record with the text from TextLabel.

Make sure that TextLabel is the correct name of your text label and that TextLabel.Text returns the value you expect.

If you are trying to make a new row/record it would be something like:

Patch(MyDataverseTable,Defaults(MyDataverseTable), {'ParentID': TextLabel.Text})

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I read it again and noticed you mentioned using a form, the SubmitForm() function lets you submit the whole form and it's data to updated records in the datasource if you want to patch use what i previously suggested but if you are trying to submit form then yehp just use submitform

Was this reply helpful? Yes No
Gilmour 362 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you @AJ_Z . I am going to give it a try. I am wondering, what if I am trying to create a new item instead of editing an existing one?

Was this reply helpful? Yes No
Verified answer

AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Are you trying to do this with a Form if so have the formmode in new. If you are trying to use the patch function it would be similar to what i suggested:

Patch(MyDataverseTable,Defaults(MyDataverseTable), {'ParentID': TextLabel.Text})

Was this reply helpful? Yes No
Gilmour 362 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you @AJ_Z. Pls disregard my previous reply: your first one already answered that! Thank you. I'll give it a try!

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Let me know how it goes or if you have some more questions on it 🙂

Was this reply helpful? Yes No
Gilmour 362 on at

Like
a
(1)

Report
Copy link

Link copied!

No, @AJ_Z , it worked great. Thank you!

Was this reply helpful? Yes No
AJ_Z 3,711 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I am glad I could help 🙂

Was this reply helpful? Yes No