Announcements
Hi guys.I am trying to create start screen with user profile, but I do not know how to do them. I need to display a record where user id = User().email in a form. What I should to write into Item?As a newbie I know just Gallery1.Selected, but it is not usable in this situation. I will be thankful for a hint.
Try putting the LookUp() function into Form.Item property, like that:
LookUp(DataSource, id = User().Email)
I have tried it, but it doesn't work. The requested operation is invalid.
What is your data source for the user profiles, that you're trying to display? Try First(DataSource) first to see if you can build a display form for this record. You can also forgo a form control entirely and just capture the user record into variable ( Set(varUser, LookUp(DataSource, id=User().Email)) ) and then use its fields with dot notation (varUser.SomeField) to set values to individual controls (labels, images etc).
Thanks @MaciejMeller for advice. I've tried all formulas but nothing works. But after 4 hours exploring I am sure the problem it is in datasource. My data are stored in excel-file on sharepoint. But if I use as a datasource copy of excel-file uploaded on OneDrive all your formulas (and my too) work fine.What can be problem? Need I more permissions from our IT-department? Or is it somethink what am I able to solve by myself?
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 community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 329 Most Valuable Professional
11manish 209 Super User 2026 Season 2
Mohsin Ali 179