Update Sharepoint list column from PowerApp check box

(0) Share

Report

Posted on by diegoandre10

517

Hi all

I have a choice column from a SP list like this:

In my power app, I have first added a blank vertical gallery and within a checkbox.

The gallery items looks the following:

And the text property for the checkbox:

What should I do next in order to update the SP list?

Not sure what to enter on the oncheck property for example.

Thanks!!

Categories:

Building Power Apps

All responses (7)

Answers (0)

Sort by

WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
@diegoandre10 ,

Not sure why you are using a checkbox for a Choices field, but assuming Flag as ERM is the only Choice, you can do the following.
OnCheck

Patch( 'BCM LATAM', {ID:SharePointIntegration.Selected.ID}, { 'ERM Issue': {Value:Self.Text} } )

OnUnCheck

Patch( 'BCM LATAM', {ID:SharePointIntegration.Selected.ID}, { 'ERM Issue': {Value:Blank()} } )

Default of the CheckBox

SharePointIntegration.Selected.'ERM Issue'.Value = Self.Text

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.
diegoandre10 517 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @WarrenBelz

It's now working when I add a new item and check the box. It gives me this message when i click on the box:

How can i fix it?

You're right about the choices, it's probably better to use single line of text maybe? How would that be then?

Regards!!
WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
@diegoandre10 ,

Please ignore that message - it is not an error.

For a Text field

OnCheck

Patch( 'BCM LATAM', {ID:SharePointIntegration.Selected.ID}, {'ERM Issue':Self.Text} )

OnUnCheck

Patch( 'BCM LATAM', {ID:SharePointIntegration.Selected.ID}, {'ERM Issue':Blank()} )

Default of the CheckBox

SharePointIntegration.Selected.'ERM Issue' = Self.Text

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.
diegoandre10 517 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz

I changed the SP to single line of text and removed the vertical gallery. Just left the check box.

I get the following error after trying your code:

What should I do ?

Thanks!!
WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

@diegoandre10 ,

Go to your SharePoint list and the List Settings, select Title and uncheck the requirement for information as below

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.
diegoandre10 517 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @WarrenBelz

I need title to be a mandatory field for the user.

Regards.
WarrenBelz 156,570 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @diegoandre10 ,

Then there is something wrong with your record - you are patching an existing record which should have data in Title.

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.