Answered

Patch a choice value from one dataverse table to another dataverse table.

(0) Share

Report

Posted on by Webpro

Hello there,

I have a choice field (Type) in one of my dataverse table A. The choice field has two options ( Business and Personal). I need to patch the value of this choice field(Type) to another dataverse table B. But I kept on getting an error. Here is my code:

Patch (TableB, Defaults(TableB), {Type: LookUp('TableA', Name = selectededName, Type)}),

I also tried Patch (TableB, Defaults(TableB), {Type: LookUp('TableA', Name = selectededName).Type)})

Here is the error message

The type of this argument "Type" doesn't match the expected type "OptionSetValue".

Can someone please tell me how to properly patch in this scenario? Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

v-xiaochen-msft on at

Like (0)

Report
Hi @Webpro ,

Please try this:

Patch('TestL 17S',Defaults('TestL 17S'),{Name:"ABC",Test_Choice:LookUp(Choices('TestL 17S'.Test_Choice),Text(Value)=Text(LookUp(TestL16,Name="A1").Test_Choice_2)).Value})

/* TestL16 has a global choice field named 'Test_Choice_2'.

TestL17 has a global choice field named 'Test_Choice'.

Best Regards,

Wearsky

Was this reply helpful? Yes No
Verified answer

Webpro 11 on at

Like (1)

Report

Hi Wearsky,

I figured out why mine doesn't work. It was because I had two local choice columns. Based on your help, I changed the column to global choices. It then worked. Thank you.

Was this reply helpful? Yes No