cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TomasG
Advocate II
Advocate II

How to set item into edit form (not using detail form)

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? 
 

1 ACCEPTED SOLUTION

Accepted Solutions
Pstork1
Dual Super User
Dual Super User

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); 

 



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

2 REPLIES 2
Jagadeeshk
Responsive Resident
Responsive Resident

if the default required user ID then use user().email 

if something else 
please elaborate with steps.

 

Pstork1
Dual Super User
Dual Super User

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); 

 



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,098)