You’re offline. This is a read only version of the page.
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
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:
Share
Report
All responses (
Answers (
22,266LookUp(
SharePointListName,
EmployeeEmail = User().Email
).Days
