Creating a collection with Choice field from Dataverse

(0) Share

Report

Posted on by JM_Jackson

I am trying to create a collection for a dropdown that contains information from a choice field called "Targeted Milestone" which is in a Dataverse source document called "Outstanding Claims" and then add a "All" item component to the collection.

The collection is giving me an error and not creating the collection and I am not sure why?

ClearCollect(colMile,{Value: "All"});
Collect(colMile,Choices('Outstanding Claims'.'Targeted Milestone (Dropdown)'))

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @JM_Jackson ,

I did a sample for you.

ClearCollect(colMile,{Value:"All"});Collect(colMile,RenameColumns(ShowColumns(AddColumns(Choices(TestL16.Test_Choice),"Value2",Text(Value)),"Value2"),"Value2","Value"))

// Test_Choice is the choice column of the TestL16 table in dataverse.

Best Regards,

Wearsky

Was this reply helpful? Yes No