User Check for Multi-Select Person Column

Working with large datasets in Power Platform often involves assigning records to individuals or groups. A common scenario is using a Data Table with a Multi-Select Person column to manage these assignments. But how can you easily check if the current user has any records assigned to them within this column?

Let's explore a simple yet effective approach using a Canvas app. For this demonstration, we'll use a text label to display the result, but you can easily adapt this logic to control other elements based on your specific use case.

Here's the code snippet you can use within your Canvas app:

With(
    {Records: YourTableHere},
    If(!IsBlank(LookUp(
        Records,
        User().Email in  YourPersonColumn.Email) // you can even look up a selected item or filter by ID
    ), "Records Found", "No Records Found"
))