Unanswered

Filter and Search issues

(0) Share

Report

Posted on by Martin_Fitz

Hello,

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Very strange behavior.
Might be related to User() function but it is a longshot.
Try to do the following in your first Screen1.OnStart add this function (or add this to the screen where you show the gallery in the OnVisible property)

Set( _UserName, User().FullName )
Now in your Gallery.Item function put this:
Filter('Staff Lunches',_UserName = Staff_Name)
Allso Check if in a label.Text User().FullName gves exactly the same result as "Martin Fitzsimons"

Was this reply helpful? Yes No
Martin_Fitz 2 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No