Unanswered

Patching to a choice column

(0) Share

Report

Posted on by Cathleen307

I am trying to patch to an existing record. The column I want to patch to is a choice column. but I cannot seem to get the proper syntax for the function. I have looked at similar posts, and come up with the following.:

Patch('Process Diary', LookUp('Process Diary', ID=VarX), {StatusByQuality: {Value: "Approved"}})

but get the following error message:

Thank you in advance for your support.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
@Cathleen307

You will do much better in these cases to use the UpdateIf function rather than Patch, only because you are doing 2 datasource actions...LookUp and Patch. UpdateIf will do it in one shot.

UpdateIf('Process Diary', ID=VarX, {StatusByQuality: {Value: "Approved"}} )

Beyond that, your syntax is correct. Tell me more about the definition of that column in your list. Is it really a Choice column and does it allow for multiple choices?

Was this reply helpful? Yes No
MF-11091236-0 41 on at

Like
a
(0)

Report
Copy link

Link copied!

The dataverse column definition.

Was this reply helpful? Yes No