Unanswered

PowerApps - working with dropdown and checkbox

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I have a quick problem when working with Powerapps. I’m trying to show the job related to the code, but it doesn't seems to work.

The idea is when the code is selected (in the dropdown), the checkbox must be automatically filled with de jobs related to the code. Most of the time, there is 1 job linked to 1 code, but sometimes there are more jobs linked to it. I tried to use the LookUp and Filter command, but it seems not to work.

I will give an example of how I wrote the code down:

The name of my SharePoint list is TEST.

Filter(TEST; dropdownCode.Selected in (Job))
Filter(TEST; Test.Job = dropdownCode.Selected)
Lookup(TEST; dropdownCode.Selected = Job)

Screenshot 2022-04-02 at 17.51.05.png

Screenshot 2022-04-02 at 15.58.09.png

Thanks for your help guys 🙂

Categories:

Power Apps Pro Dev & ISV

I have the same question (0)

All responses (3)

Answers (0)

cchannon 4,702 Moderator on at

Like (0)

Report
Looks like you're incredibly close there, just evaluating the wrong column in your filter criteria.

Filter takes two input arguments: the table you are filtering and the expression to evaluate on each row. It returns a filtered table, which you can then further manipulate as needed (in your case, by selecting the first row and the specific column you want on that row).

Try something like this (I am doing this just in my head, so syntax might not be perfect):

First(Filter(TEST,Code=dropdownCode.Selected).Job

It won't split Job on the commas--you'll have to do that yourself--but it will give you exactly one row and only the Job value from that row.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com on at

Like (0)

Report
Hi @Anonymous,

Could you please tell me that:

1). if the Code is a Choice or a Text

2). if the Job is a Choice or a Text

3). how you set the Items property of the Code dropdown

If the Code column is Text and the Job column is Choice allowing multi select, please set the Default property of each Checkbox as below:

If(Self.Text in Concat(Ungroup(Filter(ScoreList,Code=ComboBox_Code.Selected.Code).Job,"Job"),Value,","),true,false)

Note that I have set the ComboBox_Code as ListName.Code

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report
Hi @v-qiaqi-msft,

Thanks for your answer!

Well, both are choices. The different SharePoint lists are linked with a unique Code and a unique ObjectID. The idea is to show only the Jobs related to the selected Code in different checkboxes. I drew a sketch to show you how they are actually linked.

In bold: different SharePoint list;
Code, ObjectID, Jobs are columns in the SharePoint list;
To retrieve all the data in de dropdown I used this: TEST.Code

Best regards,
Mimii

Was this reply helpful? Yes No