web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Patch a choice value f...

Power Apps

Answered

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

(0) Share

Report

Report

Posted on by Webpro

11

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

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
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
Verified answer

Webpro 11 on at

Like
a
(1)

Report
Copy link

Link copied!

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.

Join the conversation