Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Power Query
Answered

Another query

(1) ShareShare
ReportReport
Posted on by 76
I feel that I am slowly getting somewhere with my reasonably straightforward contact database. However I have a few outstanding questions, the first being.... Why are records stating New Contact rather than populating the field with the Full name of the contact? When I look at other solutions that I created when I was learning Power Apps, I can see that this area changed to the contact's name.
 
Next I plan to start looking at the Timeline features. We need to be able to extract information from the Timeline for reporting purposes. ie the number of times we have contacted our service users over a given period. If anyone has any pointers as to the best way to do this, then I'd love to hear from you. From the small amount of research that I've done, it looks like I'm best to add the Activities table and filter from that, but very happy to hear alternative suggestions. From what I can see, phone calls are included in reports, but for some reason Notes aren't. 
 
Categories:
  • CD-28031715-0 Profile Picture
    76 on at
    Another query
    Thanks both. I managed to suss last night that if I deleted the new name column that I was using and added in FirstName and LastName, then it worked as it should. Is there a way that I can have just one name field and have it work though? 
     
    As far as the timeline goes, we use phone calls and follow up texts/whatsapp messages, not emails so much. If I was to add a new activity of "Text/WhatsApp" could I have the content appear in the Timeline or not? If not, then what would be the best way to get around this? We could use a Note or Post but those wouldn't appear in the filters/reports. 
     
    Also how do I get system messages to appear on the Timeline? ie if a Contact is allocated to a colleague, or if a change is made to existing information? Or are these changes stored somewhere else?
     
    Your help is very much appreciated.
  • Verified answer
    Fubar Profile Picture
    7,821 Super User 2025 Season 1 on at
    Another query
    Activities are things like Email, Appointment/Meeting, Tasks, Letter, Phone Call and others including custom ones..
    Notes (and Posts) are their own object - not a type of Activity, the timeline control just displays them in the 1 list.
     
    Notes & Activities are linked to the main main record via a Regarding (objectid) field on the them.
     
    Regarding the Name, the first question  would be what happens when you refresh the screen?
    If it doesn't change, next thing to check would be if the field on the form is the field that is the Primary Name column (logical schema name "fullname") - As suggested by Ronald, it should be displaying the value in the Primary Name column which for the out of the box Contact is the fullname field.
  • Verified answer
    ronaldwalcott Profile Picture
    3,208 on at
    Another query
    For the first question show the definition of the table that you are using. The problem could be how you have the display defined.
     
    The name can come from the primary column.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,524 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 65,906 Most Valuable Professional

Leaderboard

Featured topics