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
Announcements
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
Hi @xxxx12345 ,
You should be able to create a view in Dataverse on the table to accomplish your need here...
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.
power automate in this case is not helpful because your problem is which data to show, not how to just retrieve it or filter.
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
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.