Showing an Image using lookup of sharepoint list

[tshomake]

I am working on an internal Podcast application for my organization. I currently have created a Patch functionality that updates a SharePoint List with EmailAddress, User Name, Episode Click, and Time. To aid people using the app to remember what episode was listened to I wanted to change the visibility of icon to show based on this sharepoint list. 

Currently this is my code:

!IsBlank(LookUp('PowerApps Usage', Episode = ThisItem.Name And EmailAddress = varUserEmail))

What is hapening that each item in the document library is shows all false with this code. Based on my understanding and the data in my table it should only be showing true for the first episode. 

ThisItem.Name is the name of the episode which matches the Episode column

Once I add the AND to the equation it forces them all to the same value.

What am I missing?

[tshomake]

Lookup('PowerApps Usage', Episode="put in a known name that matches a known email" && EmailAddress = "a known to match email", ID)

When I used that code and put an Episode Name and a known Email (IE My email) my ID number showed. If i changed ID to EmailAddress it showed my email address. 

It appears that the conditional code is not able to find the record with the email and what episode was watched with it from the sharepoint list.

@RandyHayes 

[tshomake]

I actually misspoke here it shows the ID number of the record from the sharepoint list.

[RandyHayes]

@tshomake 

So back to your original - you mentioned it is all in lower, so let's put your formula to this in your check box.

!IsBlank(LookUp('PowerApps Usage', Episode = Lower(ThisItem.Name) && EmailAddress = Lower(User().Email), ID))

[tshomake]

@RandyHayes 

Just the email is forced to lower because I cannot control user information used by our organization. Episode Names are labeled by our group and cannot be changed.

I put this code in and its made all the icons show like before anyway.

!IsBlank(LookUp('PowerApps Usage', Episode = Lower(ThisItem.Name) && EmailAddress = Lower(User().Email), ID))

[RandyHayes]

@tshomake 

So in an earlier message you mentioned that you were putting the email to lower in the list and you had also done it with the episode.

You're not changing the names, your just creating a "viewed" list for your checkboxes separate from the main list. 

Is ThisItem.Name really the Episode name?  And again, do you have the formula you are using to write the record to SharePoint?

[tshomake]

@RandyHayes 

Sorry for the confusion

Here is the patch code for OnSelect-

Launch(ThisItem.'Link to item'); Patch('PowerApps Usage', {UserName: User().FullName, Episode: ThisItem.Name, ListenDate: Now(), EmailAddress: Lower(User().Email)})

I also noticed using - LookUp('PowerApps Usage', Episode = ThisItem.Name,EmailAddress)

in a label the email address for the first record would show. If another user had selected it would not show the second email address. 

[RandyHayes]

@tshomake 

A slight change you might want to consider on that formula:

Patch('PowerApps Usage', Defaults('PowerApps Usage'), 
    {UserName: User().FullName, 
     Episode: ThisItem.Name, 
     ListenDate: Now(), 
     EmailAddress: Lower(User().Email)
     }
);
Launch(ThisItem.'Link to item'); 

Not likely to impact the outcome, but better from a Patch standpoint.

So, if you put a label in your gallery and set the Text property to:

   Lookup('PowerApps Usage', Episode=ThisItem.Name && EmailAddress=Lower(User().Email), ID)

What do you get for a record that is known to be there?

[tshomake]

@RandyHayes 

Lots of read on that one- nothing returned

[RandyHayes]

@tshomake 

Typo, Please change Lookup to LookUp

[tshomake]

@RandyHayes 

sorry about that.

No text comes up at all when using that code