Unanswered

Need to show last entry dependent on column in sharepoint

(0) Share

Report

Posted on by broski1212

Hello Powerapps community,

I am attempting to display a gallery where it shows the most recent entry for each work period (connected to a SP list). In the app, the user enters hours dependent on their work schedule, but are free to go back and enter the most recent data for each period. This results in double entries in my Sharepoint list for the same period.

Currently, my gallery displays all entries, and sometimes double entries for a specific period. I have attempted to utilize the "Last" function or the "Distinct" function but am not entirely sure how to apply that to a specific column in a Sharepoint List.

Here is my code for the gallery as of now:

Filter('Capacity Form',Manager.DisplayName=User().FullName)

I would like to show the latest current user's entry dependent on a SP column titled "PeriodName"

Any thoughts or ideas?

Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

Tapesh 825 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @broski1212

If im right your are working with the form and sending the output to SPlist,

please use this on your Gallery Item: This works for me should work for you as well give it try.

First(Sort('Sharepointlistname',ID,SortOrder.Descending))

Best regards,
Tapesh
If this post helps, then please consider Accept it as the solution to help the other members find it or give it a Thumbs up 😄

Was this reply helpful? Yes No
broski1212 14 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @Tapesh ,

This code didn't seem to work. To drive more clarity, my gallery displays all of the user's previous capacity entries. I want it to only display their last entry for each period. See the current gallery below. As you can see, the period of 'March 23 - Apr 3' twice since i edited my entry. I want it to only display the latest entry.

Thoughts?

Was this reply helpful? Yes No
WarrenBelz 156,312 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @broski1212 ,
The issue I can see is that 'Period Name' is Text and therefore will sort alphabetically, which is useless to you. Unless you have one or both of those dates stored as a date, you would have to rely on the latest record either created or modified. For created, you can use the built-in numeric ID. One other thing is a Variable for User().FullName as this is not a delegable filter - so at App OnStart
Set(vUserName,User().FullName)
then the filter
First( Sort( Filter( 'Capacity Form', Manager.DisplayName=vUserName ), ID, Descending ) )
For Modified, just replace ID with Modified.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
WarrenBelz 156,312 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @broski1212 ,
Just checking if you got the result you were looking for on this thread. Happy to help further if not.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No