I've been creating a PowerApp that is connected to a SharePoint list for the data and I'm having some trouble finding the right magic to filter the list the way the users want.
The current Date/Items code is: SortByColumns(Filter(SOGI, StartsWith(ComplianceAssetId, TextSearchBox1.Text)), "ComplianceAssetId", If(SortDescending1, Descending, Ascending))
I've Googled and Binged for filtering techniques and I've tried a few of them with no luck.
This SharePoint list contains 4 People Picker columns:
When my users are viewing the list in the PowerApp, they only want to see items where they are listed in any of these 4 columns.
I tried several samples and none of them worked, even just for the Created field. I must be doing something wrong with the formula. Can anyone help? Thanks so much!
If you want the user to see only when one of the 4 people field column contains them you can use a function similar to this.
First in the Screen.OnStart or Screen.OnVisible put this formula
Set( _UserProfile, User() )
Now in Gallery.Items put this formula:
Filter( SOGI, Author.Email = _UserProfile.Email || DO%5Fx0020%5FSubmitted%5Fx0020%5FFor = _UserProfile.Email ||
Prospect%5Fx0020%5FManager = _UserProfile.Email ||
Constituent%5Fx0020%5FDevelopment%5Fx0 = _UserProfile.Email )
Column Created is a date column not a person. Author in PowerApps is the same as Created By column in SharePoint List. Also I assume that for example DO%5Fx0020%5FSubmitted%5Fx0020%5FFor is the column name in PowerApps?
Thanks so much for the information. Yeah, I meant Created By.
So I think that I plugged in the values correctly, however it still does not render the list items as one would think.
It seems to not like "Email" after Author or any of the = signs. Perhaps it is just bad luck day 😞
Undoing the change and putting it back makes the list work again, but it is not filtered.
That should be related to delegation.
Currenlty the Lookup type from SharePoint list is not supported for delegation.
There are threads talking about this.
And we have collected this as a feedback.
For more information about delegation, please check: