How to filter a galery by an other galery using a variable?

(1) Share

Report

Posted on by 465132

Hi everyone,

I have two galeries each using a sharepointlist for its data.

gallery gallery

The left gallery takes data from here

sharepointlist

I tried the same list in two different variations (Text vs Boolean) for the right galery.

sharepointlist

I want to click on an item in the left galery to filter the right galery.

At the moment I am able to filter the right galery manualy : Filter(Anzeige; 'Preisänderungen' = true)

I set a global variable(onSelect left galery:Set(var1;GallerySzenarien.Selected.Titel)) to replace the "column to filter".

I tried to filter with var1 Filter(Anzeige; var1 = true)

Filter() seems not to work with var1 as an argument. I get the error: A text can not be compared to a boolean.

What should I do? Thanks in advance

Edit: The rows of the first list are the columnames of the second.

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Sort by

KeithAtherton 3,709 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @465132,

Which data type are you using for columns such as neuer Hersteller, etc?

For example, Text, Yes/No (or Ja/Nein), etc:

Also, does the filter work using a text comparison like this?:

Filter(Anzeige; var1 = "Ja")

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No
465132 77 on at

Like (1)

Report
Copy link

Link copied!
Hi KeithAtherton,

I tried both the Text and Yes/No data type.
In Anzeige the data type is Yes/No.
I made copy of Anzeige and named it Anzeige2. Anzeige2 is using the text data type.

There is no error after with
Filter(Anzeige; var1 = "Ja")
But it does not find a matching dataset.

Same for Anzeige2.

Was this reply helpful? Yes No
KeithAtherton 3,709 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

If you select var1 in the formula bar, what is the value please?

Also, can you select Anzeige and Anzeige2 to view the data (without filter applied) and share the screenshots please?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No
465132 77 on at

Like (1)

Report
Copy link

Link copied!

The Value is "Kundenbindung" because it is the last selected element. It changes to the title of the elements.

Was this reply helpful? Yes No
KeithAtherton 3,709 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Thanks. If you open the formula bar and select Anzeige (and Anzeige2), there will be a dropdown to display the data in the collection like this:

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No
465132 77 on at

Like (1)

Report
Copy link

Link copied!

Yes that is right

Was this reply helpful? Yes No
Verified answer

KeithAtherton 3,709 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Thanks. I see, so this hard-coded code works:

Filter(Anzeige; 'Preisänderungen' = true)

But this code does not - looks like a collection column name cannot be swapped with a hard-coded text value:

Filter(Anzeige; var1 = true)

An alternative approach could be using code similar to this for the right gallery data source Items property, if this level of hard-coding is acceptable:

Switch(var1, "neuer Hersteller", Filter(Anzeige, 'neuer Hersteller'), "neues Produkt", Filter(Anzeige, 'neues Produkt'), // etc )

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No
465132 77 on at

Like (1)

Report
Copy link

Link copied!

Thanks a lot! Now it works fine.

Was this reply helpful? Yes No
KeithAtherton 3,709 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Great news! My pleasure. Thanks for the update.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Follow me online.

Was this reply helpful? Yes No