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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Sharepoint list data n...
Power Apps
Unanswered

Sharepoint list data not populating on edit form first load

(1) ShareShare
ReportReport
Posted on by

I have a sharepoint list that is populating an edit form with EditForm(Form). When I first open the app in preview, browser, or mobile and select the record from the gallery it navigates to the Edit form screen and the form I've created populates 3 of the 30 fields on the form but the rest are all blank. If I navigate back to the gallery with the back button and select the item via the gallery the missing field values are still missing. BUT if I navigate back to the gallery screen and select a different record it loads the Edit form with all the data. And then when I navigate back from the other item to the gallery and to the original item that was missing data, it now is populated with all the data in the fields.

 

Very strange behavior that only happens in this app even though I do build all my powerapps similarly.

 

Any help would be very appreciated.

Categories:
I have the same question (0)
  • v-monli-msft Profile Picture
    on at

    Hi @Anonymous,

     

    Will the data load if you try to refresh the list from data source list in PowerApps?

     

    Regards,

    Mona

  • Community Power Platform Member Profile Picture
    on at

    If I go back to the gallery and hit my refresh button ( Refresh(datasource) ) it does populate when I go back into that item. Interesting. So How do I get it to display the missing values on the first load?

  • sfishe Profile Picture
    77 on at

    I'm having this exact same problem! On first load, I always have to open the detail form for two items to get all the fields to populate, like you've described. I find this occurs across all of my Gallery --> Detail form arrangements, even though they're different tables and there are different scenarios (e.g. if the edit form is on the same screen or a new one). I'm also using SharePoint lists.

     

    I haven't found a solution unfortunately...

  • Community Power Platform Member Profile Picture
    on at

    I developed another powerapp that does almost the same thing as the other one and I am experiencing the same issue.

     

    A temporary bandaid I have done is just adding a refresh button to top of the browse screen and the editform screen with the onselect as Refresh('DataSource') and that maeks the form populate.

     

    this is definetly not a solution cause now I have to train my users to do that. I will most likely be submitting a support ticket int he next week if nothing pops up here.

  • sfishe Profile Picture
    77 on at

    bumping this back up

     

    Any thoughts MS staff? Seems to be a legit bug

  • sfishe Profile Picture
    77 on at

    Any possible input here from PowerApps staff?

     

    This would seem like an easily reproducible issue. 

  • PowerAppJammer Profile Picture
    19 on at

    We are experiencing a similar issue regarding galleries not loading until at least one interaction upon loading. We have a home screen that when selected(Pic #1), sends a collection filter to the proceeding screen's gallery. When the app navigates to the next screen (Pic #2), the galleries have not been filtered and seem to all be null. After manually interacting with the gallery once, the gallery is filled with the desired data set (Pic #3), and this resolves the issue for as long as you have the app loaded.

     

    This only occurs when in view mode vs. design mode, even when emulating in design mode we do not experience this issue. Seems to be similar bug to your sharepoint issue. home_screen.png

    Assignmnet_Screen.png

     

    Correct_Assignment_Screen.png

     

     

     

     

  • TiagoFreire Profile Picture
    313 on at

    I have nothing new to add but a "mee too". 

     

    Anyone found a definitive solution? 

    Currently I am working around with clunky solutions, like subverting the default "editForm" with view-only controls, and creating a new screen with an actual editable form. The transition from one screen to the other forces a data reload.

     

    That is needlessly clunky. Requires manually coding a whole editForm, collecting the data, editing a collection and patching the original. From the user perspective, it is also a bit bonkers, because it shows all data plus another edit button inside the edit screen to get to the real edit screen. - editception - .

  • Community Power Platform Member Profile Picture
    on at

    Adding @Audrie-MSFT to assist with this SharePoint question.

    @Anonymous

  • TiagoFreire Profile Picture
    313 on at

    This problem shows its ugly head on Canvas Apps, be they standalone, or Sharepoint custom forms.

    My focus currently is in customizing Sharepoint Forms with PA.
    If you try to do some minimum customization, such as e.g. 

    SET() to attribute a variable based from a value on the loaded data on the form, it may not set it correctly the first time the custom form is loaded.

    Clicking on a second item on the sharepoint list has the second item load correctly. 

    Clicking again on the first item then loads it correctly.

     

    This makes it problematic to do relatively modest changes like e.g. Conditionally load a custom set of item on a select box, based on an existing value.
    The above behavior is prone to user error and inconsistent form behavior leading to other problems.

    Besides the error-prone clickfest above, a workaround to it is a fugly kludge: subvert the initial editForm with a read-only display, and create a second view with an actual, editForm, which can be accessed by clicking on a button in the default view.

     

    This requires a lot of additional setup and needless complexity, and significantly raises the bar from the proposed "codelesss app platform", becoming much more difficult for newcomers.

     

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 765 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 272

Last 30 days Overall leaderboard