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 / PowerApp displaying in...
Power Apps
Answered

PowerApp displaying incorrect data on view and edit

(0) ShareShare
ReportReport
Posted on by 14

I have a ridiculous app requirement that's causing an issue.

 

I have a dozen or so combobox fields that are derived from a SharePoint Choice column that have a prefix. Depending on the results of a different field on a different form, different choices will appear in these fields. I have custom collections for these fields that load OnAppStart. They have a "Value" field and a "Display" field.

 

For example the choices available in SharePoint might be:

Reco::Blue

New::Black

Both::Green

 

So the custom collection is (in JSON):

Colors:

[

 {

  Display:"Blue",

  Value:"Reco::Blue"

}

],

 {

  Display:"Black",

  Value:"New::Black"

  }

],

[

 { 

  Display:"Green",

  Value:"Both::Green"

  }

]

 

and my Patch function uses this:

  Color:

     {
     '@odata.type': "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
      Value:ColorDropDown.Selected.Value
      }

}

 

All of this works. It properly saves the correct data into SharePoint.

 

The problem is thus:

When I go back into edit or view the data using the form instead of showing me the correct "Display" field data, it brings up the "Value" of what's stored in the field.

 

Does anyone know how I can correct this so that it figures out what the right "Display" field should be?

Categories:
I have the same question (0)
  • Verified answer
    WarrenBelz Profile Picture
    155,291 Most Valuable Professional on at

    Hi @Bartron ,

    The Default of the control will determine what is displayed in it. If it is (for example) Parent.Default, then it will display the value currently stored in a record if the control is on a form linked to that record.

    Is this what you are asking?

  • Bartron Profile Picture
    14 on at

    Almost...The control selectable items property is bound to an object that has a Value and a Display column.  

     

    The control's datasource is a SharePoint Choice field that stores the Value of the selection. 

     

    When I go in to edit an entered item I want it to display the "Display" field that corresponds to that Value that is entered.

     

    Can I somehow use a lookup to compare against the "parent.default"?

  • Bartron Profile Picture
    14 on at

    Update! Yes! I got this to work with this bizarre formula:

     

    If(Or(Form.Mode = FormMode.Edit, Form.Mode = FormMode.View), LookUp(Colors, Value in ThisItem.'Color'.Value), Parent.Default)

     

    Thanks for the push in the right direction!

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

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 1,027

#2
Valantis Profile Picture

Valantis 644

#3
11manish Profile Picture

11manish 626

Last 30 days Overall leaderboard