web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Add multiple Choice Co...

Power Apps

Answered

Add multiple Choice Columns to Collection

(0) Share

Report

Report

Posted on by nemo1

Hi all,

I am attempting to create a collection using 3 Choice columns from a Sharepoint List.

I have tried using the below however, this does not expand the data and seems to leave each entry in each column all within individual tables

ClearCollect ( colList , ShowColumns ( SPLsource , "Item1" , "Item2" , "Item3" ) )

Can anyone help with the next step please?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Sort by

Rajkumar_M 3,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi

Try this

ClearCollect(colList, AddColumns(SPLsource, "Choice1Value", Choice1.Value, "Choice2Value", Choice2.Value, "Choice3Value", Choice3.Value))

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
nemo1 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the fast reply.
For some reason it seems to be returning the entire Sharepoint List not just the 3 required columns. Is there an easy way to remove the others?

Was this reply helpful? Yes No
Verified answer

timl 37,283 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @nemo1

Here's a formula to return only the 3 required columns.

ClearCollect( colList, ShowColumns( AddColumns( SPLsource, "Choice1Value", Choice1.Value, "Choice2Value", Choice2.Value, "Choice3Value", Choice3.Value ), "Choice1Value", "Choice2Value", "Choice3Value" ) )

Was this reply helpful? Yes No
nemo1 on at

Like
a
(0)

Report
Copy link

Link copied!

Works great, thanks

Where would I put a filter statement in the formula? "Choice1Value" contains blanks which I would like to screen out

Was this reply helpful? Yes No

Join the conversation