Answered

Get the ID of last Item of Sharepoint and return it to Power Apps

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello everybody!

I want to get the highest/largest ID in a SharePoint library (the most recent item submitted) and return it to PowerApps (in order to use it as a "counter").
Is it possible? I am trying with formulas such as "Max" or "Sort" but every time this error appears:

It says that "Delegation problem” because it takes to many items.
I just want the last Item created ID and return it to Power Apps (so I don't need the formula to run through all the lines...).

Any solution will be usefull! Thanks!

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

eka24 20,923 on at

Like (1)

Report
Copy link

Link copied!

Sort and pick the first:
Last(Sort(Datasource,Descending)).CreatedID
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

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

Like (6)

Report
Copy link

Link copied!
First(Sort(Datasource,ID,Descending)).ID

@eka24 I think you meant to use this formula

First(Sort(Datasource,ID,Descending)).ID

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks the answers!

It works but I still have the delegation problem, the same as before (with the yellow triangle), as you can see:

Any ideas?

(For information, 'Non-conformité App is my data source (SharePoint Library))

Was this reply helpful? Yes No
eka24 20,923 on at

Like (1)

Report
Copy link

Link copied!

Change it from Last TO First
First(Sort('Non-conformité App,ID,Desending)).ID
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

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

Like (2)

Report
Copy link

Link copied!

The warning is because First() can't be delegated. But since you are sorting the list in Descending order, which can be delegated, you are assured that the highest Id is the First item in the list. So it won't matter that First() isn't delegable in this case. You only need the first item no matter how many there are.

Was this reply helpful? Yes No
v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi@Alexx1,
Based on the issue that you mentioned, do you want to remove the delegation warning?
Actually, the SharePoint ID field for a table is a number field in PowerApps. However, SharePoint only supports the equal "=" operator for delegation on an ID field.

Best Regards,
Qi

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Thanks to everybody for the answers!

So I tested with "First" too and the warning still remains as you explained:

So are you telling me that it is normal, and that it doesn't matter if there is a warning? And that I will never have any problem with this, even if I have 10000 Items for example in the future?

Thanks! 😉

Was this reply helpful? Yes No
Verified answer

eka24 20,923 on at

Like (3)

Report
Copy link

Link copied!

@Anonymous
The issue is that Sort in itself is delegable:
https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/delegation-overview

Sort Descending, turns the Table upside down such that the last item or ID becomes the first,
So you will not have issues picking the first from the sorted item which will be on top. That is it becomes number 1 no matter long the records.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
eka24 20,923 on at

Like (2)

Report
Copy link

Link copied!

The picture below has 7200 records in SQL:

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Yes, but you don't have the little yellow triangle warning in your example!

I have it, so I'm not 100% confident 😂

But if it works it is ok.

Was this reply helpful? Yes No