Unanswered

(Form).LastSubmit date not populating

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I have a form bound to an Azure SQL Database. There is a field "OfferDate", which is a Date type in SQL. Everything works as expected when a new record is created: the selected date saves to SQL properly and the form works normally.

But, if I access the form's "LastSubmit" property, the date value is empty. Note that LastSubmit does pickup everything else - including the primary key generated in the SQL db.

Can anybody help me understand what's going on here?

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

v-micsh-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Anonymous,

Issue confirmed.

I will dig deeper and see if I could find any anthing helpful.

Regards,

Michael

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

Like
a
(0)

Report
Copy link

Link copied!

I have the same issue. Does anyone know when this issue will be fixed? It's shocking that it has been 3 months and it still is not fixed. Are we supposed to wait for 2 years before they work out all of the bugs before we deploy any apps that really matter to our businesses?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

I have the same issue. I was trying to add a record to collection after submitting the form to dbo.table and I originally had Collect(collection,Form1.LastSubmitted) in OnSuccess but the date field would not populate even though all the other fields did. The workaround was to put Collect(collection,First(Sort(dbo.table,ID,Descending))) in the OnSuccess dropdown.

Was this reply helpful? Yes No
larspeterson 42 on at

Like
a
(0)

Report
Copy link

Link copied!

This still doesn't appear to be fixed. I am using Azure SQL too.

I collected my dates via a context variable on a submit button. On success of the form I then appended to the collection and a variable via a patch statement.

I attached this to a forms OnSuccess for when it is a new form in case anyone needs a little guidance:

UpdateContext({_MySelectedItemInGallery:
Patch(MyCollection,
Defaults(MyCollection),
MyForm.LastSubmit,
{MyDate: _MyContextCollectedDate}
)}
)

Was this reply helpful? Yes No
CreativeExpirements 5 on at

Like
a
(0)

Report
Copy link

Link copied!

Currently experiencing the same issue which causes my form to display some empty fields after submitting, even though the previous values are stored in my SQL database.
Seems like [Form].LastSubmit still can not hold date values, even after 4 years.

Was this reply helpful? Yes No