Unanswered

filtering gallery using global variable

(0) Share

Report

Posted on by powerW

I created a tabbed gallery and have a sharepoint list, Similar to the video https://www.youtube.com/watch?v=if_mFIfi5PM

I added a global variable on the home page, which I pass on to the tabbed gallery. I want the tabbed gallery to show records that match the global version number .

However I am not sure how to compare the value of the global variable against the table data that is loaded in the gallery.

Home page

I set the global variable and pass it on the different pages

Set(Gversion,Dropdownversion.SelectedText); Navigate(tdlcGenerator,ScreenTransition.None)

In my Questions gallery page, my gallery displays data

This works and shows all the data

SortByColumns(Filter('TQtable',qSearchText.Text in Question),"DisplayOrder",Ascending)

I tried the following so I can filter on the global version variable that I pass to this page , the following do not work. Note that I can see the value of the global variable

SortByColumns(Filter('TQtable',qSearchText.Text in Question,'TQtable'.tdlcVersion in Gversion.Value),"DisplayOrder",Ascending)

hard cording did not work either

If ('TQtable'.tdlcVersion in 4,SortByColumns(Filter('TQtable',qSearchText.Text in Question),"DisplayOrder",Ascending))

If ('TQtable'.tdlcVersion in Gversion.Value,SortByColumns(Filter('TQtable',qSearchText.Text in Question),"DisplayOrder",Ascending))

thanks and appreciate the help

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

LRVinNC 2,297 on at

Like (0)

Report
Copy link

Link copied!

I see a couple things.

First, on your hardcoded test, use = not in. If tdlcVersion is numeric, then testing for = 4 is fine. If it is a text value, you'll need to put the 4 in quotes (= "4").

If ('TQtable'.tdlcVersion = 4,SortByColumns(Filter('TQtable',qSearchText.Text in Question),"DisplayOrder",Ascending))

Then on your desired statement, you want to structure your query the same way using = rather than in. Also, when using a global variable, you don't need to use .Value, just use the name of the Global Variable.

SortByColumns(Filter('TQtable',qSearchText.Text in Question,'TQtable'.tdlcVersion = Gversion),"DisplayOrder",Ascending)

See if these get you farther.

Was this reply helpful? Yes No
powerW 6 on at

Like (0)

Report
Copy link

Link copied!

thanks for helping but I tried both the recommended options and it shows no data
I do have records with version 4

If ('TQtable'.tdlcVersion = 4,SortByColumns(Filter('TQtable',qSearchText.Text in Question),"DisplayOrder",Ascending))
or
SortByColumns(Filter('TQtable',qSearchText.Text in Question,'TQtable'.tdlcVersion = Gversion),"DisplayOrder",Ascending)

Was this reply helpful? Yes No
LRVinNC 2,297 on at

Like (0)

Report
Copy link

Link copied!

What is the data type of tdlcVersion?

Was this reply helpful? Yes No
powerW 6 on at

Like (0)

Report
Copy link

Link copied!

numeric

Was this reply helpful? Yes No
LRVinNC 2,297 on at

Like (0)

Report
Copy link

Link copied!

Try testing with this to see if it returns the right records.

SortByColumns(Filter('TQtable',qSearchText.Text in Question,'TQtable'.tdlcVersion = 4),"DisplayOrder",Ascending)

Was this reply helpful? Yes No
powerW 6 on at

Like (0)

Report
Copy link

Link copied!

no
I even added a new column to the table called tdlcversions and made it a data type

SortByColumns(Filter('TQtable',qSearchText.Text in Question,'TQtable'.tdlcVersions in "4"),"DisplayOrder",Ascending)

I was hoping this would display version 4

7 Views

Was this reply helpful? Yes No
LRVinNC 2,297 on at

Like (0)

Report
Copy link

Link copied!

Don't use "in" for your version comparison. Use =.

And you know the search text you are using exists for version 4, correct?

You may want to temporarily remove the search text portion of the filter so you are ONLY filtering on version to get that working right first and then add the search text portion back.

Simplify temporarily to just:
Filter('TQtable'.tdlcVersions = 4), if tdlcVersion is still numeric
or

Filter('TQtable'.tdlcVersions = "4"), if tdlcVersion is a text column

What is your data source? Sharepoint?

Was this reply helpful? Yes No