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 / Selective fields not p...
Power Apps
Unanswered

Selective fields not populating in App when I edit in SharePoint

(0) ShareShare
ReportReport
Posted on by 134

Hi,

I have a SharePoint integrated app that I have created for onboarding and offboarding of employees. The first screen of my app allows you to select the Client and role the employee will be onboarded to, the employees name, managers name, etc.. The second screen of my app is restricted only to my teams group, but shows the Onboarding and offboarding cost, billing dates, Status of the task, notes, Last Review date and Review Status. A lot of the fields on this app depend on the selection of other dropdowns and I've gotten all of that to work. The problem I am having is I have published the app to SharePoint and when I go in to edit an entry, some of the fields do not populate the information that was saved in the entry to begin with, instead they pop up with the default data and unless you reset the values again before you save the form, it will save with those default values. I have looked into every property and can not figure out why this is doing this with some of the fields and not the others.

Categories:
I have the same question (0)
  • v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @LS579 ,

     

    Could you please share more details about your scenario? Which columns are involved in this situation? What are the types of these columns, Choices or LookUp? Do they allow multiple selections? What formula do you have in the DefaultSelectedItems property of Combo boxes controls or Default property of Dropdown controls?

     

    Best regards,

  • LS579 Profile Picture
    134 on at

    @v-jefferni Yes, so the four fields that won't populate with current information are two text boxes that are formulated to populate information based on a drop down selected and are formatted to show numbers as dollar amounts. the other two are drop downs. One is hard coded with its selections and the other gets the selections from the data source, but also has a formula that depends on the selection of another drop down. I posted pictures of each of their formulas used. 

    Screenshot 2023-11-16 074414.pngScreenshot 2023-11-16 074443.pngScreenshot 2023-11-16 073821.pngScreenshot 2023-11-16 074315.pngScreenshot 2023-11-16 074351.png

  • v-jefferni Profile Picture
    Microsoft Employee on at

    Hi @LS579 ,

     

    The two dropdowns rely on the select of another Dropdown "drpReviewStatus":

    vjefferni_0-1700189562151.png

    and the two Text input boxes rely on a Combo box "cboClient"

    vjefferni_1-1700189622434.png

     

    What are the default values of them?

     

    Best regards,

  • LS579 Profile Picture
    134 on at

    Update: I was able to get the two drop downs to show correctly. The only problem I am having now is the text input boxes. I have finally gotten them to actually show a number, but the issue I am having now is the number is defaulting to 100 and 50 (see pictures below) when a new form is being created and just the number without the currency formatting in the edit form. See my code below. I have reworked the formula many different ways and this is the only way it would even show a value. The formula is set in the Default property for each text input box.Screenshot 2023-11-17 095145.pngScreenshot 2023-11-17 095228.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

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 March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 551

#2
WarrenBelz Profile Picture

WarrenBelz 430 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 298

Last 30 days Overall leaderboard