
Announcements
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?
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 🙂