Update using Checkbox

(0) Share

Report

Posted on by Srihari.molaka

103

Hi Experts,

I am new to PowerApps, I have connected sql server with PowerApps.

I have one field called approve which is int datatype, I need to update the values for this field using checkbox.

For suppose if checkbox is checked then the approve value will become 1, if the checkbox is not checked then the approve value will be 0.

Please suggest me the correct path.

Can anyone help me to achieve this?

Thanks,

with regards,

user237,

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

Sort by

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

OnSelect of a Button try this code
Patch(Datasource,Defaults(Datasource),
{Approve:If(Checkbox1.Value=true,1,0)})
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Srihari.molaka 103 on at

Like (0)

Report
Copy link

Link copied!

Hi @eka24 ,
Thanks for your reply,
I have tried this formula at onSelect property of checkbox card, but it is throwing error like invalid arguments for patch.
Instead of colon it is expecting closed bracket.
with regards,
User237,

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Please give a screen shot
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Srihari.molaka 103 on at

Like (0)

Report
Copy link

Link copied!

Hi @eka24 ,
Thanks for your reply,
below is the screenshot of my edit form
these two cards related to one field called approved
with regards,
user237.

Was this reply helpful? Yes No
Srihari.molaka 103 on at

Like (0)

Report
Copy link

Link copied!

Hi all,
I have also seen the below post which is near to my requirement but did not understand well.
https://powerusers.microsoft.com/t5/Building-Power-Apps/Using-Checkbox-to-Update-txt-field/m-p/626615/highlight/false#M198547

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

Please show a screen shot of the Patch formula
You also mentioned a checkbox, is it same as shown in the picture
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Srihari.molaka 103 on at

Like (0)

Report
Copy link

Link copied!

Hi @eka24 ,
Thanks for your reply,
Patch(Datasource,Defaults(Datasource), ThisItem.APPROVED : if(Checkbox3.Value = true, 1, 0))
yes, I mentioned the checkbox in the picture named as checkbox3.
with regards,
user237.

Was this reply helpful? Yes No
Srihari.molaka 103 on at

Like (0)

Report
Copy link

Link copied!

Hi @eka24 ,
Thanks for your help,
I have created a new button called save, for that button i have written the patch formula which is provided by you,
It is working now.
But the save button throwing error like Partition field required in the patch formula, can you give any solution for this?
with regards,
user237.

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

It means that you have a column called Partition that you have made it a required field.

So either you remove the required in the Table and make it not required.
Or A
that to the Patch formula Like
Patch(Datasource,Defaults(Datasource), {APPROVED : if(Checkbox3.Value = true, 1, 0),
Partition: Datacaradvalue4.Texy})
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Srihari.molaka 103 on at

Like (0)

Report
Copy link

Link copied!

Hi @eka24 ,
Thanks for your reply,
It is asking all the fields in the table to add.
with regards,
user237

Was this reply helpful? Yes No