cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rodrkayl
Helper I
Helper I

First record appearing after SubmitForm

Hello,

 

I'm having the following issue. I currently have a form connected to a SharePoint database. I'm able to submit forms and have them successfully reflected in the database. However, in the form itself, whenever a new form is filled out and submitted, the record changes to reflect the first record in the database. Yet, the submitted record successfully reflects in the database and gallery. In other words, when I click the 'Submit' button, the form is successfully submitted but users are re-directed to the first record, rather than viewing what they just submitted.

 

This is my formula for the OnSelect of the Submit button:

SubmitForm(EditForm1); ViewForm(EditForm1); Navigate(EditScreen1); Set(ShowDeleteConfirm2, false); Set(ShowDeleteConfirm1, true)

 

1 ACCEPTED SOLUTION

Accepted Solutions
v-qiaqi-msft
Community Support
Community Support

Hi@rodrkayl,

Based on the issue that you mentioned, do you want to fill the form with the lately submitted record?

Could you please share a bit more about the Item property of the EditForm1?

How you set the Item property of the form will decide what it displays.

You could consider setting the OnSuccess and Item property of the EditForm1 as below:

 

Refresh(ListA) // OnSuccess property     
First(Sort(ListA,Created,Descending)) // Item property

 

Hope it could help.

Best Regards,

Qi

View solution in original post

2 REPLIES 2
RandyHayes
Super User III
Super User III

@rodrkayl 

What is the Item property of your EditForm?

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up. Solved your problem? - Click on Accept as Solution. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too!
v-qiaqi-msft
Community Support
Community Support

Hi@rodrkayl,

Based on the issue that you mentioned, do you want to fill the form with the lately submitted record?

Could you please share a bit more about the Item property of the EditForm1?

How you set the Item property of the form will decide what it displays.

You could consider setting the OnSuccess and Item property of the EditForm1 as below:

 

Refresh(ListA) // OnSuccess property     
First(Sort(ListA,Created,Descending)) // Item property

 

Hope it could help.

Best Regards,

Qi

View solution in original post

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

PA Community Call

Power Apps Community Call

Next call is happening on April 21st at 8a PST.

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors
Users online (52,023)