Checkbox updates SP List

(0) Share

Report

Posted on by Rogermiddleton

108

Hi everyone,

I am trying to create an "availabilty" function in our app. User opens startscreen and gets 3 checkboxes:

These checkboxes should be connected to a SP List called 'Members' which has 2 columns; E-mail adress and Availability (single line of text).

I would like with the OnCheck function to update the 2nd column by whoever is logged in to the app. And if one box is checked the others are automatically unchecked.

I found how to update the SP List from the checkbutton with a patch formula, but not how to connect is to Current User.

Hope you can help!

Kind regards,

Roger Middleton

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

rubin_boer 4,841 Super User 2024 Season 1 on at

Like (0)

Report

Hi there the current user is User(), you can get User().DisplayName or User().Email
you can update a variable on the OnCheck like UpdateContext({_SelectCheckBox:1}) etc and set the Default of the checkboxes to If(_SelectCheckBox=1,true,false) based on the checkbox you are on.

so
checkbox1 = UpdateContext({_SelectCheckBox:1})
checkbox2 = UpdateContext({_SelectCheckBox:2})
checkbox3 = UpdateContext({_SelectCheckBox:3})

checkbox1 deafualt =If(_SelectCheckBox=1,true,false)
checkbox2 deafualt =If(_SelectCheckBox=2,true,false)
checkbox3 deafualt =If(_SelectCheckBox=3,true,false)

Was this reply helpful? Yes No
Rogermiddleton 108 on at

Like (0)

Report
Hi @rubin_boer ,

Thank you for your help. I am not getting the patch function to work (in code below). Where 'Kimmembers' is the SPlist, 'Naam' is the first column with the email adress in, and ' Beschikbaarheid' is the column that needs to be updated.
You got any idea what I am doing wrong?
Patch( KimMembers; Defaults(KimMembers); { Naam: User().Email; Beschikbaarheid: Checkbox2.Groen } )

Was this reply helpful? Yes No
Verified answer

Dutchmann 30 on at

Like (0)

Report
Hi @Rogermiddleton , as you are talking about data that needs to be updated, I believe the
Defaults(KimMembers)
is creating your problem. Defaults is used to create a new record in your dataset. When you want to update a record, you need to lookup the record first. This would mean that the following formula would bring you closer to what you want.

Patch( KimMembers; LookUp(KimMembers;Email=User().Email); { Beschikbaarheid: Checkbox2.Groen } )

What this does is looking up the specific record in your dataset which needs to be updated. Whenever it find that record, it returns the whole record. Then, the next part of the Patch is used to only update whatever you need to update. So, in order to filter on User().Email, that user should already exist in your dataset. Therefore, it is not necessary to update the 'Naam' column.

Let me know if this answers your question.

Was this reply helpful? Yes No
Rogermiddleton 108 on at

Like (0)

Report
Hi @Dutchmann ,

This worked great, thanks! (tiny bit of modification). The search for email was too big and the lookup didnt work. The Title column for some reason did work so i put the emailadresses in the title column and made a Lookup on a label with current user in it.
Patch( KimMembers; LookUp(KimMembers;Titel=LabelEm.Text);{Avail: "Groen"})

Was this reply helpful? Yes No