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 Apps / App from SharePoint no...
Power Apps
Answered

App from SharePoint not resetting all fields when clicking "NEW"

(0) ShareShare
ReportReport
Posted on by Community Power Pla... Microsoft Employee

Hi,

I have a PowerApps form created from SharePoint directly using the "Customer Form" option in a SharePoint list.

I've designed forms before, but this one is acting really strange

When I click the "New" button in SharePoint to launch a new form, I have the following rules set to my "SharePointIntegration"

 

Refresh('SharePoint List'); ResetForm('Form1'); NewForm('Form1')

 

The Text fields are reset; however all my dropdowns (which are pulled from other SharePoint lists) do not refresh. 

This does not occur on my other forms, which has exactly the same rules.

I've tried all the online resource possible with fail; any help at this stage is much appreciated

 

NOTE: I also tried to add a button within the app which applies the above code in the "ONSELECT" property, also without any success

 

Thanks

Luka  

Categories:
Building Power Apps
I have the same question (0)
  • mdevaney Profile Picture
    mdevaney 29,991 Moderator on at
    @Anonymous
    You can manually RESET the dropdowns by placing some code like this at the end of your SharePointIntegration code

    Reset(Dropdown1);Reset(Dropdown2);Reset(Dropdown3);

    The code above will make your dropdowns display whatever is in their DEFAULT property.

    —-
    Please Accept as Solution if this post answered your question so others may find it more quickly. If you found this post helpful consider giving it a Thumbs Up.
  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

     Many thanks for responding back so fast.

    I tried that but it doesn't work, which is also ridiculous??

    Ultimately, the Reset Form should kick off a reset like it does to my other apps - could this issue be related to a certain bug? 

    Come to think about it, Powerapps has been behaving differently over the past couple of days, My forms take double the time to load and save, functions suddenly stop working...Could it be Microsoft related?

  • mdevaney Profile Picture
    mdevaney 29,991 Moderator on at

    @Anonymous 

    ResetForm should also work if the dropdowns are inside of a form object.

     

    Two questions:

    1. Did the reset ever work?
    2. What code is currently in the Default property of your dropdown?

     

    ---
    Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

     

  • v-xida-msft Profile Picture
    v-xida-msft Microsoft Employee on at

    Hi @Anonymous ,

    Do you mean that all Text fields are reset within your Edit form, but the Dropdown controls are not?

     

    Based on the issue that you mentioned, I have made a test on my side, and don't have the issue that you mentioned. As an fixed solution, I think a global variable could achieve your needs.

     

    I have made a test on my side, please consider take a try with the following workaround:

    Set the OnNew property of SharePointIntegration control to following:

    Refresh('SharePoint List');
ResetForm('Form1');
NewForm('Form1');
Set(IsReset, false);
Set(IsReset, true);

    Set the Reset property of the Dropdown controls/ComboBox controls in Edit form to following:

    IsReset

     

    Please consider take a try with above solution, then check if the issue is solved.

     

    Best regards,

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Hi @mdevaney 

    Thank you for your response

    unfortunately, I developed the app really quickly and never actually tested it until it was done

    I've decided to recreate the entire app in a standalone canvas instead of starting it from SharePoint - hopefully this will be an advantage and I wouldn't run into any similar issues

    Will keep you posted 😃

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Hi @v-xida-msft ,

    Your suggestions makes total sense, something I've actually tried to do 2 days ago but what was happening is that the field would actually reset but remain locked - it's like the value is reset but the field doesn't really reset. 

    I'll be recreating the app from scratch and test it along the way to make sure this doesn't happen and probably identify the part causing it. Thank you once again for your help !!

  • v-xida-msft Profile Picture
    v-xida-msft Microsoft Employee on at

    Hi @Anonymous ,

    Could you please share a bit more about the " it's like the value is reset but the field doesn't really reset"? What do you mean?

    Do you mean that the available options within the Dropdown box are not updated from your other SP Lists?

     

    If you also want to refresh the available options under the Dropdown boxes, please consider take a try with the following workaround:

    Set the OnNew property of SharePointIntegration control to following:

    Refresh('SharePoint List');
Refresh('Other SharePoint List1'); // Add this formula to refresh other SP List data sources in your app
Refresh('Other SharePoint List2');
Refresh('Other SharePoint List3');
...
...
ResetForm('Form1');
NewForm('Form1');
Set(IsReset, false);
Set(IsReset, true);

     

    Best regards,

  • Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    I @v-xida-msft ,

    Sounds like a feasible solution, let me give it later this evening and get back to you

    Thank you for your persistence to help, means a lot 😃

  • v-xida-msft Profile Picture
    v-xida-msft Microsoft Employee on at

    HI @Anonymous ,

    Have you taken a try with the solution I provided above?

    Have you taken a try to re-create your custom form in your SP List?

     

    If the solution I provided above is helpful in your scenario, and the issue is solved, please consider go ahead to click "Accept as Solution" to identify this thread has been solved.

     

    Best regards,

  • Verified answer
    Community Power Platform Member Profile Picture
    Community Power Pla... Microsoft Employee on at

    Hi again @v-xida-msft ,

    so the solution that worked for me was as follows:

    Change the "Reset" property for all my dropdown fields

    code as follows: 

    If('formname'.Mode = FormMode.New,true,false)​

    This solved my problem.

    Thanks for your inputs and suggestions though, luckily i didnt have to go down that road and redesign the entire thing 😃

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 Apps

#1
WarrenBelz Profile Picture

WarrenBelz 549 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 225 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 224

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans