Unanswered

Form.LastSubmit function is not working

(0) Share

Report

Posted on by CU25110749-0

I am trying to use Form.Last Submit functionality but it returns only a blank value. I thought it could problem with the form and tried it a new form and even that does not help either.

I tried changing the data sources as well, Form.Last submit is not working, However, already defined Form.Last submit still works. Only the newly defined Form.Last Submit returns blank values. What could be the reason for it?

Help me to solve this issue.

Inspection_Overview_form.LastSubmit returns data

However, Inspection Form_2. LastSubmit is not returning any data

To identify if the problem is related to the form itself or within the app, I tried the following steps

1. I created a new Inspection Form 2 with the same data source and tried the Form.LastSubmit it does not work .

2. I created a new Inspection Overview Form and tried Form.LastSubmit, even there it is not working but as you can see in the screenshot the previously defined Inspection_Overview_form.LastSubmit still works!

3. I tried creating a new app and inserted a new Form and connected to the data source and checked the Form.LastSubmit, the issue still remains the same.

Help me to solve this issue

Categories:

Building Power Apps

I have the same question (0)

All responses (24)

Answers (1)

mmbr1606 14,605 Super User 2025 Season 2 on at

Like (0)

Report

hey

can u please copy paste your code here so we do not need to retype?

thanks in advance

Was this reply helpful? Yes No
CU25110749-0 51 on at

Like (0)

Report

This is the code that I have used on the Text property of a label

"Total Parts Inspected: " & LookUp(

'Firewall Inspection Overview',

ID = Inspection_Overview_form_1.LastSubmit.ID

).'Total Inspected Parts ' & " ; " & " Total OK Parts : " & (LookUp(

'Firewall Inspection Overview',

ID = Inspection_Overview_form_1.LastSubmit.ID

).'Total OK parts ') & " ; " & " Total NOK Parts : " & (LookUp(

'Firewall Inspection Overview',

ID = Inspection_Overview_form_1.LastSubmit.ID

).'Total NOK parts ') &"; Last Submit ID : " &'Inspection Form_2'.LastSubmit.ID

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report

Hi CU25110749-0

Can you confirm that you're calling SubmitForm against your Inspection_Overview_form? If you Patch the items on the form or Patch Inspection_Overview_form.Updates, those operations would not set the LastSubmit value.

Was this reply helpful? Yes No
CU25110749-0 51 on at

Like (0)

Report

Yes, I am calling SubmitForm against both my forms Inspection_Overview_form_1 as well as Inspection Form_2. I am not using any Patch function to submit the results to the Sharepoint list.

Was this reply helpful? Yes No
LessCodePaths 100 on at

Like (0)

Report

Form.LastSubmit returns values only until you reset the form.
It is useful when you need to update a variable based on the last item you submitted.

Once you have captured the item in a variable, refer to the variable instead of Form.LastSubmit.

L.

Was this reply helpful? Yes No
CU25110749-0 51 on at

Like (0)

Report

But I have not used any ResetForm function. Even I tried creating a new form connected to SharePoint datasource in a new blank app, even there Form.LastSumit is returning only a blank value.

Was this reply helpful? Yes No
WarrenBelz 153,034 Most Valuable Professional on at

Like (1)

Report
Only coming in here to offer more compact code - although if you have submitted both forms, your original code should work
"Total Parts Inspected: " & Inspection_Overview_form_1.LastSubmit.'Total Inspected Parts ' & " ; " & " Total OK Parts : " & Inspection_Overview_form_1.LastSubmit.'Total OK parts ' & " ; " & " Total NOK Parts : " & Inspection_Overview_form_1.LastSubmit.'Total NOK parts ' & "; Last Submit ID : " & 'Inspection Form_2'.LastSubmit.ID

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report
Hi CU25110749-0

This might seem like an obvious question, but is Inspection Form_2 successfully adding/updating the record?

If the save operation fails, that would be a reason why the LastSubmit is blank. It might be worth Notifying the error in the OnFailure property of the app to highlight a failure.

Notify("Save failed", NotificationType.Error)

Was this reply helpful? Yes No
CU25110749-0 51 on at

Like (0)

Report

I tried with a new form in a new canvas app, even there the LastSubmit Function is not working.

I used a label to get the LastSubmit data. I had Form1.LastSubmit.'Inspection date' in the Text property of the label.

Form 1 is connected to the SharePoint list Firewall Inspection

I used save button to save the form and it has the following code in OnSelect Property :

SubmitForm(Form1); NewForm(Form1)

Upon submitting the form, the results are getting stored in the SharePoint List and that indicates the form is getting submitted but the Form.LastSubmit says no data.

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report
Hi CU25110749-0

With the new form that you're using, what if you try another field such as Count? Does that return the value that you entered (ie, 1)?

Form1.LastSubmit.Count

Also, can you confirm that you actually entered an Inspection Date into the date picker?

The screenshot that you posted shows what appears to be the placeholder date (December 31, 2001) rather than a date that's actually been selected or entered through the control.

Was this reply helpful? Yes No