SharePoint List Customized PowerApps Form Not showing data OnEdit or OnView

[kmw1130]

I have a Customized PowerApps form on List A, which has a dropdown from List B that the user selects and it the populates the other fields on List A.  That all works great and saves the data to List A, but when I edit or view the item in List A, no data is displayed.  I did the suggestion from this post: https://powerusers.microsoft.com/t5/Building-Power-Apps/Edit-Form-is-not-displaying-data-from-saved-...

The most common cause is that the form can’t get the record you selected, so it shows empty. Please check whether item property of SharePointForm1 is set to the formula as below.

If(IsBlank(SharePointIntegration.Selected) || IsEmpty(SharePointIntegration.Selected),First('YourListName'),SharePointIntegration.Selected)

Also you can check whether OnEdit property of SharePointIntegration has been set as EditForm(SharePointForm1).

If All the property is right, please show me more Details.

But it did not work, my form is still blank on Edit and View.

[jefmeyer]

I'm assuming this is happening on a published form, not through preview mode. I would suggest setting up a monitor session on this form to verify that the data is being loaded on Edit/View. You can create a monitor session by navigating to List Settings -> Form Settings -> See versions and usage.

Good luck!

[kmw1130]

@jefmeyer Yes, it is a published form.

[kmw1130]

@jefmeyer I did the Monitoring, but not sure what it is suppose to show me, it saves to my list with no problems, it's opening it back up in either Edit or View the problem occurs.

[kmw1130]

@jefmeyer Interesting think I just tested, if I enter data into one of the fields that is not being pulled from List B, that data shows in my Edit of View form, but not the data I am getting from the List B.

[jefmeyer]

What is the field type on List A for the data from List B?  It sounds like List A data is displaying, but the control with List B isn't being set, so you'll need to check that the DefaultSelectItems is being set to the value from List A on Edit or View, but not New.  You can use similar logic to the Form.Item to see if a SP item is selected or not.

[kmw1130]

List A Title field was changed to a ComboBox that is getting a text field from List B, which then populates text fields and Person Fields in List A.
I don't have anything set for DefaultSelectedItems, what should it be?  I've tried Parent.Default, but I get a red squiggly line.

This is my Form.Item:
If(IsBlank(SharePointIntegration.Selected) || false,First([@'OCI Routing System']),SharePointIntegration.Selected)

[kmw1130]

@jefmeyer Do I need to put labels in those fields to display when viewing?

[jefmeyer · Accepted solution]

So my setup is:

1. Combobox connected to 'ChildList', which writes data back to a ParentList SP list with a Picked text column.

2. Combobox.DefaultSelectedItems = If(!IsBlank(SharePointIntegration.Selected),LookUp(ChildList,Title=ThisItem.Picked))

The New form will load the data from the ChildList (List B) and save back to ParentList (List A).  View and Edit states will display the selected value from ChildList (List B).  I'm using the OOTB controls on the form, except replacing the textbox with a combobox.

Hope that helps.

[kmw1130]

@jefmeyer Thank you!!!  That worked.