Answered

Filter gallery

(0) Share

Report

Posted on by Rohit-Ghare

Hello there, user. I want to filter my gallery; the data type is all text, but when I filter, it only shows the first value; the values begin with 1. assets, 1.1 hardware, and so on; I've provided the syntax; can someone tell me what's wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Sort by

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Rohit-Ghare ,

Please format the formula text on formula bar then paste the formula here in Text, otherwise it's difficult for us to modify it for you.

Best regards,

Was this reply helpful? Yes No
Rohit-Ghare 28 on at

Like
a
(0)

Report
Copy link

Link copied!

Filter('Accounting Data',StartsWith('Account Code',Lower(TextInput1.Text)),StartsWith('Account Name',Lower(TextInput5.Text)),StartsWith('Account Description',Lower(TextInput6.Text)),StartsWith('Account Type',Lower(TextInput7_1.Text)),StartsWith('Aggr_ Level 1 ',Lower(TextInput7.Text)),StartsWith('Aggr_ Level 2',Lower(TextInput8.Text)),StartsWith('Aggr_ Level 3',Lower(TextInput8_1.Text)),StartsWith('Aggr_ Level 4',Lower(TextInput8_2.Text)),StartsWith('Aggr_ Level 5',Lower(TextInput8_6.Text)),StartsWith(UD1,Lower(TextInput8_7.Text)),StartsWith(UD2,Lower(TextInput8_8.Text)),StartsWith(UD3,Lower(TextInput8_11.Text)),StartsWith('Number of Documents attached',Lower(TextInput8_15.Text)))

Was this reply helpful? Yes No
Rohit-Ghare 28 on at

Like
a
(0)

Report
Copy link

Link copied!

this is my gallery

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

Like
a
(0)

Report
Copy link

Link copied!

Hi @Rohit-Ghare ,

Could you please give an example that it only returns the first item in Gallery when you filter the data? A screenshot is enough.

Best regards,

Was this reply helpful? Yes No
Rohit-Ghare 28 on at

Like
a
(0)

Report
Copy link

Link copied!

sure here it is

Was this reply helpful? Yes No
Rohit-Ghare 28 on at

Like
a
(0)

Report
Copy link

Link copied!

in the account type, column the column value consists of only text values like bs, and is it works fine on that column in the account name, and description the values start from 1. assets so if i search 1.1 ,1.1.1 it is not showing any value

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

Like
a
(0)

Report
Copy link

Link copied!
Hi @Rohit-Ghare ,

It seems in your list these values begin with one or more spaces according to different levels. However, when you type 1 in search box, those items with " 1.1" or " 1.1.1" will not return.

If the list won't exceed 2000 items, you can use Trim function for the column names:

Filter( 'Accounting Data', StartsWith('Account Code',Lower(TextInput1.Text)), StartsWith(Trim('Account Name'),Lower(TextInput5.Text)), StartsWith(Trim('Account Description'),Lower(TextInput6.Text)), StartsWith('Account Type',Lower(TextInput7_1.Text)), StartsWith(Trim('Aggr_ Level 1 '),Lower(TextInput7.Text)), StartsWith(Trim('Aggr_ Level 2'),Lower(TextInput8.Text)), StartsWith(Trim('Aggr_ Level 3'),Lower(TextInput8_1.Text)), StartsWith(Trim('Aggr_ Level 4'),Lower(TextInput8_2.Text)), StartsWith(Trim('Aggr_ Level 5'),Lower(TextInput8_6.Text)), StartsWith(UD1,Lower(TextInput8_7.Text)), StartsWith(UD2,Lower(TextInput8_8.Text)), StartsWith(UD3,Lower(TextInput8_11.Text)), StartsWith('Number of Documents attached',Lower(TextInput8_15.Text)) )

Best regards,

Was this reply helpful? Yes No
Rohit-Ghare 28 on at

Like
a
(0)

Report
Copy link

Link copied!

only this two values are visible rest are not

Was this reply helpful? Yes No
Rohit-Ghare 28 on at

Like
a
(0)

Report
Copy link

Link copied!

and if i used trim on account code this much values are visible

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @Rohit-Ghare ,

How many items are there in the list? 2000 is the maximum number, default is 500, you can change it to 2000 first in Settings.

If more than 2000 items will be there in the list, you'd better remove those spaces from these columns, otherwise delegation issue will remain.

Best regards,

Was this reply helpful? Yes No