web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Power App Flow Suggest...
Power Apps
Answered

Power App Flow Suggestion for Easy of Form Filling

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi all,

I am a pretty novice user of Power apps. I want to build a quality assurance app where the people in my firm who work in a specific department and area would use the app to fill out a form and the data will be saved in the sharepoint list.
There are  2 forms
1st has : Date, Department, Area, Person name, Score 1,  Score 2, Score 3, Score 4, Score 5.
2st has: Date, Comment, Comment type, Department, Area, Person, Attachment 

Now - everyone who works for me will use the app on their phone and the would be filling out around 10-15 records in a day. The problem is that everytime they submit the form the form resets and asks to fill everything again. I don't want them to go through this, I want that once they add a record and then they want to add another, Not all fields but few of the form fields should auto fill based on the specific person's last record. 

How do I do this? I am open to any and all suggestions and help.

Categories:
  • Michael E. Gernaey Profile Picture
    53,970 Super User 2026 Season 2 on at

    Hi,

     

    You can set the default value of your controls to be the FormName.LastSubmit.FieldName, but I would validate that the LastSubmit/Field value isn't IsBlank or IsEmpty etc depending on type.

     

    You can even set the Item for the Form to the LastSubmit. 

     

    Also, I am guessing you are just submitting and not specifically doing a reset?

     

    Here are some great examples

    PowerApps LastSubmit() with Examples - SPGuides


    Cheers
    If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    The column type is Number, Person, Text and Complex type.
    Not doing a reset, just submitting and letting the person add more records based off of the values they added before.

    Question: If we use last submit will it show the last submitted value in the sharepoint list? if that's the case then it can cause some issues if 2 people are using the app at the same time. Right?

  • Michael E. Gernaey Profile Picture
    53,970 Super User 2026 Season 2 on at

    It shows the last submitted based on the persons session, which I thought thats what you wanted.

     

    No it doesnt show the last submitted in general, that would break security like no ones business.

     

    🙂


    Cheers
    If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
    Thank You
    Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
    https://gernaeysoftware.com
    LinkedIn: https://www.linkedin.com/in/michaelgernaey

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hahah nice! Thanks. I will give this a try.

  • Michael E. Gernaey Profile Picture
    53,970 Super User 2026 Season 2 on at

    Please remember to make the answered solution as Resolved, so it helps myself and the community find them easier.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi,

    I tried that but it didn't work for me. 

    So the form looks like this:

    hardik_shah_0-1695405004748.png

    The tick mark on the top right corners has this code:
    SubmitForm(EditForm1_1);
    NewForm(EditForm1_1)

    As per your suggestion I tried adding the last submit: ( I tried with default, defaultselected and both )

    hardik_shah_1-1695405051323.png


    Am I doing something wrong?

  • Michael E. Gernaey Profile Picture
    53,970 Super User 2026 Season 2 on at
    Silly question Did you create a new row yet? If you haven't and you just ran the app it wont display anything
  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Um, I filled the form and click on the check mark, it created a new item on the sharepoint list and cleared the whole form and didn't fill it again with the defaults. 

  • Michael E. Gernaey Profile Picture
    53,970 Super User 2026 Season 2 on at

    KK one moment i will be right back and well get you going

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thank you! I will be waiting for your reply. Hopefully I will be able to work on this Monday 🙂

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 402 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 328

#3
WarrenBelz Profile Picture

WarrenBelz 296 Most Valuable Professional

Last 30 days Overall leaderboard