Answered

Multi Select Checkboxes in Power Apps - using title field from a sharepoint list

(0) Share

Report

Posted on by naijacoder

178

Hi All,
I'm just plugging along with powerapps and would like to show a multiple checkboxes using a title field from a sharepoint list.
I'm using a canvas app.
I have a list with title Animals
Dog
Cat

Tiger

I can list it as a dropdown or a radio button but not mutliselect checkboxes.
I don't want to have individual checkboxes for each as it is a long list?

Any ideas or resources is welcome

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

v-bofeng-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
HI @naijacoder :

Do you want to create multiple checkboxes at once based on the Animals list?

The point is to create a gallery .I’ve made a test for your reference:

1\My data source

2\Add a Blank vertical gallery(Gallery5) and set it’s items property to

Animals

3\Add a check box control(Checkbox1) into this gallery and set it’s Text property to

ThisItem.Title

4\ Add a data table control and set it’s items property to:

ShowColumns(AddColumns(Filter(Gallery5.AllItems,Checkbox1.Value),"Value",Checkbox1.Text),"Value")

The Result(the screenshot has been added as an attachment😞

1.gif

Best Regards,

Bof

Was this reply helpful? Yes No
naijacoder 178 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi v-bofeng-msft,
I can't get pass the below steps
4\ Add a data table control and set it’s items property to:

ShowColumns(AddColumns(Filter(Gallery5.AllItems,Checkbox1.Value),"Value",Checkbox1.Text),"Value")

There is no option "Alltems" for the Gallery5 property and also whats the "Value"
Can you please elaborate more on the item property for the data table control

Cheers

Was this reply helpful? Yes No
v-bofeng-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @naijacoder :

Q1:There is no option "Alltems" for the Gallery5 property

It's AllItems not Alltems.

I think this link will help you a lot:

Gallery control in canvas apps---Additional properties

Q2:whats the "Value"

"Value" is a column I created on the basis of the Gallery5.AllItems table through the AddColumns function. Its value is “Checkbox1.Text”.

I think this link will help you a lot:

AddColumns, DropColumns, RenameColumns, and ShowColumns functions in Power Apps

ShowColumns( AddColumns( Filter(Gallery5.AllItems,Checkbox1.Value),/*Filter out all selected items in the gallery*/ "Value",/*add a column named 'Value'*/ Checkbox1.Text ), "Value" /*Select Value from items*/ )

Best Regards,

Bof

Was this reply helpful? Yes No
naijacoder 178 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks alot will give that a shot

Was this reply helpful? Yes No
hemrhk 361 on at

Like
a
(0)

Report
Copy link

Link copied!

There is a way to achieve the multi-select check box option, follow the post to get an idea of how to implement.

https://365stack.in/index.php/2021/12/29/how-to-add-check-box-grouping-in-canvas-app/

Follow 365 Stack to get instant updates.

Was this reply helpful? Yes No