Get ID after just submitted form

(0) Share

Report

Posted on by hasherdene

Hi, is there any chance to get ID after just submitted form? I have a 2 screen, 2 SharePoint list and when I submit first form in first screen, I want to navigate second screen and also get ID from first list. But I have problem. ID = blank.

I think submitting data in SharePoint spent more seconds than navigating screen. Any solution?

@Reza

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Sort by

BCBuizer 22,654 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Hi @hasherdene ,

Perhaps LastSubmit() can help you:

LastSubmit(CoverForm).ID

Was this reply helpful? Yes No
Verified answer

timl 36,785 Super User 2026 Season 1 on at

Like (5)

Report
Copy link

Link copied!
@hasherdene

As @BCBuizer correctly suggests, LastSubmit will return the last submitted record, including the server generated ID value. However, the syntax you use would look like this:

CoverForm.LastSubmit.ID

Was this reply helpful? Yes No
hasherdene 14 on at

Like (0)

Report
Copy link

Link copied!

@timl , Thanks a lot. It works!

Was this reply helpful? Yes No
rahulx81x 17 on at

Like (0)

Report
Copy link

Link copied!

does this work with edited items as well, or only newly added items

Was this reply helpful? Yes No
BCBuizer 22,654 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi @rahulx81x ,

This works on both new and edited items.

Was this reply helpful? Yes No
rahulx81x 17 on at

Like (0)

Report
Copy link

Link copied!

Thanks!

Was this reply helpful? Yes No
neds 72 on at

Like (0)

Report
Copy link

Link copied!

This doesn't seem to work in Dataverse. Am I missing something?

Was this reply helpful? Yes No
BCBuizer 22,654 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @neds ,

No expert here, but I don't think there's a standard ID column in dataverse tables. You'll have to replace .ID with the column name that has the unique identifier. For the (standard) Account table, this looks like:

CoverForm.LastSubmit.Account

Was this reply helpful? Yes No
neds 72 on at

Like (0)

Report
Copy link

Link copied!

Afraid that doesn't work. I just get a generic error. In fact, I get the error for any field from the dataset, not just the GUID (primary column)

Was this reply helpful? Yes No
BCBuizer 22,654 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @neds ,

Then probably it's best to open a new topic for that if you haven't already.

Was this reply helpful? Yes No