Filter List on Person Data

[Anonymous]

Can you filter on Person or Group columns which reside in a 'key' lookup list for a main 'operational' sharepoint list?

I have a main list which users will use to submit new entries into. 

The lookup list has the 'Assigned to' Person/Group column type. 

The main list already is using several dependent dropdowns based on data in the lookup list.

I need the user who is completing the entry in the main list to only see the dropdown data they are responsible for completing in accordance to the 'Assigned to' Person/Group column in the lookup list. 

So if my name is selected in the Person/Group column for 2 out of 15 rows, only allow the main list to return those 2 rows of data when the dependent drop downs on the main list start.

[v-jefferni]

Hi @Anonymous ,

Could you please share more details about your scenario? How do users add new entries in to the "main list", using Edit Form?

If I understood correctly, would you like to filter the LookUp dropdown items depending on the Person column value, which is equal to current user?

If so, please consider set a variable in OnStart of the App:

Set(varUser, User().Email)

then in the Dropdown's Items, set:

Filter(LookUpList,PersonColumn.Email = varUser)

Please share more details about your app, screenshots including layouts would more be appreciated.

Hope this helps.

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[Coopedup]

On my App I set a Username variable in the OnStart and then use in my gallery Items I use this to filter the records.

//Gather name of logged in user. 
Set(
    varActiveUser,
    User().FullName
);

Filter(
					'Your source data name', 'Your named person field'.DisplayName = varActiveUser
				),

[v-jefferni]

Hi @Anonymous ,

Have you resolved the problem?

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.

[Anonymous · Accepted solution]

Yes. You can take all values in the People/Group column type and ungroup in collection. It was very difficult to get this to work, so if you know easier way please share.

Set(
    UserEmail,
    User().Email
);
Clear(col1);
ForAll(
    'SharePoint List',
    Collect(
        col1,
        {
            email: ThisRecord.'Assignee(s)'.Email,
            key: ThisRecord.Key,
            cat: ThisRecord.'Core Category',
            subcat: ThisRecord.'Core Subcategory'
        }
    )
);
ForAll(
    Distinct(
        Ungroup(
            col1,
            "email"
        ),
        key
    ),
    Collect(
        col2,
        {
            email: Filter(
                Ungroup(
                    col1,
                    "email"
                ),
                Email = UserEmail
            )
        }
    )
);
ForAll(
    Ungroup(
        col2,
        "email"
    ),
    Collect(
        col3,
        {
            email: Email,
            key: key,
            cat: cat,
            subcat: subcat
        }
    )
);