web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Populating a Choice Co...

Power Apps

Answered

Populating a Choice Column in Dataverse with the Values from another Column in the same Table

(0) Share

Report

Report

Posted on by JF000001

36

I am trying to populate a Choice Column in Dataverse (for all the rows), with the values found in another column of the same table, using the code below, but this is not working:

ForAll(MyCollection,Patch(MyTable,ThisRecord,{MyChoiceColumn: MyStringColumn)}))

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @JF000001 ,

Let's say the other column is a text column.

ForAll(Col As temp,Patch(Table1s,LookUp(Table1s,Table1=temp.Table1),{Designation:LookUp( AddColumns(Choices(Table1s.Designation),"value2",Text(Value)),value2=temp.A).Value})) // Table1 is the unique identifier column

Best Regards,

Wearsky

Was this reply helpful? Yes No
JF000001 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you a million @v-xiaochen-msft I wouldn't have never guessed that syntax!

Was this reply helpful? Yes No

Join the conversation