Updating a different SQL table using checkboxes

(0) Share

Report

Posted on by ebraga

118

Good Morning,

I am new to PowerApps, in my latest app I have two SQL server connections. (one is a table and one is a view)

In my table, there is one field called PickResult which is int datatype. I need to update the values for this field using a submit button. The checkboxes in my gallery pull from a different SQL view than the table I want to update.

If PICK is checked then the PickResult value will become 1, if the FAIL is checked then the PickResult value will be 0.

It is possible to do this?

Thank you

Categories:

Building Power Apps

All responses (9)

Answers (0)

Sort by

eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

On the OnCheck of the Pick;

Patch(Datasource, ThisItem,
{PickResult: Value (Lable1.Text)+1})

On the OnCheck of the Fail;

Patch(Datasource, ThisItem,
{PickResult: Value (Lable1.Text)-1})

Change label1 to the actual name of the label inside the Gallery

------------

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.
ebraga 118 on at

Like
a
(0)

Report
Copy link

Link copied!

The SQL view I'm pulling into the gallery does not have the column that I need to update in my SQL table. I want the check boxes to be able to push the updates into the 'PickResults' column with either a 1 or 0.
haroldk Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

if there is only a single choice you may want to use a Radio button. Checkboxes allow for multiple selections.

Assume you have a Radiobutton controls with the items property this: ["Pick","Fail"]

Then in the update property of the Picklist Fields you could use this logic

If(Radio1.Selected.Value="Pick",1,0)
ebraga 118 on at

Like
a
(0)

Report
Copy link

Link copied!

I have made it so users can only select one check box at a time. . The idea is that after the user checks off each of line items with either pick or fail, they would click on the button which would then update the SQL table.
eka24 20,925 on at

Like
a
(0)

Report
Copy link

Link copied!

Did you try the formula. Is the issue Resolved?

------------

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.
ebraga 118 on at

Like
a
(0)

Report
Copy link

Link copied!

I tried the formula and the issue did not resolve. The gallery (the SQL view) and the table that I want to update do not have the same columns (or 'label') names. I'm looking to update all the check box data to the SQL table at once instead of invidually. Please refer to the other comments I have posted here. Thank you
haroldk Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

I have connected a gallery to a SQL View and the coding is very much simplified, but it shows how this can be done.

the OnCheck property of the Checkboxes looks like this

UpdateContext({varPick:1});
Collect(colResults,{BusEntID:ThisItem.BusinessEntityID,PickResult:varPick,LastName:ThisItem.LastName})

After all the selections are completed there is a Submit button to save the values in the collection to a SQL table

ForAll(colResults,Patch('[dbo].[Results]', Defaults( '[dbo].[Results]'),{BusEntID:BusEntID,LastName:LastName,PickResult:PickResult}))
ebraga 118 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you a bunch, this helped a lot. My only question is, how can I make it so the items that have been updated to the SQL table to be removed from the collection?
haroldk Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

You can change the expression to lookup to the expressions

ForAll(colResults,Patch('[dbo].[Results]', LookUp('[dbo].[Results]',BusEntID=BusEntID) ,{BusEntID:BusEntID,LastName:LastName,PickResult:PickResult}))