Answered

People Picker Filter Behavior

(0) Share

Report

Posted on by HeyDave

Hi Teams. I have an interesting behavior that hopefully you can help me with. I have a sharepoint list of applications with the owner as a people field. My canvas app has two filter headers, one the app name, the other a people picker. Using this filter method with a Text Input for the people filter:

ClearCollect(colGridData,Filter('Application List', StartsWith('Owner'.DisplayName, TextInputOwner.Text) && (IsBlank(AppNameSearch.Text) || IsEmpty(AppNameSearch.Text) || StartsWith('App Name',AppNameSearch.Text))));

The app filter does sort the gallery when clicking outside the input field - as expected.

The Owner text field, does not filter on clicking outside the search box - but does filter properly when triggering a button to Load Data.

I'm puzzled why one search box works when exiting (auto loading the data) and the other does not. Any thoughts? I'm definitely struggling with the people picker.

Categories:

General Questions

All responses (2)

Answers (2)

Verified answer

HeyDave 15 on at

Like (1)

Report

Re: People Picker Filter Behavior

Thanks Randy. This helped me see the error in my ways & got me up and running.
Verified answer

RandyHayes 76,287 Super User 2024 Season 1 on at

Like (0)

Report
Re: People Picker Filter Behavior

@HeyDave

This is because you are using these in behavioral actions. You are better off if you want immediate results to skip duplicating all your data into app memory with a collection.

Just set your Items property to:

Filter('Application List', StartsWith('Owner'.DisplayName, TextInputOwner.Text) && (IsBlank(AppNameSearch.Text) || StartsWith('App Name',AppNameSearch.Text)) )

Also, don't use IsEmpty on a text value...IsEmpty is for records.

I hope this is helpful for you.