Answered

Checkbox value saving to SQL database

(0) Share

Report

Posted on by janineb

Good day

I have a few checkboxes who's value must save to a SQL database:

This is the code behind the Submit button (SelectedRecord is the variable):
Patch(SelectedRecord, {'WATCHLIST RISK INCLUSIVE': WListInclusiveDD.SelectedText.Value, 'Economic Risks': EconomicRiskChk.Value, 'Business Risks': BusinessRiskChk.Value, 'Financial Risks': FinRiskChk.Value, 'Credit Risk Migration': CreditRiskMitChk.Value, 'Covenant Breaches': CovenantBreachesChk.Value, 'Other Material Breaches': OtherChk.Value, 'WATCHLIST RISK COLOUR': WListRiskColourDD.SelectedText.Value, HI_CapturedBy: CapturerTxt.Text, HI_DateUpdated: CaptureDate.SelectedDate}); Navigate(ThankYou)

I am however getting the following error:

The field types in SQL is "Bit" (and I have also tried "Int"), but somehow I keep getting the error on a few of the Risk fields. Can you perhaps advise me what I am doing wrong?

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

janineb on at

Like
a
(0)

Report
Copy link

Link copied!

I managed to workaround the error by changing the checkbox fields to 'Business Risks': Text(BusinessRiskChk.Value). Is this acceptable?

Was this reply helpful? Yes No
janineb on at

Like
a
(0)

Report
Copy link

Link copied!

My workaround is not working 😞

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @janineb ,

These columns are of type Text, what values would you like to save in the table? You have different check boxes for respective columns, say EconomicRiskChk is checked, then what will be saved in 'Economic Risks' column?

Generally speaking, we will design the table with a single column named "Risk Types", then populate this column with a checked value. But for your scenario, I think risk types could be multiple. So, Please try and use below formula:

Patch(SelectedRecord, {'WATCHLIST RISK INCLUSIVE': WListInclusiveDD.SelectedText.Value, 'Economic Risks': If(EconomicRiskChk.Value,"Y","N"), 'Business Risks': If(BusinessRiskChk.Value,"Y","N"), 'Financial Risks': If(FinRiskChk.Value,"Y","N"), 'Credit Risk Migration': If(CreditRiskMitChk.Value,"Y","N"), 'Covenant Breaches': If(CovenantBreachesChk.Value,"Y","N"), 'Other Material Breaches': If(OtherChk.Value,"Y","N"), 'WATCHLIST RISK COLOUR': WListRiskColourDD.SelectedText.Value, HI_CapturedBy: CapturerTxt.Text, HI_DateUpdated: CaptureDate.SelectedDate}); Navigate(ThankYou)

So, if a check box is checked, corresponding column will be Y, otherwise N.

Best regards,

Was this reply helpful? Yes No
janineb on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you for your kind assistance

Was this reply helpful? Yes No