Display both the Created By name & email

[MrAl]

New to Powerapps, just started my first one yesterday.  I created a customized form over a SharePoint Online list.  One of the requirements of the form is show the Created By user name and their email when viewing/editing.  I can see the DisplayName is the Primary Text and Email is the Secondary Text on the field on the form, but I can't seem to find how to have them both display.  Is this possible to do?

[RandyHayes]

@MrAl 

Welcome to PowerApps!  I hope you have a fun journey.

Can you provide a little more detail on what you are changing?  Are you referring to a Gallery in your App, a Label on the screen, a DropDown/ComboBox in an EditForm, etc?  All are very possible to change, but all have different solutions.

Perhaps a screenshot would hit the spot to start with.

[MrAl]

hmmmm...not sure, I think it's a label...maybe.  Like I said, this is my first experience with Powerapps, and coming from a .NET developer background, I'm still learning the symantics of these things.  🙂   Here's what I've done.  I created a list in SharePoint Online for a Training Request system.  I then clicked on the "Customize Forms" in that list, and it built the canvas app automatically.  After some tweaking of the presentation and some basic code to handle the New/View/Edit screens, I added a new field from the list (Created By).   I then added that field to the View and Edit screens, but it only shows the Display Name.  I've attached a pic of a screenshot.  

[RandyHayes · Accepted solution]

@MrAl 

Perfect!  The picture helps a lot.  

Yes, I understand the adjustment.  PowerApps is not a development platform, it is a world of difference from a coding language.  Some adjustment required!

So, here's what I am seeing, and I'm not sure it's what you really want, you've added a DataCard to your Form and chose the Author/'Created by' column.  PowerApps has chosen for you to make this a ComboBox control.  Kind of worthless...you cannot change or assign the 'Created by' column of a SharePoint item, so why bother?

So let's leave that for the moment and go back - your original request was to display the Author name and email address.  Since you cannot change that, there is no other need than a label to display it.

Taking that into account:

1) get rid of the Created By data card in your form.  

2) add a custom data card to the form 

3) Add a Label control to your Custom DataCard (click the data card and then the Insert controls, choose a Label from the Insert ribbon)

4) Set the Text property of the Label to :  ThisItem.'Created By'.DisplayName & " " & ThisItem.'Created By'.Email

That should give you what you want...feel free to adjust accordingly. 

[MrAl]

@RandyHayes 

Worked like a charm!  Thanks for your help!

[MwandjaKaluta]

Hello, thanks for help with the 'Created By' DisplayName. My question is now falling on how I could creates  a Search bar and allowing users to search information's from both  the 'Created By'.DisplayName and and an ID columns from the SharePoint list that I connected to my PowerApps.  I have tried coming up with multiple formulas to make the search box work  but none of them seemed to be working. 

For example, 

1) Search(ReqTracker_DocProject, inpSearch.Text,"'Created By'.DisplayName","ID")

2)SortByColums(Filter (ReqTracker_DocProject,StartsWith(ID,inpSearch.Text)),"ID",Descending)

With the second formula, the ID is working fine but I just need to know how I could add the Created By column so that they could work together with the ID in the Search Box

ReqTracker_DocProject is a SharePoint table that I connected to this PowerApps. Any help would be much appreciated and thanks.

Error Message= ReqTracker_DocProject = There is an error in this formula. Try revising the formula and running it again | Data type: Table

[RandyHayes]

@MwandjaKaluta 

You can only search on Text columns.  Anything else will produce an error.

If you have additional questions on it, you might want to post this as a new thread on the forum as this Thread is very old.