Unanswered

SharePoint List Filter People and Group Field

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi,

I am filtering on a People and Group field. The filter is following some of the posted examples using the SPFieldName.Email = User().Email . The filter seems to be applied but I am gettign the following warning. I only have a few test records in the list.

"Suggestion: Part of this Filter formula cannot be evaluated remotely due to service limitations. The local evaluations may produce suboptimal or partial results. If possible please simplify this formula..."

Is this being caused by the fact that the People and Group field is a lookup field and will cause issue because it is not delegable?

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

v-monli-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous,

Is the SPFieldName the column name of this People/Group column? Can you please show the complete formula?

Regards,

Mona
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

In the solution I was building I worked around the issue by just using a text field in Sharepoint. The solution didn't require the People and Group Field.

After doing this I got the same error. To work around it I created a hidden text box "UserFilter" and set the value to User().FullName. My intent is taht the field in the Sharepoint list would always be created from this value from and edit form in powerapps. So I then filtered the gallery "=UserFilter.Text"

The may also work for the People and Group Field. I didn't go back and test it.
Daniel_Pipe 57 on at

Like
a
(0)

Report
Copy link

Link copied!

@Anonymous wrote:

The may also work for the People and Group Field. I didn't go back and test it.

You can filter by a people column so long as allow multiple selections is turned off. For example
SortByColumns(Filter(Participants, Team.DisplayName = User().FullName ), "Surname", If(SortDescending1, Descending, Ascending))

It seems the only option for multiple selections in a column would be to manually type names in a plain text/string column then filter the gallery with the search expression. Pretty sucky!