Unanswered

SharePoint id is not showing on Power app form after the successful form submission.

(0) Share

Report

Posted on by Kuma0002

I am building the Power App forms, and on the success page i want to display the SharePoint created ID for the tool users. but SharePoint id is not showing on Power app form after the form submission. I am using the formula (Formname.lastsubmit.id) function see below screenshot. Could you please suggest any way around to achieve this please?

Categories:

Building Power Apps

I have the same question (0)

All responses (18)

Answers (0)

Kuma0002 76 on at

Like (0)

Report
Copy link

Link copied!

place the below syntax in the default property
Last(Sort('User Information',ID)).ID
user information is name of the list in sharepoint.
Query: Should i create a field in sharepoint and name it "User Information"? or this is automatically a field in SP list.

Was this reply helpful? Yes No
UshaJyothiKasibhotla 204 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Kuma0002

Try the above solution and let me know if that works for you.

Was this reply helpful? Yes No
UshaJyothiKasibhotla 204 Moderator on at

Like (0)

Report
Copy link

Link copied!

1.Take a text input in the same screen which you want to display Id

place the below syntax in the default property

Last(Sort('User Information',ID)).ID

user information is name of the list in sharepoint.

after go to visible property of textinput and make it false.

Write the text whatever is required

for example,

"Your Generic email account creation request has been submitted successfully to the IT Support Team. Thank you! Reference No. " &TextInput2_1.Text

here TextInput2_1 is the text input's name you have made invisible

Please try it and let me know

It worked for me.

Thanks,

Usha.

Was this reply helpful? Yes No
Kuma0002 76 on at

Like (0)

Report
Copy link

Link copied!

Hi Usha,
take an input text box and put the below syntax in default >> Mention the Syntax here.
then make visible property of the text box false >> Same above input text box?
then add the textinput as shown below with the sentence >> Should I add one more text input field?
for example
"Your Generic email account creation request has been submitted successfully Thank you!
Reference No. " &TextInput2_1.Text >> i have used the formula ""Supplier add request form has been successfully submittedwith ID:" &MainForm.LastSubmit.ID"

Was this reply helpful? Yes No
UshaJyothiKasibhotla 204 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Kuma0002

Have you tried ?

It worked for me

Was this reply helpful? Yes No
Kuma0002 76 on at

Like (0)

Report
Copy link

Link copied!

@mmbr1606 Sorry but when i enter the timer start property to StartTimer , It shows an error message, it only accepts the True/False. can you advise please

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
so for the start try another thing

set the start property of the timer to StartTimer

in the onselect of the Button put this:

UpdateContext({StartTimer: true});Navigate(SuccessScreen)

ontimerend property set:

UpdateContext({StartTimer: false}); Navigate(NextScreen, ScreenTransition.None)

please be aware that you might modify the names of the screens to your needs

Let me know if my answer helped solving your issue.

If it did please accept as solution and give it a thumbs up so we can help others in the community.

Greetings

Was this reply helpful? Yes No
Kuma0002 76 on at

Like (0)

Report
Copy link

Link copied!

StartTimer function is showing incorrect, when I use Timer2 it seems correct. can you please send the correct formula?
Also how much time do you prefer to have to retrieve the ID from the SharePoint list? 60000 okay?

Was this reply helpful? Yes No
UshaJyothiKasibhotla 204 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Kuma0002

Try this

take an input text box and put the below syntax in default

then make visible property of the text box false

then add the textinput as shown below with the sentence

for example

"Your Generic email account creation request has been submitted successfully Thank you!

Reference No. " &TextInput2_1.Text

it worked for me and please let me know if any questions from your side

Hope this helps

Usha

Was this reply helpful? Yes No
mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!
hey

you do not really need the Ontimerstart property.

And yes the code would be:

SubmitForm(MainForm);StartTimer(Timer2)

if your timer has another name just exchange it with the Timer2 name

and yes you can set the visible property to false, so the endusers wont see the timer

Was this reply helpful? Yes No