Skip to main content

Notifications

Power Apps - Microsoft Dataverse
Unanswered

dataverse

Posted on by 19

 i want to get the latest record of each user or id only to display in the table. Such in case every user creates  3 to 4 items in a day means i want one recent item of every user to be displayed 

Categories:
  • Drew Poggemann Profile Picture
    Drew Poggemann 9,291 on at
    Re: dataverse

    Hi @xxxx12345 ,

    You should be able to create a view in Dataverse on the table to accomplish your need here...  

    1. Create View with Filter of "Created By" "Equals Current User"
    2. Set Sort by Created On Descending

     

    filter.png

     

     

    sort.png

     

    You can now add this view to the list of Active Views for that table.  It is dynamic and would work for any user based on what records they created.

     

  • Guido Preite Profile Picture
    Guido Preite 1,483 on at
    Re: dataverse

    power automate in this case is not helpful because your problem is which data to show, not how to just retrieve it or filter.

  • xxxx12345 Profile Picture
    xxxx12345 19 on at
    Re: dataverse

    @GuidoPreite 

    so basically its not possible using power automate right

  • Guido Preite Profile Picture
    Guido Preite 1,483 on at
    Re: dataverse

    if you are using a model-driven app you can solve this problem by using a PCF control (but it requires code knowledge to develop) because with the standard views on your "entry" table is not possible to show the information in the way you are looking for.

    In a canvas app should be possible without PCF (so basically using a formula) but that requires also someone to knw how to build the formula

  • xxxx12345 Profile Picture
    xxxx12345 19 on at
    Re: dataverse

    hi @GuidoPreite 

    no its no like that consider iam having a contact table in dataverse each user is entering many enteries in a table i want to display the most recent entry of each user if i use createon desc means for all the users i will get only one recent entry but i want to display the recent entry of each user

  • Guido Preite Profile Picture
    Guido Preite 1,483 on at
    Re: dataverse

    if you mean by code (like C#) just add an order by clause createdon desc (and eventually top 1 to return just a single record) to get the latest created record.

    If you mean something else please expand your question because it is not so clear.

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

October 2024 Newsletter…

October 2024 Community Newsletter…

Community Update Oct 28…

Power Platform Community Update…

Tuesday Tip #4 How to Conntact Support…

Welcome to a brand new series, Tuesday Tips…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 142,473

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,659

Leaderboard

Featured topics