Hi All,
In my App I am providing the user with the ability to Add an item. Where I am getting stuck is at adding the current logged in user's email and name to a SP List to an newly created record, I get the following result:
As you can see, as soon as I Submit my form everything gets created EXCEPT the User email & User's Name (First Row with ID 66 is how it SHOULD be, from 74-77 is how it's not working) .
I have the following code in my OnStart that checks if a user exists or not and adds the user if they do not exist:
// Obtain username and email of the logged-in user
Set(varLoggedInUser, User());
// Find the user with a matching email in the App Users list
With(
{wUserRecord: LookUp(LSS_TRACKER, Uzer.Email=varLoggedInUser.Email)},
Set(varUser, wUserRecord.FullName);
Set(varRole, wUserRecord.LSSRole.Value);
Set (varID, wUserRecord.ID);
Set(CurrentUserFirstName, Office365Users.MyProfile().GivenName);
Set(CurrentUserFullName, Office365Users.MyProfile().GivenName & " " & Office365Users.MyProfile().Surname)
);
// If matching user is not found, insert a new user into the list with the role User
If(IsBlank(varRole),
With(
{wUserRecord:
Patch(
LSS_TRACKER,
Defaults(LSS_TRACKER),
{
LSSPersonName: CurrentUserFullName,
Uzer: {
'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims:"i:0#.f|membership|"& varLoggedInUser.Email,
Department: "",
DisplayName: varLoggedInUser.FullName,
Email: varLoggedInUser.Email,
JobTitle: "",
Picture: ""
}
}
)
},
Set(varUser, wUserRecord.FullName);
Set(varRole, wUserRecord.LSSRole.Value);
Navigate(NewUser,ScreenTransition.Cover);
),
Navigate(AdminView,ScreenTransition.Fade);
);
This works fine at the start but IF an existing user needs to add another record, I have no idea how to auto-insert their Email / user name. As always, I appreciate any help!
