Answered

Filter a SharePoint list to retrieve one specific value

(0) Share

Report

Posted on by BenVdP

Hi Community,

I know that this question has passed here quite a few times, but even by reading them and trying to apply it's solutions, I don't get it to work.

Scenario:

I have a SharePoint list with multiple fields; Employee (Person / group) and Vacation Available (number).

In my PowerApp, I want to show the vacation days left for the current logged in user.

Solution:

I created a collection OnVisible of the screen - ClearCollect(CollectionForBalances,LeaveBalance)
I've added a label on the screen and inserted following formula - LookUp(CollectionForBalances,User().Email = Employee.Email,'Vacation Available')

The label returns nothing, a blank. I don't know what I'm doing wrong. Hope someone can shed a light on this.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Sort by

Verified answer

eka24 20,925 on at

Like
a
(1)

Report
Copy link

Link copied!

From the leave balance table what i can see is employee, do you also have Employee.Email

If you have Employee.Email then try:
LookUp(CollectionForBalances, Email,=User().Email ,'Vacation Available')

Or
If the employee name matches office 365 fullname then:
LookUp(CollectionForBalances, Employee=User().FullName,'Vacation Available')

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Verified answer

CU-18081211-6 9,272 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Your code seems to be ok.
I'm absolutely sure that your collection isn't loaded with data, because you are using a single screen and the OnVisible property hasn't been launched even once.
Check please if the CollectionForBalances collection is loaded via View Menu->Collections.
If my assumption is correct, you can verify your app by running the app from outside the studio.

Hope it helps !

Was this reply helpful? Yes No
BenVdP 79 on at

Like
a
(0)

Report
Copy link

Link copied!

@gabibalaban & @eka24 ,

Thanks for your input.
I managed to get it to work. I changed the formula to LookUp(CollectionForBalances,User().Email in Employee.Email,'Vacation available') and afterwards, thanks to your tip @gabibalaban , I ran the app outside the studio, which then populated my collection.

Again, thanks for your help!

Was this reply helpful? Yes No