Filter & Add columns in the same gallery

(0) Share

Report

Posted on by Tango

1,168

Hi,

I have a gallery that I would like to add another column. This extra column (colC) just needs to be in all results and will not be filtered against.

I also have 1 search box that filters against colA and 1 search box that filters against colB. Both colA & colB are text and can also be blank (meaning all records would be returned in the gallery.

Cant quite nail the formatting for the Filter & AddColumns functions and would appreciate any assistance.

Thank you

Categories:

Building Power Apps

All responses (5)

Answers (0)

Sort by

timl 37,287 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
@Tango

This is the type of structure you would use to combine Filter and AddColumns:

AddColumns( Filter( YourDataSource, If( IsBlank(txtSearchA.Text), true, ColA = txtSearchA.Text ), If( IsBlank(txtSearchB.Text), true, ColB = txtSearchB.Text ), "ColC", "YourExpressionForColC" )
Tango 1,168 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks for your response @timl but im getting an error on line 1 next to the ( on Add Columns that says "received 1 but expected 3 or more"

Just a reminder that Im just trying to add the Account Rating column that happens to be a picklist to the Contact Accounts datasource by joining 'Contact Accounts' RefAccount: ID (account id is a lookup column in Sharepoint list)

in addition my filters use the in statement not =

this is my attempt (the add columns is working)

AddColumns(
Filter(
'Contact Accounts',
If(
IsBlank(txtinpContactAccountsContactSearch.Text),
true,
RefContact.Value = txtinpContactAccountsContactSearch.Text
),
If(
IsBlank(txtinpContactAccountsAccountSearch.Text),
true,
RefAccount.Value = txtinpContactAccountsAccountSearch.Text
),
"lu Account Rating",
LookUp(
Accounts,
ID = 'Contact Accounts'[@'RefAccount: ID'].Id,'Account Rating'
)
Tango 1,168 on at

Like
a
(0)

Report
Copy link

Link copied!

this works
Filter(
'Contact Accounts',
txtinpContactAccountsContactSearch.Text in RefContact.Value,
txtinpContactAccountsAccountSearch.Text in RefAccount.Value)

and this also works separately
AddColumns(
'Contact Accounts',
"lu Account Rating",
LookUp(
Accounts,
ID = 'Contact Accounts'[@'RefAccount: ID'].Id,'Account Rating')
)
Just need to add them together
Drrickryp Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Tango

With({fltrd:Filter( 'Contact Accounts',txtinpContactAccountsContactSearch.Text in RefContact.Value, txtinpContactAccountsAccountSearch.Text in RefAccount.Value ) }, AddColumns( fltrd,"lu Account Rating",LookUp( Accounts,ID = 'Contact Accounts'[@'RefAccount: ID'].Id,'Account Rating' ) ) )
Tango 1,168 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for your message @Drrickryp

not returning any results before typing in either field (this also needs to happen) and have a squiggly lines over a couple of spots.

i need to return all results before typing in either (or 1) of the search inputs
Thanks in advance