cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jackwu
Frequent Visitor

Filter the multi selected choice as per SharePoint checkbox

Hi , 

 

I have two SharePoint list , 1 is the database , 1 is the basic request information. 

 

In the database , I have an ID column and a checkbox (multi choice). 

 

Sample IDCheckbox
001A,B,C
002A,B

 

in the basic request list , I have request ID, Sample ID and Checkbox (single choice).

Request IDSample IDCheckbox
   

 

I want to create an apps to fill in the request form. I'm currently setting items as  'Choices([@'database'].checkbox)' to display all the choice from checkbox column. 

 

What I want in the future is : 

When I input the sample ID "001", the choice will only have "A", "B" , "C" to let user select one of them. 

When I input the sample ID "002", the choice will only have "A", "B" to let user select one of them. 

 

is it possible in POWERAPPS? 

 

Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions

@v-bofeng-msft , 

 

I didn't achieve that as your way.

As a workaround , I set the the defaultselecteditems as 

LookUp('List1','Sample ID'=DataCardValue7.Text,checkbox)

And I set the items as 

Choices([@'database'].checkbox)

 

And then I let user to delete what they don't want. 

1.png

 

Thanks!

View solution in original post

4 REPLIES 4
v-bofeng-msft
Community Support
Community Support

Hi @jackwu :

The demand you said is achievable,I'v made a test for your reference:

my data source:

list1:

Column (click to edit) Type

TitleSingle line of text
Sample IDSingle line of text
CheckboxChoice

1.JPG

list2:

Column (click to edit) Type

TitleSingle line of text
Request IDSingle line of text
Sample IDSingle line of text
CheckboxChoice

1\Add a new form

DefaultMode:

 

FormMode.New

 

DataSource:
List2

2\Set the combo control's Items proeprty to :

 

LookUp('List1','Sample ID'=DataCardValue7.Text).Checkbox

 

2.JPG

34.gif

Best Regards,

Bof

@v-bofeng-msft , 

 

Seems the '.checkbox' was not recognized. The structure is exactly same with yours. 

 

1.png

 

Thanks!

Hi @jackwu :

Please confirm this "CheckBox" field allow multiple selections.

Best Regards,

Bof

@v-bofeng-msft , 

 

I didn't achieve that as your way.

As a workaround , I set the the defaultselecteditems as 

LookUp('List1','Sample ID'=DataCardValue7.Text,checkbox)

And I set the items as 

Choices([@'database'].checkbox)

 

And then I let user to delete what they don't want. 

1.png

 

Thanks!

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (71,104)