Answered

Can't get SharePoint to capture logged in user name

(0) Share

Report

Posted on by amulhearn0207

109

Hi, I am building a very simple app that allows users to communicate if they are leaving work early. The app feeds a SharePoint list so HR knows where our team is. I have all cards populating the proper fields on that list EXCEPT for the Team Member (person.) I want the Team Member column to automatically record the logged in user.

This is an image of the Card Level:

And this is an image of the label level I'm using to pull the team member name:

It seems to be returning the user name correctly in the app, but it is not storing in SharePoint.

The list is getting the other info, though.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (2)

Liam_Chapman 187 on at

Like (0)

Report
Copy link

Link copied!

Hi @amulhearn0207 ,

I think the issue might be with your Update property on your card.
Change it from ThisItem.Team Member to User().FullName

Was this reply helpful? Yes No
amulhearn0207 109 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the quick reply.

I've tried that option, and I get an error.

I CAN enter it as User() only, but SharePoint still doesn't capture the name.

I initially wrote it as a dropdown, which is still in place on another screen. It works there, but I don't want this option as it is only going to cause frustration or errors. I only want the logged in user to be the Team Member recorded for an entry. But it does work this way.

Was this reply helpful? Yes No
Verified answer

Liam_Chapman 187 on at

Like (1)

Report
Copy link

Link copied!

Hi,

Try using this in your update function

{'@odata.type':"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser",
Claims:"i:0#.f|membership|" & User().Email,
Department:"",
DisplayName:User().FullName,
Email:User().Email,
JobTitle:"",
Picture:""
}

Assuming team members is a person column

Was this reply helpful? Yes No
amulhearn0207 109 on at

Like (0)

Report
Copy link

Link copied!

Thank you very much. This is perfect.

Was this reply helpful? Yes No
Verified answer

Liam_Chapman 187 on at

Like (1)

Report
Copy link

Link copied!

@amulhearn0207 no problem at all.

If that has resolved your issue, please mark as solution.

Thanks 🙂

Was this reply helpful? Yes No
Florian_Klug 33 on at

Like (0)

Report
Copy link

Link copied!

Same problem here... i can´t get logged in user in sharepoint list.
Unfortunately fhe formula for the update function doesn´t work.
Here are screenshots of my settings...

this part of the formula "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedUser" is marked red.
I´m thankful for every tip.

Was this reply helpful? Yes No