cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Can't get SharePoint to capture logged in user name

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:

amulhearn0207_0-1595942667717.png

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

amulhearn0207_1-1595942738862.png

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.

amulhearn0207_2-1595942805416.png

 

2 ACCEPTED SOLUTIONS

Accepted Solutions

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

View solution in original post

@amulhearn0207  no problem at all.

 

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

 

Thanks 🙂

View solution in original post

6 REPLIES 6
Helper I
Helper I

Hi @amulhearn0207 ,

 

I think the issue might be with your Update property on your card.

Change it from ThisItem.Team Member to User().FullName

Thank you for the quick reply. 

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


amulhearn0207_1-1595944291757.png

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

amulhearn0207_2-1595944321320.png

 

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.

 

amulhearn0207_3-1595944441590.png

amulhearn0207_4-1595944474256.png

 

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

View solution in original post

Thank you very much. This is perfect.

@amulhearn0207  no problem at all.

 

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

 

Thanks 🙂

View solution in original post

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.

Helpful resources

Announcements
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (30,967)