Gallery search is not showing all items

[abdelrahmanHon]

Hello Everyone ,

i have an app. for task management, with login page to add User Email and Pass. then i created Global Variable (CC) to catch the username for login and to filter the next screen Gallery by that logged user . and it works fine !. however it didn't get all the related records for that user , keep in mind that all the records about 1000 record or less . 

it just gives me one type of records with specific status only ex( Task completed ) , but there are other status for that user like (Not completed , postponed,..etc) .

this is the code that i added in the galley search 

Search (Table2,CC,"Email") . where CC is the variable for the Email . Table2 is the Data Source , Email is the column name that i am doing this filter on it . 

is there any one can help me in that please !

[poweractivate]

Filter(Table2,Email=CC)

[abdelrahmanHon]

Thanks @poweractivate : but it gives me the same status Only ( Completed) . keep in mind that the data source is Excel sheet shared in Sharepoint site . 

[poweractivate]

@abdelrahmanHon 

If you put just this for the Items property of Gallery , are the results any different?

Table2

 I mean, do you still see just one kind of task even with the above?

[abdelrahmanHon]

this should come with all logged used Task status not only completed 

[abdelrahmanHon]

Yes , it gives me all task types when i use Table2 only without filtering 

[poweractivate]

@abdelrahmanHon 

If what you are getting even with

Table2

 for the Items property of Gallery 

then the issue is you just don't have anything else in the data source.

You have to check the data source and how you created it, there's not really much adjustment to the formula that can help then.

[poweractivate]

@abdelrahmanHon 

Ok so it gives you all the task types as long as you don't filter it.

Just to make sure it is not a delegation issue, try these steps below and then the Filter again

1. Go to Settings

2. Scroll down to Data row limit and lower it to 1

If that is the issue, you can repeat above 2 steps, raise it to the max of 2000, and get away with the formula as you have it for now until you get close to 2000 records.

[abdelrahmanHon]

i checked this with Table2 only , and it gives me all user records including all task types , 

but when i use that filter ** Filter(Table2,Email=CC) ** it gives me Completed only !!

[poweractivate]

@abdelrahmanHon 

What if you lower the data row limit to 1 and then use the Filter - do you get only 1 record?