Creating a profile screen - Show data input from SP columns of current user

[NamM_]

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! 

[PowerRanger]

@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.

[NamM_]

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.

[PowerRanger · Accepted solution]

@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.

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.

[NamM_]

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 this

LookUp('AD Daten'; 'Title' = User().Email).Organization

Thanks ! 🙂

[PowerRanger]

@NamM_ what do you mean by "I can't look up the data generated from choice colomns."

[NamM_]

@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.

[NamM_]

Found the solution.

LookUp('AD Daten'; 'Title' = User().Email).Organization.value