Patch a Dataverse table using checkbox

(0) Share

Report

Posted on by ckserra33

421

Hi everyone.

I am trying to patch a table using checkboxes. I am using a dropdown to pull in the reference in the patch, but I am getting the error below.

When I check the checkbox on Checkbox9, I want Task1 on the datasource NSOStoreInfos to change to true. Ive never patched this way so I am struggling!

Thanks for any help!

Chris

Categories:

Building Power Apps

All responses (7)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@ckserra33

Couple things here...

1) Your patch formula is not specifying records or tables. You have text in it. That will not work.

2) Avoid using the SelectedText property on your dropdown as this is a deprecated property.

The question now is, what is the name of the primary column of your datasource? How is the dropdown (as you are envisioning it) to reference the item?
ckserra33 421 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes Hi Randy,

The primary column is Name, I THINK I would like to use that as a lookup to be able to patch Task1. So in this instance, my drop down is currently NSOStoreInfos . I would like to patch the column Task1 based off of that.

Do I need to AddColumns to bring in Task1 to the dropdown?
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@ckserra33

I believe you are trying to have a dropdown be the selector of the column you want to update. Is that what I'm picking up?? If so, you can't do that in PowerApps, you must declare the column in your formula.

Perhaps I am not getting what you are doing with the dropdown!?

But, in general, the Patch should be like this:

Patch(NSOStoreInfos, {primaryKeyName: PrimaryKeyOfRecord, Task1: true})

So, whatever the primary key column name is (you can verify by looking at the schema definition in your table settings) and whatever the primary key is for the record you want to patch...that is what you need.
ckserra33 421 on at

Like
a
(0)

Report
Copy link

Link copied!

@RandyHayes I am trying to use the Dropdown to select the record to update and the Task1 will be the column of the record to update.
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@ckserra33

Right...so if Name is the primary key, then your dropdown will have that and you can specify it in your formula:

Patch(NSOStoreInfos, {Name: Dropdown10.Selected.Name, Task1: true})

But, I am doubting that Name is the primary key in your table. You need to look at the schema of your table and find out what is the primary key and then substitute that in the above. Your dropdown (being based on the table entirely) will have all the columns beside Name, so you can use any one you want (well...the proper primary key is what I mean).
ckserra33 421 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @RandyHayes
So your formula works but it adds a record, not updating an existing record. It does change Task1 to true however.

Here are screen shots of the Name column showing its Primary, but maybe I meant to say the NSOStoreInfo column is the Unique Identifier?

Thanks again!
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@ckserra33

Yes, then it is not the primary key you are specifying correctly!

Patch will update a record if the primary key is supplied. If not, it will create a record.

Don't confuse the Primary name column with the primary key. What you want to find in your schema will be named as the unique identifier. Usually the name of the table itself. Then you need to use the schema name in the patch statement.

Yours shows NSOStoreInfo as the primary key.

So your patch should be:

Patch(NSOStoreInfos, {cr3db_NSOStoreInfoId: Dropdown10.Selected.cr3db_NSOStoreInfoId, Task1: true})