Hi,
I'm having trouble populating a dropdown filter with names from a single select people picker/person or group column in a Sharepoint list. I have configured 2 other dropdowns to display distinct values from a string column and a choice column (both include a blank value that functions as a "show all") as follows:
String column dropdown items property:
Ungroup(
Table(
{DropdownOptions: Table({Result:""}) },
{DropdownOptions: Distinct('SPList',StringCol)}
),
"DropdownOptions"
)
Choice column dropdown items property:
Ungroup(
Table(
{Items: [""]},
{Items: Distinct('SPList',ChoiceCol.Value)}
),
"Items"
)
Does anyone have any ideas? Thanks in advance!
