Answered

Display both the Created By name & email

(0) Share

Report

Posted on by 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?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
MrAl 37 on at

Like (1)

Report

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.

Untitled.jpg

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (8)

Report

@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.

Was this reply helpful? Yes No
MrAl 37 on at

Like (1)

Report

@RandyHayes

Worked like a charm! Thanks for your help!

Was this reply helpful? Yes No
MwandjaKaluta 2 on at

Like (0)

Report

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

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No