cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

SharePoint Choice Column in a PowerApp collection

Hi, 

 

I have used : ClearCollect(v_col,'Strategic Objectives') to get a list called Strategic Objects into a collection called v_col. I need to grab the value of the choice columns in this collection so i can query over it. but when i look at the colleciton i get the 

 

Capture.PNG

logo. All this makes sense but i need the .value from this object - so i can query against it on all columns.

any ideas ? 

 

 

10 REPLIES 10
v-yutliu-msft
Community Support
Community Support

Hi @Anonymous ,

Do you want to use the value of the choice type column in a table?

Firstly, the reason why you face this situation is that the choice column in a SharePoint list will be formatted to a table in PowerApps.

Secondly, could you tell me whether your choice column is multiple?

1)not a multiple choice

Create a gallery, set its items:

AddColumns(Strategic Objectives," Objective_Type 2", Objective_Type.Value)

Create a button, set its OnSelect:

ClearCollect(v_col,Filter(Gallery1.AllItems, Objective_Type2=”Yes”)

2)a multiple choice

ClearCollect(v_col,Filter('Strategic Objectives',"Yes" in ForAll(Objective_Type.Value,Value)))

 

 

 

 

Best regards,

Community Support Team _ Phoebe Liu

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,969)