ClearCollect peoplepicker doenst work well

(0) Share

Report

Posted on by WackdeMack

197

Hi all,

I use the clearcollect function to make my dropdown filters in a gallery. This works fine for my choice fields but with the people picker or created by column not. Here is my standard code

ClearCollect(
 colStatus;
 ""
);;
Collect(
 colStatus;
 Choices(Testproject.Status)
);;
ClearCollect(
 colTeacher;
 ""
);;
Collect(
 colTeacher;
 Choices(Testproject.'Created by')
)

After this, i got two collections but the created by is filled with one user, "Everyone except external users", that doenst make any sence to me? When i try an people picker column, the collection stays empty.

In the Gallery i use this code:

Filter(
 Testproject;
 Status.Value = drpStatus.Selected.Value || If(
 IsBlank(drpStatus.Selected.Value);
 true;
 false
 );
 'Created by'.DisplayName = drpTeacher.Selected.DisplayName || If(
 IsBlank(drpTeacher.Selected.DisplayName);
 true;
 false
 )
)

Is there any solution to use the dropdownbox filled with users?

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

WackdeMack 197 on at

Like
a
(0)

Report
Copy link

Link copied!

Found an solution with Power Automate 🙂

I add a new field, CHOICEteacher, choice field with 2 teachers. The update this column with the created by displayname. I changed my code and now i can use the dropdownfilter very easy 🙂