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 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 839
Valantis 533
Haque 412