Unanswered

Last() not working properly

(0) Share

Report

Posted on by nottheOther

Function

Last(SharepointList).Title

Set as "Text" property in label, returns not last created but random title. This only occurs on one app, another app with the same fucntions works ok (at least for now).

Any ideas why?

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Pstork1 69,560 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

How many items are in the SharePoint list and how is it sorted?

Was this reply helpful? Yes No
nottheOther 65 on at

Like
a
(0)

Report
Copy link

Link copied!

Item counts as 1 row? Or in 1 row every column counts as 1 item?

Was this reply helpful? Yes No
Pstork1 69,560 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Each item is a single row.

Was this reply helpful? Yes No
nottheOther 65 on at

Like
a
(0)

Report
Copy link

Link copied!

In app when it occurs last ID is 42, but function show last as 41 in developer mode. For end-user title/id is random. Another app where everything is ok there are more items.
On Sharepoint list "edit current view" sorting on both lists is set up to "Sort by ID"

Was this reply helpful? Yes No
nottheOther 65 on at

Like
a
(0)

Report
Copy link

Link copied!

Anyone?

Was this reply helpful? Yes No
Pstork1 69,560 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Sorry, you'll need to provide a lot more information. based on what you've provided so far it looks like the coding is correct. Not sure why its not working as expected. Try adding a SortByColumn() based on ID to the data source declaration to make sure its sorted by ID when you ask for Last. Like this

Last(SortByColumn(datasource,ID)).Title

Was this reply helpful? Yes No
Chris_NJ 2 on at

Like
a
(0)

Report
Copy link

Link copied!

I think I have the same issue.
In my case, SharePoint list was created with each item having 5 columns, and the first column is a sequential ID number. I developed the app with a small data set (items 131-137), and Last(SharePointList).Column1 would return 137. Since then, to complete the data table, I added previous data in reverse order (131 down to 100), and sorted the list in SharePoint, low to high. My aim is to have the app automatically increment Column 1 when adding a new item.

In the editing environment, Last(SharePointList).Column1 still returns 137, the biggest number. When uploaded and pubished to Teams, Last(SharePointList).Column1 returns 100. I'm not sure what the disconnect is.

The editing environment tells me that Sort and SortByColumn are not supported for SharePoint lists.

Any way to get the Teams installation of the app to see the sort used on the Sharepoint List?

Was this reply helpful? Yes No