Form populated automatically by Username

(0) Share

Report

Posted on by Mariollo

Hi guys,

I am currently building something like Audit Tracker.

I would like AUDITED BY field to be populated automatically by name of the user who is currently logged in (without possibility of changing this manually).

I tried User().FullName on default property but it didn't work.

All my users are in Azure AD so when I am using User().FullName on a simple label it works fine.

Screenshot 2022-01-27 150512.png

Categories:

Building Power Apps

I have the same question (0)

All responses (12)

Answers (1)

Sort by

Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

You need to use the Office365User connector.

Add the connector and in the default instead of User().FullName write:

Office365Users.SearchUser({searchTerm: User().FullName})

I think that is it and I didn t write anything wrong.

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
Mariollo 96 on at

Like
a
(0)

Report
Copy link

Link copied!

I got an error Expected record value.
The rule produces Table values.

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

To make sure you only receive 1 and onle 1, lets search by email:

First(Office365Users.SearchUser({searchTerm: User().Email}))

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
Mariollo 96 on at

Like
a
(0)

Report
Copy link

Link copied!

I do not have an error now but the field is blank and I can't choose anything.
Maybe it's worth to mention that my source is SharePoint list and this particular field is Person or Group column

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Same case here.

It is working for me.

Was this reply helpful? Yes No
Mariollo 96 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok, the problem is that I need to paste it in DefaultSelectedItem, not in Default.
One more thing - is it possible to disable this field, so users can't change it?

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Yes. On Display Mode. Change it to Visible or Disabled

Was this reply helpful? Yes No
Mariollo 96 on at

Like
a
(0)

Report
Copy link

Link copied!

Another problem 🙂
When this DefaultSelectedItem is auto populated and I click save form it doesn't update Sharepoint list.
It looks like it's only "preview" of user name. Any solution to this?

Was this reply helpful? Yes No
Nogueira1306 7,390 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!

Okay...Try this:

On App on start or OnVisible of the screen, anything. Set this var:

Set(varUser, {
DisplayName: Office365Users.UserProfile(User().Email).DisplayName;
Claims: "i:0#.f|membership|" & Lower(User().Email);
UserPrincipalName: UtilizadoresdoOffice365.UserProfile(User().Email).UserPrincipalName
}

And, on DefaultSelectedItem write:

varUser

If you need additional help please tag me in your reply and please like my reply.
If my reply provided you with a solution, pleased mark it as a solution ✔️!

Best regards,
Gonçalo Nogueira

Check my LinkedIn!

Check my User Group (pt-PT)!

Last Post on Community

My website!

Was this reply helpful? Yes No
Mariollo 96 on at

Like
a
(0)

Report
Copy link

Link copied!

@Nogueira1306 thank you for you answer, but is there everything correct with the formula in setting the variable?
It doesn't create one.

Was this reply helpful? Yes No