Answered

How to patch a user into a LookUp column in a UserLog in SharePoint List

(0) Share

Report

Posted on by BenDonahue

932

Unless it is a horrible idea, I would like to patch my users presence in a UserLog. I could grab their email, ID or whatever, but it might be better to put their identifying information into a LookUp column.

How is this done?

This has not worked:

Patch(DDLUserLog, 
 Defaults(DDLUserLog),
 {
 UserLookUp: {'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
 ID:Office365Users.MyProfileV2().id
 }
 }
);

Thank you.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

WarrenBelz 156,763 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @BenDonahue ,

I do something similar tracking logins

Patch( DDLUserLog, Defaults(DDLUserLog), { UserMail: User().Email, LoginTime:Now(), AppUsed:"WhateverApp" } )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps
BenDonahue 932 on at

Like
a
(0)

Report
Copy link

Link copied!

If I am interpreting correctly, you are using one list to track logins for all apps. I like it. I was going to create app-specific lists, but I like your approach better.

If you would, do you know of a way to store an Office365Users user into a SharePoint field? I assume that would be a LookUp column. Also, I am assuming this is possible; it may not be. Instead of storing a user's email or ObjectID, storing their profile may open avenues for me previously closed, but it might bog down the whole process, for all I know.

Thank you, Warren, as always 🙂
Verified answer

WarrenBelz 156,763 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @BenDonahue ,

Unless you really need those field types (People and Lookup), it is much simpler to simply store the data you want as Text (and saves a lot of grief later when you want to Filter/Sort/Lookup/GroupBy/Patch on them in Power Apps).

You can however use the Office365User connector in Power Apps to get this information. Bear in mind that User().FullName and User().Email are available directly in Power Apps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps