Answered

Dropdown Selected Text Filter

(1) Share

Report

Posted on by CU10101436-0

Hello,

I am new to Power Apps and I am trying to create a page where a Dropdown will filter values based on rows in a SharePoint List.

This is the UI. Each item that has a check box is linked to a SharePoint List column value and each column is set to Boolean. I have rows in the List that are employee names and a random ID number. As an Employee is brought on to the team, they need to have a knowledge check that is validated by a Supervisor. I would like the Default values of each check box to reflect the check value in the SharePoint List, but filtered by each employee from the Dropdown selector. I would also like the OnCheck and OnUncheck to update the values in the SharePoint List based on the employee name selected in the Dropdown selector.

Here is my SharePoint List:

So far, I have used these formulas. They only change the values in the List for the first employee listed, no matter if the change is made under a different employee name in the Dropdown selector.

Default

If
(
    Dropdown1.Selected.DisplayName = ThisItem.EmployeeName, ThisItem.ADP
)
 
OnCheck
If(
    Dropdown1.SelectedText.DisplayName = ThisItem.EmployeeName,
    UpdateIf(
        'New Hire Tracker.TaskTracker',
        Dropdown1.SelectedText.DisplayName = ThisItem.EmployeeName,
        {ADP: true}
    )
)
OnUncheck
If(
    Dropdown1.SelectedText.DisplayName = ThisItem.EmployeeName,
    UpdateIf(
        'New Hire Tracker.TaskTracker',
        Dropdown1.SelectedText.DisplayName = ThisItem.EmployeeName,
        {ADP: false}
    )
)
 
Is it possible to use the Dropdown1 to change the values that are displayed in the Default state of the checkbox based on what is in the SharePoint List? And is is it possible
to change the values of the SharePoint list by employee name using the Dropdown1?

Categories:

Using Apps Using Formulas

General Questions

All responses (2)

Answers (1)

CU10101436-0 4 on at

Like (0)

Report

Dropdown Selected Text Filter

@FLMike, this is a way to make the changes to the form, but it wouldn't allow the supervisor to see if the "topic" has been validated already in a previous meeting. They wouldn't be checked all in one sitting. Using the form wouldn't show the state of the check boxes before submitting would it?
Verified answer

Michael E. Gernaey 40,272 Super User 2025 Season 1 on at

Like (0)

Report
Dropdown Selected Text Filter

Hi,

So let's discuss how you would do what you want. What you need is a way to bind all the values, based on what is in the Selected Dropdown1 (your employee)

I recommend that you use a Form. You can use a Gallery, but it requires a tiny tweek.

Also, while it is certainly ok to update the backend on every "OnChange" (regardless of whether its a check or not), take into account the traffic it creates, versus having the supervisor simply hitting a Save button. It's much easier to debug and have less chance of failures and problems doing a single patch versus after each change.

Your drop down should be outside the Form, because it drives the checkboxes.

We will use the dropdown1 to set the Item property of the Form, which in turn sets all the checkboxes.

Since this is a Form, it will automatically bind and create the associations of the checkboxes to the back end.

Form Item Property Code below

LookUp('New Hire Tracker.TaskTracker', EmployeeName = Dropdown1.SelectedText.DisplayName)

Now, your defaults for your CheckBox will be

ThisItem.ColumnName

Now I recommend, outside of the Form, you have a button, it would be your Save button.

In this way, your OnCheck and UnCheck do not have code.

In your Save Button, you only have to put the following code.

FormName.Submit() and it will patch the back end

So it looks like this.

Let me know if you have anu questions