Unanswered

Patching Choice Column

(1) Share

Report

Posted on by MF-11091236-0

Attempting to patch to a true/ false Dataverse Choice column

Patch(
    Tickets,
    LookUp(Tickets, Ticket_Owner = ThisItem.Value && Status = 0),
    { statecode: { Value: 0 }}
)
 
Error Message: The type of this argument statecode does not match the excepted OptionSetValue (Status (Tickets)) Found Type Record
The Status column is Choice with 'Active' 0 and 'Inactive' 1 choices
 
I've attempted to use UpdateIf also and receive similar error.
UpdateIf(
Tickets,
Ticket_Owner = ThisItem.Value && Status = 0,
{ statecode: { Value: "Active" }}
)
 
Have also attempted to use decimal 0 and text but no luck, ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

MF-11091236-0 41 on at

Like (0)

Report

the dataverse column definition

Was this reply helpful? Yes No
Suggested answer

Nandit 1,568 Moderator on at

Like (0)

Report
Hi MF-11091236-0,

Can you try updating your first option to the below:

Patch( Tickets, LookUp(Tickets, Ticket_Owner = ThisItem.Value && Status = "Active"), { statecode: { Value: "Active" }} )

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
Suggested answer

MF-11091236-0 41 on at

Like (0)

Report

Still working on solution

Was this reply helpful? Yes No
Suggested answer

MF-11091236-0 41 on at

Like (0)

Report

was able to get working by using the following code and enabling delegation for UpdateIf and RemoveIf within Settings/ Experimental. The key was looking up the value defined within Tickets.Status.

UpdateIf( Tickets,

Ticket_Owner = ThisItem.Value

And Redeemed_Date = Blank()

And Status = LookUp(Choices(Tickets.Status), Value = 0).Value,

{ Status: LookUp(Choices(Tickets.Status), Value = 1).Value }

)

Was this reply helpful? Yes No