Button/icon visibilty based on sharepoint list condition
I have built an app that is used to set tasks for our engineering department. The tasks are held in a SP list. Users navigate to their tasks via a button on the Homepage which takes them to a gallery where they can view and mark as complete tasks that are assigned to them.
I have made a red icon to appear in the corner of the Homepage button when the user signed in has one or more tasks to complete but I am unsure of the function and syntax to use in the Visible property of the red icon.
User is set OnStart of the app:
And, the user's email is in the AssignedTo column of the SP list.
Basically I need to say "be visible if there are one or more items in the SP task list that have UserEmailVar in the AssignedTo list column".
Completed tasks are moved to a second SP list by Power Automate so I don't have to worry about completed tasks being picked up too.