web

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

News and Announcements icon

Power Platform CommunityForums Power Apps How to populate a Choi...

Power Apps

Unanswered

How to populate a Choice Column of a Dataverse table using a Patch with values found in a Collection

(0) Share

Report

Report

Posted on by JF000001

36

I have some values in a Collection, corresponding to the actual text values of a choice column found in Dataverse. How can I update my choice column using a patch, with the values found in my collection.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (0)

Sort by

v-bofeng-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @JF000001 ,

Please try:

Patch( DataSource, BaseRecord, { ChoiceColumn:Filter( Choices(DataSource.ChoiceColumn), Text(Value) in TheCollection.ColumnName ) } )

Best Regards,
Bof

Was this reply helpful? Yes No
JF000001 36 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @v-bofeng-msft This doesn't appear to be working. Here is my current code. I have a collection being populated with the choice values for several records. I wish to populate another table with these corresponding choices as seen below. Thanks again.

ClearCollect(MyCollection, ShowColumns(ATable, "MyColumnHavingTheChoicesAsText"));
ForAll(MyCollection,Patch(MyTableToPatch, Defaults(MyTableToPatch), {MyChoiceColumn: MyColumnHavingTheChoicesAsText}));

Was this reply helpful? Yes No

Join the conversation