Answered

Display Collection in Gallery

(0) Share

Report

Posted on by lunalovegood

215

Hello!
I have combobox [ComboBox1_1] and the item properties is
Distinct(SourceName,CollectionName)
but in the Gallery how do I modify the filter function?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @lunalovegood ,

Could you please post the formula in Text? So I can modify it more easily rather than hand typing words by words.

Best regards,

Was this reply helpful? Yes No
lunalovegood 215 on at

Like
a
(0)

Report
Copy link

Link copied!
Here you go
Filter( [@'HEO Lesson Learn'], IsBlank(ComboBox1.SelectedItems) || IsEmpty(ComboBox1.SelectedItems) || 'Action Party' in ComboBox1.SelectedItems.Value, IsBlank(ComboBox.SelectedItems) || IsEmpty(ComboBox.SelectedItems) || 'Project Name'in ComboBox.SelectedItems.Value, IsBlank(ComboBox1_1.SelectedItems) || IsEmpty(ComboBox1_1.SelectedItems) || LLCollect in ComboBox1_1.SelectedItems.Value )

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @lunalovegood ,

What is the LLCollect collection? In addition, The formula Distinct(SourceName,CollectionName) makes no sense, and it should be Distinct(SourceName,CollumnName)

Best regards,

Was this reply helpful? Yes No
lunalovegood 215 on at

Like
a
(0)

Report
Copy link

Link copied!

my intention was to enable the search function in combobox to search all across column in my list, thus i created the collection based on my list [to grouped all my columns in the collection], so when user enter search term in combobox , the application will be able to display result that is based on all columns in my list .

for example
user insert "Planning Schedule Delay" then the application can display rows that is related to the inserted search term

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @lunalovegood ,

This is not possible in PowerApps, column names in Filter function should be static texts. To explain it more specifically, if you need to filter on dynamic columns, you will have to use formula as follows:

Switch( SearchColumnNameVariable, "Column1" Filter(DataSource, Column1 = "abc"), "Column2" Filter(DataSource, Column2 = "abc"), "Column3" Filter(DataSource, Column3 = "abc"), ... )

You can not use dynamic column name as below:

Filter(DataSource, ColumnNameVariable = "abc"),

Best regards,

Was this reply helpful? Yes No
lunalovegood 215 on at

Like
a
(0)

Report
Copy link

Link copied!

thank you @v-jefferni ,i completely understood

Was this reply helpful? Yes No