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 Pages / Advanced Form Edits in...
Power Pages
Unanswered

Advanced Form Edits instead of Inserts

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi folks, I'm currently building an advanced form that goes:

1. Mode: Edit (Confirms account details, changes save on form edit, then click next step when done)

2. Mode: Edit (Shows list, able to create new records in that list on edit, then click next step when done adding to list)

3. Mode: Insert (Display form with record/registration #, make a selection from a dropdown, and click submit to save your selection to the record)

 

But the third step never creates a new record, just edits the one existing record that's created the first time the account runs the form. The number that shows at the top of Step 3 never changes, and a new record/registration is never created in Dataverse, just edited. How can I have the Submit tie the response to the record, and then the next time the Advanced Form is began create a new registration number?

Categories:
  • Mira Ghaly Profile Picture
    11,415 Moderator on at

    @Anonymous 

    Can you share  how your 3 steps are configured ; is the first and third step on different tables or the same table?

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    1. Load Tab / Target Table: account 

    2. Load Tab / Target Table: account

    3. Load Form / Target Table: registration

  • Mira Ghaly Profile Picture
    11,415 Moderator on at

    @Anonymous 

    Are you sure on your step 3 the form mode is Insert not Edit

    Mira_Ghaly_0-1634679301814.png

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I am! This is why I'm confused.

    kkrclearly_0-1634679511984.png

     

  • Mira Ghaly Profile Picture
    11,415 Moderator on at

    @Anonymous 

    Are you sure this is a new session, Go to Advanced find and look for Advanced Form Sessions (Previously Web Form Sessions) and try to delete all records and try again.

     

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    So Content > Advanced Forms > [Advanced Form Name] > Sessions, then delete all the sessions?

     

    I tried refreshing the sessions and then went to the portal in a private browser, then signed in. The number of sessions went up by one, but the form displayed the same record number. I submitted the form and went through the steps again in the same private browser and it appeared to create a new session here (reads: Created On [time] in Portal Management), but again just editing the current record.

  • Fubar Profile Picture
    17 Super User 2026 Season 1 on at

    Not sure if it is this, but it possibly is the "Start New Session On Load" setting of the Advanced Form (Web Form) on the General Tab. 

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    This is set to Yes - is that correct? Thank you for the suggestion.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    So I have an update: I was able to get this to work, but only temporarily. I changed the Form Definition > Record Source > Source Type to Current Portal User, and it works in the Portal. However, once I navigate to that Advanced Form Step in Portal Management again, the Record Source > Source Type has reset to null, and then when I try to go through the Advanced Form it gives me a "Sequence contains more than one element" error.

     

    A peer told me this field resets to blank because since it's an Insert, it doesn't have or need a Record Source, and the Portal Management is returning it to what it should be. Our conclusion is that in this case for this advanced form step, the form is not aware who the Current Portal User is. Maybe something in my Associated Table Reference is to blame?

  • Mira Ghaly Profile Picture
    11,415 Moderator on at

    @Anonymous 

    So your problem now is to relate the Insert step to your Current Portal User?

     

    If you need to associate the current portal user to your registration you can use below and set to your field on the registration that maps to logged in user

    Mira_Ghaly_0-1634790757000.png

     

     

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 Pages

#1
Mohsin Ali Profile Picture

Mohsin Ali 45

#2
sannavajjala87 Profile Picture

sannavajjala87 30 Super User 2026 Season 2

#3
11manish Profile Picture

11manish 22 Super User 2026 Season 2

Last 30 days Overall leaderboard