Combine two formulas in a gallery

(0) Share

Report

Posted on by dbatllevz

Hi all,

I have been developing some apps but now I having an issue in a gallery that I cannot solve

First I filtered a gallery related to table 1 by using a Dropdown, the formula works

If(Dropdown1.Selected.Result = "All";Table1;Filter(Table1;Column1= Dropdown1.Selected.Result))

Then I was asked to add a column from table 2 to the gallery, this formula also works

AddColumns(Table1;"ColumnXY";LookUp(Table2;ColumnX =Table1[@ColumnX];ColumnY))

Both formulas work perfectly separately however, now I want to put it together that I have the added column in the gallery but also I can filter it by using the dropdown

Does someone know how to combine both formulas?

Many thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @dbatllevz

With({tbl: AddColumns( Table1;"ColumnXY";LookUp( Table2;ColumnX =Table1[@ColumnX];ColumnY ) )} ); If( Dropdown1.Selected.Result = "All" ; tbl ; Filter( tbl;Column1= Dropdown1.Selected.Result ) )

Was this reply helpful? Yes No
dbatllevz 9 on at

Like (0)

Report
Copy link

Link copied!

Hi @Drrickryp , many thanks for your fast answer!

I tried as you mentioned:
With({tbl:AddColumns(Table1;"ColumnXY";LookUp(Table2;ColumnX=Table1[@ColumnX];ColumnY))});;If(Dropdown1.Selected.Result = "All";tbl;Table1;Filter(tbl;Table1;Column1= Dropdown1.Selected.Result))

Unfortunately is giving me "Invalid argument type" error

No clue what is wrong here, could you please help?

Was this reply helpful? Yes No
Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Your If() statement is not the same as the one I posted above.
If(Dropdown1.Selected.Result = "All";tbl;~~Table1~~;Filter(tbl;~~Table1;~~Column1= Dropdown1.Selected.Result))

Was this reply helpful? Yes No
dbatllevz 9 on at

Like (0)

Report
Copy link

Link copied!

Hi @Drrickryp many thanks for the remark, it works now!

I had to delete the ) after } and put it in the end:

With({tbl:AddColumns(Table1;"ColumnXY";LookUp(Table2;ColumnX=Table1[@ColumnX];ColumnY))});;If(Dropdown1.Selected.Result = "All";tbl;Filter(tbl;Column1= Dropdown1.Selected.Result)))

Was this reply helpful? Yes No