Filtering a gallery with a global variable

[tguihur]

Hi everyone,

I have a gallery which shows the name and the school number. I also have a global variable with the number of the school where the user works.  So I would like to show only the rows where those  school numbers match.

I thought use a Filter function in the property ITEMS of the gallery, however it does not work.

Filter(Declarations; variableCompanyNumber=Gallery2.Subtitle2)

Declarations is the name of  my the Sharepoint list data source.

What should I do? Thanks in advance

[eka24]

Consider this formula on the Items property of the Gallery;

Filter(Declarations,SchoolNumber column=variableCompanyNumber)

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[tguihur]

I tried it but it says :

Invalid argument type

[eka24]

Please show the formula for the variable in a screenshot

Also indicate the error message

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[v-yutliu-msft · Accepted solution]

Hi @tguihur ,

Could you tell me:
1)how do you set this variable variableCompanyNumber?
2)the data type of SchoolNumber column?

3)what does "Gallery2.Subtitle2" represent?

I assume that :

gallery2 is this gallery's name, Subtitle2 is the control that you use to display SchoolNumber column.

So do you want to filter list that SchoolNumber column=variablevalue and display in gallery2?

If so, you need to make sure the data type of SchoolNumber column and the variable is the same.

Please try this:

Filter(Declarations;Value(SchoolNumber column)=Value(variableCompanyNumber))

Best regards,