Is it possible to auto populate per user information from a SharePoint List?
I have a form with the following text input
Payroll Name
Job Title Description
Home Department Description
Location Description
Reports To Name
Work Contact: Work Email
Also have a SharePoint list with all the users information data with the column above.
Wanted to see if there is way to auto populate that user information once they open up the form.
Hope you understand
Thank you in advance! 🙂
Solved! Go to Solution.
Hi @oappdev
In PowerApps you can get the current logged in users email using User().Email
Set this in a variable on AppStart function
Set(varUserEmail,User().Email)
To fetch data from the SP list
Use
Set(payrollData,Lookup(DataSource, Column = varUserEmail))
where payrollData - will contain the data for the logged in user
DataSource - name of your SP list
Column - column in the list where the email is mapped
Then to get the values for the user,
just use
payrollData.ColumnName
--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
Hi @oappdev
In PowerApps you can get the current logged in users email using User().Email
Set this in a variable on AppStart function
Set(varUserEmail,User().Email)
To fetch data from the SP list
Use
Set(payrollData,Lookup(DataSource, Column = varUserEmail))
where payrollData - will contain the data for the logged in user
DataSource - name of your SP list
Column - column in the list where the email is mapped
Then to get the values for the user,
just use
payrollData.ColumnName
--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
So i Set(varUserEmail,User().Email) on AppStart function
Where will i add
Set(payrollData,Lookup(DataSource, Column = varUserEmail))
Having one of those day
Hi @oappdev
OnVisible of screen where form is there
Set(payrollData,Lookup(DataSource, Column = varUserEmail))
--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
User | Count |
---|---|
255 | |
107 | |
85 | |
51 | |
43 |