cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Joko
Level: Powered On

Checkbox not patching sharepoint list.

Hi there,

 

I have been trying to get a checkbox to change a field "Acknowledged" to "Yes".  I have been looking at This link but just cannot figure it out.  

 

I have a gallery named (Gallery2) with a checkbox, which is currently set:

 

 

OnCheck: Patch('RoomDamageApp - Room Damage', Defaults('RoomDamageApp - Room Damage'), Gallery2.Selected, {Acknowledged: "Yes"})

 

I get this issue warning:

The type of this argument 'Acknowledged' does not match the expected type 'Boolean'. Found type 'Text'.

Any tips would be super. 


Thanks.

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: Checkbox not patching sharepoint list.

Hi @Joko,

 

I advise you not to use a CheckBox in your gallery : I tryed it and got a big loop bug...

My source Liste_Test have a column TestOuiNon

 

Look how I did it ->Appli.PNG In my gallery I put a button with these statements

.Text : If(ThisItem.TestOuiNon;"Activé";"Désactivé")
If(ThisItem.TestOuiNon=true;
    Patch(Liste_Test;ThisItem;{TestOuiNon:false});
    Patch(Liste_Test;ThisItem;{TestOuiNon:true})
)

I hope I helped you 🙂

 

Regards,

 

Louis

View solution in original post

8 REPLIES 8
Anonymous
Not applicable

Re: Checkbox not patching sharepoint list.

Hi @Joko,

 

Following your error, the problem is the type of your variable.

In don't know your data source but your column Acknowledged is waiting for a boolean type.

The value "Yes" you want to set on the column is flase --> it's a text type

Boolean values are : {true, false}

 

You can try then with  :

OnCheck: Patch('RoomDamageApp - Room Damage', Defaults('RoomDamageApp - Room Damage'), Gallery2.Selected, {Acknowledged: true})

Try it and tell me

 

Best regards,

Louis

Joko
Level: Powered On

Re: Checkbox not patching sharepoint list.

Ohhh, what a silly mistake to miss haha.  

 

Thanks for that.  However the problem i have now is, it is creating a new entry rather than updating the exiting record i am updating.  Is it my patch rule?

 

Thanks.

Anonymous
Not applicable

Re: Checkbox not patching sharepoint list.

@Joko,

 

What do you want exactly ? Update informations of an existing data or create a new data ?

 

Regards,

 

Louis

Joko
Level: Powered On

Re: Checkbox not patching sharepoint list.

So i have these records:

Do you see that its adding the YES/NO to a new entry/line rather than editing the one with information already there?

 

I am ticking the box within a Gallery.


Thanks.

 

1111.PNG

xzDan
Level 8

Re: Checkbox not patching sharepoint list.

Defaults(Source) will create a new record.

 

Try doing something like

Patch(<Source>,Id=Gallery2.Selected.Id, {Edits})
Anonymous
Not applicable

Re: Checkbox not patching sharepoint list.

Hi @Joko,

 

I advise you not to use a CheckBox in your gallery : I tryed it and got a big loop bug...

My source Liste_Test have a column TestOuiNon

 

Look how I did it ->Appli.PNG In my gallery I put a button with these statements

.Text : If(ThisItem.TestOuiNon;"Activé";"Désactivé")
If(ThisItem.TestOuiNon=true;
    Patch(Liste_Test;ThisItem;{TestOuiNon:false});
    Patch(Liste_Test;ThisItem;{TestOuiNon:true})
)

I hope I helped you 🙂

 

Regards,

 

Louis

View solution in original post

Joko
Level: Powered On

Re: Checkbox not patching sharepoint list.

This worked a treat for me!


Thank you very much! 

 

On the back of this, do you know if you can make Gallerys show new records at the top? Rather than old > new.


Thanks.

Anonymous
Not applicable

Re: Checkbox not patching sharepoint list.

You can just set your statement 'Items' of the gallery to :
SortByColumns(Filter(Liste_Test; StartsWith(Title; TextSearchBox1.Text)); "Created"; Descending)

if you wanna filter your source with the search box, and 
SortByColumns(Liste_Test; "Created"; Descending)

if you don't

 

Best regards 🙂

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (9,952)