Updateif, Patching Choice Column, Expected Boolean

(0) Share

Report

Posted on by wonka1234

920 Super User 2024 Season 1

Hi all,

Getting an error here that i am not understanding - expected boolean.

where am I going wrong here?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

@wonka1234 - assuming your data source is SharePoint, and assuming the field you want to Patch is a Yes/No data type, enter "true" (without quotations) instead of "Yes".

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report

@Amik it is a choice column with two options, Yes or No.

Still getting error -

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report

@Amik Update - I came up with these two solutions, however they arent actually patching in my SP list.

1. UpdateIf(colData, true, {Status: "Submitted"}, true, {'Description Approval': {Value: true}})

2.UpdateIf(colData, true, {Status: "Submitted"}, true, {'Description Approval': {Value:"Yes"}})

both run without errors but dont update my description approval field with yes in the background.

I do run Patch('data source',colData);" after the above lines.

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
@wonka1234 - The {Value: "string"} pattern is often misused and/or misunderstood. Forcing values into data types which require a record should be avoided.

You can pass a record into your UpdateIf statement using the LookUp function.

UpdateIf( colData, true, { Status: LookUp( Choices([@'Status'].Choice), Value = "Yes" ) } );

Further reading: https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/working-with-tables

Was this reply helpful? Yes No
wonka1234 920 Super User 2024 Season 1 on at

Like (0)

Report

@Amik grr still error -

UpdateIf(
colData,
true,
{Status: "Submitted"},
true,
{'Description Approval': LookUp(
Choices([@'Description Approval'].Choice),
Value = "Yes"
)
}
)

where am i going wrong?

Was this reply helpful? Yes No
james1994 229 Moderator on at

Like (0)

Report

Hi @wonka1234,

Could you provide a bit more detail in what you're trying to do?

Are you trying to update all records in a collection or records that have the Status = Submitted?

Was this reply helpful? Yes No
Verified answer

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
My fault - the example I provided was confusing. The syntax of the Choices function requires the name of your data source, together with the field:

Choices([@'Your List Name'].'Description Approval')

Full syntax:

UpdateIf( colData, true, { Status: "Submitted", 'Description Approval': LookUp( Choices([@'Your List Name'].'Description Approval'), Value = "Yes" ) } );

Note above there is no need to apply multiple conditions to your UpdateIf statement if the condition is always going to be true.

@wonka1234 -

Was this reply helpful? Yes No