Saving user and choices to a list.

[AaranWork]

Hi, I have a PowerApp I have been working on that presents some data from an excel table in a Gallery,

I have added to this gallery a tickbox as shown below.

The purpose of the app is that multiple users can access the app, tick multiple boxes, and then click save.

Obviously with multiple people picking multiple options there will be overlaps between them, these need to be recorded.

I have created a list in sharepoint "AcademicChoices" and given it the extra column of "Volunteer"

How I imagine this will work is that when the user has ticked some boxes it will send the "Project Title" to the "Title" column, and the username of the person logged into the app to the "Volunteer" column for each of their ticked items.

Here is a crude example of how it would work assuming that the user of the powerapps username was "stan"

Thoughts on this? Or is there perhaps a better way of trying to record the information I am looking for?

Thanks.

[v-xida-msft · Accepted solution]

Hi @AaranWork,

Could you please share a bit more about your scenario?

Do you want to record the items the user checked within the Gallery into a SP list?

If you want to record the items the user checked within the Gallery into a SP list, I agree with your thought. I think the Patch function could achieve your needs.

I have made a test on my side, please take a try with the following workaround:

Within the Gallery, set the OnSelect property of the Check Box control to following:

If(
    Checkbox1.Value=true,
    Patch('20190114_case9_1', Defaults('20190114_case9_1'), {Title: ThisItem.'Project Title', Volunteer: User().FullName})
)

On your side, you should type:

If(
    Checkbox1.Value=true,
    Patch(
          'AcademicChoices', 
           Defaults('AcademicChoices'), 
           {
              Title: ThisItem.'Project Title', 
              Volunteer: User().FullName
           }
     )
)

More details about the Patch function, please check the following article:

Patch function

Best regards,

Kris

[AaranWork]

Hi, yes I would like to save it in a sp list so that it could be used in another powerapp, however the problems I am running into are that multiple peoples choices will need to be recorded without overwriting data, for example multiple people could volunteer for the same project, so if jan, sammy, and stuart, were all to say they wanted to volunteer for iains project then it would need to record that all three people were interested.

[v-xida-msft]

Hi @AaranWork,

Based on the needs that you mentioned, I think the solution I provided above could achieve your needs.

When you click Check Box within your Gallery, the Patch formula would be executed, then save a new record into your AcademicChoice SP list without overwriting records with same Title value.

Please take a try with above solution I provided, then check if the issue is solved. 

If the issue is solved on your side, please go ahead to click "Accept as Solution" to identify this thread has been solved for other users.

Best regards,

Kris

[AaranWork]

Thank you, I will give this a go now and see if I can get it working.

edit:

This works perfectly, thank you.

I would like to expand on the functionality so that they are able to uncheck and delete the value from the list, I will try and figure out how to do this.

[AaranWork]

I made some changesto capture more info and try to remove the values if the user changes their mind and unticks a box

    If(
        Checkbox1.Value=true,
        Patch(
              'AcademicChoices', 
               Defaults('AcademicChoices'), 
               {
                  Student: ThisItem.student_x0020_email, 
                  Title: ThisItem.project, 
                  Volunteer: User().FullName
               }
         ),
Checkbox1.Value=false,
        Remove(
              'AcademicChoices', 
               Defaults('AcademicChoices'), 
               {
                  Student: ThisItem.student_x0020_email, 
                  Title: ThisItem.project, 
                  Volunteer: User().FullName
               }
         )
     )

Unfortunatly its not removing the values from the list in my tests so far.

I also tried moving the code to make use of "oncheck" and "onuncheck"

OnCheck

Patch(
              'AcademicChoices', 
               Defaults('AcademicChoices'), 
               {
                  Student: ThisItem.student_x0020_email, 
                  Title: ThisItem.project, 
                  Volunteer: User().FullName
               }
         )

OnUncheck

Remove(
              'AcademicChoices', 
               Defaults('AcademicChoices'), 
               {
                  Student: ThisItem.student_x0020_email, 
                  Title: ThisItem.project, 
                  Volunteer: User().FullName
               }
         )

Again this will add the data to the list happily, but unticking the boxes does not remove the data.