
I have an app that has gallery to find a project, then from there I can click on this project to move over to a edit form. When I click on the project button arrow I have this in its OnSelect(
Set( ProjectEditableRecord, LookUp( 'PSI - PROJECTS', ID = ThisItem.Title ) );
I get my record no problem, but for some reason, when I examine the record in variables on the left panel, I can see all the fields but
'Create by' and 'Modified by' are not present. weird. I have also ensured in the SP lists in column settings->show/hide columns that they are checked.
Any reason why they are not there?
In the label I have tried the following
ProjectEditableRecord.'Created By'.DisplayName
also
ThisItem.'Created By'.DisplayName
Here's how you can access the "Created By" field and display the user's name:
Ensure that you have a reference to the user in the "Created By" field, which means that this field should be set to store user information, not just text.
In your Power Apps formula, you can use the User().FullName function to retrieve the display name of the user from the "Created By" field. However, the field's internal name in SharePoint is "Author," so you should use that name in your formula. Here's how to do it:
ProjectEditableRecord.Author.DisplayName
This should display the display name of the user who created the project.
Mark as solution if this solves your issue. Give this post a thumbs up. Reply to this thread if you need further assistance. Thanks