Patch checkbox to SPO yes/no field

[Radoslavov]

Hi all, i'm guess this is something simple but i could fine a solution for it, so i wanted to ask here.

I have two checkboxes in my Power app, the true values must be patched to an SPO list in two yes.no fields. The user add a location and specifies the access level that he needs Read or Write. Everything is stored perfectly in the collection, but when the values are patched to SPO they have the same value

My patch formula is:

ForAll(
    ColFileServerFolderAccess,
        Patch(
            'File server folder access',
            Defaults('File server folder access'),
            {
                'Read permissions':chb_read.Value,
                'Write permissions':chb_write.Value
            }
))

Any idea what is wrong with my formula that puts the last selected item's value to all records from the list when patched to SPO?

Regards,

Kiril

[WarrenBelz]

Hi @Radoslavov ,

You need to refer to each record

Patch(
   'File server folder access',
   ForAll(
      ColFileServerFolderAccess As aCol,
      {
         'Read permissions': aCol.chb_read.Value,
         'Write permissions': aCol.chb_write.Value
      }
   )
)

You will also find this structure much faster.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[Radoslavov]

Hi @WarrenBelz i'm getting an error message on my formula

Patch('File server folder access',
ForAll(ColFileServerFolderAccess As aCol,
            {
                'Read permissions':aCol.ReadPermissions,
                'Write permissions':aCol.WritePermissions
            }
        ));

[WarrenBelz]

@Radoslavov ,

You seem to have the fields the wrong way around (I assume chb_read and chb_write are the fields in your SP List).

Patch(
   'File server folder access',
   ForAll(
      ColFileServerFolderAccess As aCol,
      {
         chb_read: aCol.'Read permissions'
         chb_write: aCol.'Write permissions'
      }
   )
)

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[Radoslavov]

Nope let me give you some more info about the fileds, maybe that will help.

chb.read & chb_write are the checkboxes in the app 

ReadPermissions & WritePermissions are the columns in my collection 

Read permissions & Write permissions are the columns in my SPO list

When i start typing inside the curly brackets no suggestions are appearing, so I guess it doesn't look either in the list, not the collection.

[WarrenBelz]

@Radoslavov ,

OK I can see all the values now

Patch(
   'File server folder access',
   ForAll(
      ColFileServerFolderAccess As aCol,
      {
         'Read permissions': aCol.ReadPermissions,
         'Write permissions': aCol.WritePermissions
      }
   )
)

Check the values are correct, but the first is the fields in your list and the second the corresponding field in the collection. The checkboxes are irrelevant - they have already written to the collection.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

[Radoslavov]

Nope still an error, the whole thing is that if I remove everything from the curly brackets, the formula is ok, so the problem is that the formula doesn't recognize the fields inside the curly brackets.

Error message: Expected operator. We expect an operator such as +,*, or & at this point in the formula.

[WarrenBelz]

@Radoslavov ,

There is a single quote missing - see if you can find it

[Radoslavov]

I also though that, but when i correct it i got the same error as earlier 

[WarrenBelz]

@Radoslavov ,

Please confirm that all four fields (in both the List and the Collection) are Boolean (yes/no) fields. There is something wrong here (see below on a Text List with a Yes/No field - works perfectly (as expected).