cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
JM_Jackson
New Member

Creating a collection with Choice field from Dataverse

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)'))

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-xiaochen-msft
Community Support
Community Support

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

View solution in original post

1 REPLY 1
v-xiaochen-msft
Community Support
Community Support

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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (2,753)