Announcements
Hi, I have problem to set "default" item into edit form. I dont use detail form. So I can't use "BrowseGallery1.Selected". I have ID of logged user. Depend on logged user ID, I need find the user in SP list (list of employee) and set this user into item in edit form. Can anybody helps me with any advice ? I tried LookUp function (maybe not in correct way), but it doest work. Have you some example how to make it, maybe with the right use of lookup?
if the default required user ID then use user().email
if something else please elaborate with steps.
Lookup() is the best way to do this. If you know the value of a field in the data source that will uniquely identify the record that is what you use for the lookup. So I'm assuming you have a list of employees in SharePoint. If the employee is in a Person/Group column this would be the lookup.
Lookup(SPDatasourceName, employeecolumnname.email = currentuserEmail)
Put this in OnStart to set the variable with the currentuseremail.
Set(currentuserEmail, user().Email);
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 345 Most Valuable Professional
11manish 207 Super User 2026 Season 2
Mohsin Ali 177
