Asset Management App

(0) Share

Report

Posted on by Omar_203

Hello PowerApps Community,

I have a Gallery of Multiple Sharepoint lists combined using a Collection called Assets.

To display the results, I am using a button "Show results" and using the following code:

ClearCollect(Assets, HardwareList, SoftwareList, AccountList)

I also have a combo box dropdown that gets its values from another SharePoint list called users using the following code:

Choices(Users.'Full name')

How can I filter assets in the gallery (combined collection) to only a specific person's name selected in the dropdown combo box ?

Thank you.

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report
Hi @Omar_203 ,

Set the Items property of your gallery to:

Filter(Assets, User = YourUserComboBox.Selected.Value)

Was this reply helpful? Yes No
Omar_203 43 on at

Like (0)

Report

Is User supposed to be a variable or my SharePoint list called Users ?

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Omar_203,

In my example User is the name of the column in your Asset list that links assets to users.

Was this reply helpful? Yes No
Omar_203 43 on at

Like (0)

Report

Assets is a collection of 3 lists.

Was this reply helpful? Yes No
BCBuizer 22,505 Super User 2025 Season 2 on at

Like (1)

Report

Hi @Omar_203 ,

I assumed you have a column in your Assets collection that assigns an item to a person, which I referred to as the 'User' column. In the code I posted, the values of this column are compared against the selected user in the ComboBox (Choices(Users.'Full name') to filter the items.

If my assumption is right, all you have to do to make the code work is to replace 'User' with the right column name and replace 'YourComboBox' with the name of the control you use to select the user.

There is another assumption in there, which is that the 'User' column is a text type and has the 'Full Name' type values that correspond with Users.'Full name'.

Please let me know if my assumptions are correct and if not, how things are actually built?

Was this reply helpful? Yes No
Omar_203 43 on at

Like (0)

Report

Hello,

Yes this did help, I was able to get it working, using the following code:

Filter(Assets,CurrentOwner.DisplayName=ComboBox1.Selected.Value)

This now filters items in the collection Assets (which contains 3 sharepoint lists) and displays it on a seperate screen.

Was this reply helpful? Yes No
Omar_203 43 on at

Like (0)

Report

@BCBuizer I was wondering if you know of a simple way to create a filter of a choice field for hardware assets to search in a text box by name. My thought here was that I have to convert the choice items to a text string and then filter it in the gallery ?

Any suggestions would be greatly appreciated.

Thanks.

Omar

Was this reply helpful? Yes No
Verified answer

BCBuizer 22,505 Super User 2025 Season 2 on at

Like (0)

Report
Hi @Omar_203 ,

No need to convert anything as you can also filter the choice values directly. It will look something like this:

Filter(Choices(Assets.Hardware),Value = SearchTextInput.Text)

Was this reply helpful? Yes No
Omar_203 43 on at

Like (0)

Report

Hi @BCBuizer ,
Ok, I gave that a shot, although I want to be able to type the name of the asset and filter while typing it doesn't come
up, unless I hit enter and doesn't display the proper information.
I want to be able to use 'StartsWith' function to filter as I type and type the letter of the asset name to see the results.

So currently, I have the following filters:

(Filter('Hardware Asset List',StartsWith('Current Owner'.DisplayName, TextSearchBox1.Text) || StartsWith(Title,TextSearchBox1.Text)) This works fine to filter by Title and user. Although I want to add a third filter to search by asset name (a choice field "dropdown" on SharePoint Lists. I have tried using the following combined:

(Filter('Hardware Asset List',StartsWith('Current Owner'.DisplayName, TextSearchBox1.Text) || StartsWith(Title,TextSearchBox1.Text)) || StartsWith(Choices('Hardware Asset List'.'Asset name'),Value=TextSearchBox1.Text)).

Although, this has not worked, any help would be appreciated.

Thanks.

Was this reply helpful? Yes No
Omar_203 43 on at

Like (0)

Report

Hi @BCBuizer,

I was wondering if it's possible to use only a PowerApps text label to display information from SharePoint lists instead of using a gallery. I would like to build a one page summary overview to allow a user to select their name from a dropdown and display all of their asset information (hardware, software, accounts etc.) ?

Was this reply helpful? Yes No