Answered

Using checkbox to update text fields in a SharePoint list

(0) Share

Report

Posted on by leslie_rivera

373

I am creating an outage notification app. What I want is when the checkbox is checked it patches several columns in the list with specific text. (The columns are all single line text) When unchecked it removes or overrides the data so its blank.

I have this in the OnCheck property of the checkbox

I have this in the UnCheck property of the checkbox

I am not certain what to put in the Default or OnSelect properties of the checkbox... can anyone help?

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Gopala_Krishna 1,495 on at

Like (0)

Report
Copy link

Link copied!

@leslie_rivera

OnCheck and OnSelect are both the same the moment you select the check box it triggers both the OnCheck and OnSelect parts. You can just leave the OnSelect blank as you already have the formula specified in the OnCheck.

Default is something where you want to execute some formula when the user has not performed any action on the check box, For example in the app I want to notify my user in case he has not performed any action on the check box, then I can use the default to notify the user using the notify() function indicating that no action has been performed.

For now you can just leave both the fields as blank.

More insights related to the control can be viewed in the document - Check Box control: reference - Power Apps | Microsoft Docs

If the information shared helps you, please consider giving a thumbs up 👍 and mark solution as resolved.

Was this reply helpful? Yes No
leslie_rivera 373 on at

Like (0)

Report
Copy link

Link copied!

Thanks .. but for some reason its not updating the list.. well not all the fields are updating. And I am using the field name in the formula .. example
{Systems_x0020_Affected: "File Access"}, {Systems_x0020_Affected_x0020_Mes: "Access to the file server will be unavailable during this time. "}
The Systems Affected message appears in SharePoint but the Systems Affected does not. not sure why.

Was this reply helpful? Yes No
Gopala_Krishna 1,495 on at

Like (0)

Report
Copy link

Link copied!

@leslie_rivera

Please check if the column name is mentioned correctly.
Some times though we see space in the name when storing it sharepoint tries to remove the spaces and store the information.

Go to List settings in share point --> Click on the column name --> Check the URL there you will be able to see the exact column name.

Mention the same in Patch function and it will work as expected.

If the information shared helps you, please consider giving a thumbs up 👍 and mark solution as resolved.

Was this reply helpful? Yes No
Verified answer

leslie_rivera 373 on at

Like (0)

Report
Copy link

Link copied!

I am certain I was over-complicating the task.
This post helped me find a better solution

What I did was unlock the title card, place the checkbox and my label inside the data card. Then in the Default property I added:

If(FileAccessCheckbox.Value,"File Access","")

And it worked!!!! .. now to apply to the rest of my app. Happy Friday everyone!!

Was this reply helpful? Yes No