Best way to detect the highest ID number in SharePoint when uploading pictures from PowerApps

(0) Share

Report

Posted on by pal95

266

Hi, I am looking for the best way to detect the highest ID number in SharePoint when uploading pictures from PowerApps.

I must keep a pattern for pictures and I can't use a random number, it must be a picture number in the end, so something like:
photo_1
photo_2
photo_3

etc.

I am using Power Automate to upload them and ask for name in PowerApps, but when I use the Max() + 1 function, sometimes it doesn't detect the last record if the user uploads pictures too fast and a picture is lost.

I also struggle with offline function, as sometimes the user would upload pictures offline. I think it should read the values from SharePoint but as above, sometimes it doesn't detect the last record.

Any ideas for workarounds? Thank you!

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

BhargavPatel 660 Moderator on at

Like (0)

Report
Copy link

Link copied!

When you say SharePoint do you mean List or Document Library?

Was this reply helpful? Yes No
WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @pal95 ,

The easiest way of getting the last ID is

First( Sort( DataSource, ID SortOrder.Descending ) ).ID

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.

MVP (Business Applications) Visit my blog Practical Power Apps

Was this reply helpful? Yes No
pal95 266 on at

Like (0)

Report
Copy link

Link copied!

Document Library

Was this reply helpful? Yes No
pal95 266 on at

Like (0)

Report
Copy link

Link copied!

This doesn't catch the last ID if users are uploading pictures very fast (like a few in 1 minute)

Was this reply helpful? Yes No
VishalJhaveri 1,167 Moderator on at

Like (0)

Report
Copy link

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

Was this reply helpful? Yes No
BhargavPatel 660 Moderator on at

Like (0)

Report
Copy link

Link copied!

@pal95 How about appending the ID of the file itself to the file name in the flow, instead of Max( )+1?

Was this reply helpful? Yes No
Verified answer

WarrenBelz 154,799 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@pal95 ,

It should show that latest ID except for maybe a few seconds "gap" and there is really no solution for concurrent users.

Was this reply helpful? Yes No