Announcements
Hi everyone, I'm trying to create a screen showing the data input from the current user, something like a profile screen. The user information with "User().FullName" etc. is not enough. I have 10+ columns in a sharepoint list and would like to show them on the "profile screen". For example one of the columns is named "Organization". Any ideas? Thanks for your help!
@NamM_ Do you want to show information from a sharepoint list or just additional user infos from Azure AD.
If you need more User-Details you could use the Office365Users Connector
Office 365 Users - Connectors | Microsoft Docs
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.
Hey @PowerRanger thanks for the quick reply, I want show the data input only from the current user which are stored in a sharepoint list. Hope that clears things up.
@NamM_ OK. So in order to that you need to add your List as a datasource. You then need to do a LookUp to that list based on the current logged in user.
Something like: LookUp(mySharePointList, emailField = User().Email)
I assume that you SharePoint list does have a column which identifies which item "belongs" to a certain user. Based on that column you have to apply your filter. If you still having issues please provide a screenshot of your sharepoint list.
Hey @PowerRanger,it works! However there is an issue with choice colomns. I can't look up the data generated from choice colomns.Any idea how I can solve that? Current function looks like thisLookUp('AD Daten'; 'Title' = User().Email).OrganizationThanks ! 🙂
@NamM_ what do you mean by "I can't look up the data generated from choice colomns."
@PowerRanger The LookUp funtion works for the single line colomns, but I have 3 colomns which choice based. These get an error message when I try to use the LookIUp function.
Found the solution.LookUp('AD Daten'; 'Title' = User().Email).Organization.value
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 1,009
11manish 672
Valantis 628
