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?

[RandyHayes]

@tshomake 

It sounds like you've got some issue with your datasource in PowerApps if it is not reflecting the proper column.

If your column is called EmailAddress, then that is what you should see in PowerApps (especially on a simple column like text).  I'd first do a refresh on your PowerApps Usage datasource and then make sure you are seeing the proper name for your column.

The formula you are working with - !IsBlank(LookUp('PowerApps Usage', Episode = ThisItem.Name && EmailAddress = varUserEmail, ID))  should work perfectly for what you are trying to do.  So if not, then we can explore after your refresh the datasource.

Also, a little troubleshooting tip - if you want to just see something from your datasource, put a label on the screen and set the Text property to the following:

"Episode: " & First('PowerApps Usage').Episode & "  EmailAddress: " & First('PowerApps Usage').EmailAddress

That should show you the values from the first record in your list.

[tshomake]

Used the code EmailAddress: " & First('PowerApps Usage').EmailAddress

and it is able to pull the first record. When i patch the data to the table I force the email to be lower cased with command Lower()

I also did it with the episode and it was able to find the data.

I’m stumped on this.

It doesn’t matter the order if i put EmailAddress only its able to determine if an EmailAddress is available- This one doesn’t seem to try and match the emails. I have also tried removing VarUserEmail and instead use Lower(User().Email) and the same thing occurs.

If i put it for the episodes only for the code. Then the icon is visible for the episodes that has been watched by everyone.

Thanks for the help fellas @RandyHayes @yashag2255 

[RandyHayes]

@tshomake 

Seems odd...can you share some screenshots and formulas that you are using.  Perhaps some sense can be made from that.

[tshomake]

@RandyHayes 

You will see the check mark I am trying to get to show under "Listened". When the episode is clicked a 'PowerUsage' is updated with the episode name and email address of the person who clicked it. 

Currently under episode one I have only made that file I have clicked for testing purpose. The check mark is showing for all the episodes. 

Select Episodes is a document library that is housing our episodes. 

Goal is to have this sharepoint list and if the user clicked and episode PowerApps show the check mark letting the user know they have listened to the episode.

[yashag2255]

@tshomake 

Can you try to update the expression to:

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

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[tshomake]

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

This made the statement false and the icon is not showing for any item in the gallery. Only Episode 1 Should show up based on my user information.

@yashag2255 

[yashag2255]

@tshomake 

Can you confirm if this part EmailAddress = Lower(User().Email) of the expression is appropriate? Are all the entries in EmailAddress column lowercase? If not, can you try to change it to:

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

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[tshomake]

Yes everything in the SharePoint List is lower case. When I patch the data in from PowerApps I force it to lowercase the results. But just in case I tried it without Lower() as you suggested and its not working. 

@yashag2255 

[RandyHayes]

@tshomake 

So, what is the formula you are using to put the item in PowerApps Usage list?

Also, let's try to troubleshoot a little on this.

Put a Label on your Screen and set the Text Property to:

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

See if that returns the number for the record in your list.

[RandyHayes]

@tshomake 

Also, did you happen to rename your Title column in your list to Episode? 

If so, the try the suggested formulas and substitute "Title" for "Episode"