web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Get particular value f...

Power Apps

Answered

Get particular value from Sharepoint list in PowerApps

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hello!

I have Sharepoint list with table - email of employee and amount of days for vacation.

How can I show in power apps some particular cell?

For exapmle in sharepoint

Employee Days

John 5

David 3

Max 4

David logined into application - powerapps has to find in sharepoint David and show 3

I have connected SharePoint and Office 365 as data source to PowerAutomate

I tried First('name of sharepoint list').'name of column', but it shows first value in list, somehow I need to add 'current user' or something like that

thank you in advance

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

BCBuizer 22,654 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous ,

To do this, you can use the LookUp function to select a certain row and then the "." operator to select a column.

Examples for how to use the LookUp function can be found here: https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-filter-lookup#examples

To retrieve the details of the current user, you can use the User function: https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-user

Putting these together will make something like the below:

LookUp( SharePointListName, EmployeeEmail = User().Email ).Days

Was this reply helpful? Yes No

Join the conversation