Created By or User

[ClaireAllen]

Hello Community

I am building a Form and would like to display the Created By Name, Job Title & Department on the Form

I have created a label and entered a formula using Office365Users, but I know I have done something wrong and have tried to fix the issue, but no matter what I do, I can not get the information I need to display

I added a label but as it shows it has an error.

Could you help me with the Formula that I should be using to show the Created By Name, Job Title & Department or point me in the right directions, as I have the created by column from my SP List which is currently hidden on the Form.

Thank you in advance

Claire

[eka24]

It would have been goo to show your current forumula.

But try:

"Created By "&Textbox1.Text&" With Title"&TitleTextBox.Text&" Department:"& DeptTextbox.Text

Those highlighted are fields on your form

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[ClaireAllen]

@eka24 ,

Thank you for coming back to me, this is the formula I had in my Label

I'm a little confused on "&Textbox1.Text&" With Title"&TitleTextBox.Text&" Department:"& DeptTextbox.Text
Are you saying I need to add new fields on to my form?

Kind regards

Claire

[eka24 · Accepted solution]

I thought you already had those on your form and wated to Join the field on another Label.

Having given more information, generally use:

Office365Users.UserProfile(User().Email).JobTitle

You could change the JobTitle to Department

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[ClaireAllen]

Thank you @eka24 

That has worked as I wanted.

Kind regards

Claire