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

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Fields erase after sub...
Power Automate
Suggested Answer

Fields erase after submission of record

(1) ShareShare
ReportReport
Posted on by tscott07 74
I have a powerapp that is connected to a SharePoint list. Basic setup is click button if approved, set variables and submit. I have 3 different stages that set different variables. The first stage submits and shows up in the sharepoint lists. Once it moves to the 2nd stage and it approved and submitted, the 1 stage fields delete from the list. Then the same thing happens when the 3rd stage happens, the 2nd stage columns delete. I am at a loss and not sure what the issue may be. Does this sound familiar to anyone? 
 
 
 
Categories:
General topics
I have the same question (0)
  • Suggested answer
    11manish Profile Picture
    11manish 769 on at
    Root Cause
    When your app submits data to a SharePoint list using SubmitForm or Patch, it is likely overwriting the entire record instead of updating only specific fields.
    So in Stage 2 or 3:
    • Only the current stage variables are being sent
    • Previous stage fields are not included in the update
    • As a result, those earlier values get cleared (set to blank)
    How to fix it
     
    Option 1: Use Patch with existing values (Best practice)
    Ensure you preserve old data:
    Patch(
        YourList,
        LookUp(YourList, ID = SelectedID),
        {
            Stage2Field: NewValue,
            Stage1Field: ThisItem.Stage1Field   // preserve old value
        }
    )
    Always include existing values for fields you don’t want to lose.
     
    Option 2: Check your Form configuration
    If using forms:
    Ensure all stage fields are:
    • Included in the form
    • Not accidentally reset or cleared
    • Avoid switching forms that only contain partial fields
  • Suggested answer
    MS.Ragavendar Profile Picture
    MS.Ragavendar 6,301 Super User 2026 Season 1 on at
     
    How to verify the version in SharePoint?
     
    SharePoint by default having versioning information available while selecting the item and click on version history which will have all the information which are being updated.
     
     
     
    Why this is happening?
     
    I believe you are having 3 levels of approval with column (stage and status), From the Power-apps form perspective you might be having 3 different variables however while storing the data it might be on the same column. So every time status and stage gets updated previous level values are getting replaced.
     
    Alternatives
    From the Power-apps perspective you are having different Set / UpdateContext variables, in the same way create new columns in the sharepoint such as (i.e L1_Stage, L1_Status, L2_Stage, L2_Status,L3_Stage,L3_Status) so every time you have patch only the respective status and stage in this way this issue can be resolved.
     
    ✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

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

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 589

#2
Valantis Profile Picture

Valantis 328

#3
David_MA Profile Picture

David_MA 284 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Share your ideas and struggles with building Power Automate flows!
Survey: Power Automate mobile app
How to Ask for Help with Your Power Automate Workflow
Flows are not visible for users who sign in with their personal accounts
Start and wait for an approval action
Restore a deleted flow
List of actions cheat sheet for Power Automate Desktop
Question for everyone : How are you using Create Text GPT in AI Builder?
Welcome to the Power Automate forum!

Product updates

Microsoft Power Platform Community release plans