I'm creating an App for work that reads/updates information from a sharepoint list (on Office 365) call 'Staff Lunches' I want the BrowserGallery to filter by 'Staff_Name' so Staff members will only see their items when running the App.
When I set the Items property of the BrowserGallery to just the table name it displays all the items in 'Staff Lunches' -correct.
When I seach or filter the items such as Filter('Staff Lunches',User().FullName = Staff_Name) it doesn't return all of the expected items - see screen shot Missing an itemIf I change the filter to Filter('Staff Lunches',"Martin Fitzsimons" = Staff_Name) it displays the missing items
I've checked the items in the Staff_Name column to make sure it's correct and it is.
Any pointers on what I'm missing would be much appreciated.
Hey, thanks for the reply. Yes it is. Did try the set idea before and retried it but it only returns _UserName as blank. I've been told to shelve this project for now. So I won't be carrying on the Dev work. Thanks for your help though.