cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TGrounds
Resolver II
Resolver II

Updating a Boolean in SharePoint using Patch throws 'An Unknown Error Occurred'

I'm working with a form that reads records from one data source (SharePoint List) into a Gallery and using a button on each record, It writes or updates a record in a second SharePoint list.  I was running into an issue were nothing would update so I began breaking it down field by field.  I use the First(Filter method to find the record to update and then update two text fields and two Boolean fields.  When I added the first Boolean field I received a message 'An Unknown Error Occurred'  Here is the code I'm using:

Patch(CustomerSuccessCriteriaTracking, First(Filter(CustomerSuccessCriteriaTracking, Customer='CMB:SelectCustomer'.Selected.Value && Success_Engagement='CMB:SelectSuccessEngagement'.Selected.Value && Success_Internal_ID = SuccessInternalIDExample.Text)),
{Success_Description:SuccessCriteriaDescriptionExample.Text},
{Unit_of_Measure:UOMExample.Text},
{From_Value:SetFromValue})

I'm successful when I leave out the 'From_Value' statement.  This is the Boolean value.

 

Has anyone else run into this?  is there a different way I need to be dealing with this data type?

 

Thanks-
Tom.

1 ACCEPTED SOLUTION

Accepted Solutions
TGrounds
Resolver II
Resolver II

And I'm an idiot... For some reason I put the Boolean values into a Text box rather than in a Checkbox.  Once I made that change it is working as expected.

View solution in original post

1 REPLY 1
TGrounds
Resolver II
Resolver II

And I'm an idiot... For some reason I put the Boolean values into a Text box rather than in a Checkbox.  Once I made that change it is working as expected.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (2,248)