Power Platform Community Forum Thread Details

in my app, I have a dropdown box and a listbox. Both controls populate with many items.

I want be able to save the selection of items on both controls and the selection should be loaded at the apps start up. I can have an excel table to save the current selection of the two control.

looking for your suggestions to perform the action.

Categories:

Building Power Apps

First, create an Excel table (let's call it "SavedSelections") with these columns:

ControlName (Text)
SelectedItems (Text)

In your PowerApps, add an OnSelect property to both your dropdown and listbox to save selections:

For the Dropdown:

Patch(
    SavedSelections,
    LookUp(SavedSelections, ControlName = "Dropdown1"),
    {
        ControlName: "Dropdown1",
        SelectedItems: Dropdown1.Selected.Value
    }
)

For the Listbox (since it can have multiple selections):

Patch(
    SavedSelections,
    LookUp(SavedSelections, ControlName = "Listbox1"),
    {
        ControlName: "Listbox1",
        SelectedItems: Concat(Listbox1.SelectedItems, Value, ",")
    }
)

To load the saved selections when the app starts, add this to your Screen's OnVisible property:

UpdateContext({
    savedDropdownValue: LookUp(SavedSelections, ControlName = "Dropdown1").SelectedItems,
    savedListboxValues: Split(LookUp(SavedSelections, ControlName = "Listbox1").SelectedItems, ",")
});

Set(
    Dropdown1.Selected,
    First(Filter(Dropdown1.Items, Value = savedDropdownValue))
);

Set(
    Listbox1.Selected,
    Filter(Listbox1.Items, Value in savedListboxValues)
)

Make sure to initialize the Excel table with at least one row for each control: