Filtering a gallery based on a selection from a data table

(0) Share

Report

Posted on by CarlHRVA

601

Hello,

I've created a collection at the start of my app, ran a simple calculation to determine a total balance per customer and I'm using a fly-out menu in one of my galleries to display this information in descending order. I'd like to be able to allow users to filter the gallery based on the customer name that they selected from within the data table but when I try I get an "Invalid argument type" error for the equal sign. My current formula is set to the OnSelect property of the data table as follows:

Filter(ManaguerUIGallery.AllItems, 'CUSTOMER NAME'='Customer Name')

As always, thanks for any and all help.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hello @CarlHRVA,

I guess you are using a SharePoint list as your datasource? Is it a dropdown with the customer name? I think that would be a good solution. You then need a collumn in your list with the different names.
Then you add a dropdown to the screen with this formula in the Items value "MyList.Customernames", then its easy to filter the gallery based on the dropdown. The formula on Items for the gallery is "Filter(MyList, CustomerName = DropDown1.Selected.Value).

I also think your problem may be in using wrong quotes. Try to use " instead of ' after the equal sign.

Was this reply helpful? Yes No
CarlHRVA 601 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the quick reply! As far as your solution goes, I have a different pop-out where they can filter the gallery based on different dropdowns. The aggregate data for the total amount owed per customer doesn't exist in the data source so I pull it into a collection on load, group by customer name and then find the sum of all their balances and display them in a data table in descending order for them. This helps them to determine which customers to contact first in their collection efforts. I would like for them to be able to click any customer in that data table and have it sort the gallery where the customer name in the data table matches the customer name in the gallery. So I was able to get the error to go away by switching the formula to the following.

Filter(ManagerUIGallery.AllItems, "CUSTOMER_x0020_NAME"='CUSTOMER NAME')

But unfortunately, nothing happens to the gallery OnSelect. I'm hoping I'm using the right fields here, but maybe that was always the problem?

Was this reply helpful? Yes No
v-yutliu-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @CarlHRVA ,

Do you want to filter a gllery based on the selection of a data table?

If so, please try this formula: (set the gallery's Items)

Filter(tablename, 'CUSTOMER_x0020_NAME'=DataTable1.Selected.'CUSTOMER NAME')

Since ManagerUIGallery.AllItems can not represent a data source, you can not filter a gallery's Items based on the items in the gallery.

It is a kind of circulation.

And your collection is the aggregate data, so I suggest you filter the data source directly.

What's more, you can not compare two column directly like your formula:"CUSTOMER_x0020_NAME"='CUSTOMER NAME'.

You need to compare one column with a value. DataTable1.Selected.'CUSTOMER NAME' represents the customer name that you select in the datatable.

Best regards,

Was this reply helpful? Yes No