Gallery is showing random [object object] in different columns and 1 column with date of birth is only showing the first 5 field

[Mariette]

Hi

I have made a gallery and it shows in the column clientnumber  [object object]. I also get the same [object object] in the column interventies. It also shows only the first 5 records in de column date of birth.

My datasource is a sharepointlist. The clientnumber column is a textcolumn in the gallery and in the sharepointlist. The column interventies is in the gallery a textcolumn and in the datasource a choice column

The date of birth column is a date column

HELP!

Mariette

[timl]

Hi Mariette,

This sounds very strange. It almost sounds as though you set the properties of your gallery control incorrectly.

Can you confirm that you've set the Items property of gallery control to SharePoint list? If you could post a screenshot, that might help as well.

[Mariette]

Hi

Yes it set to the right Sharepointlist. It patch to a different sharepointlist. Is it possible that it has to do with the my patch formula?

Mariette

[PaulD1]

Hmm - very strange.

[object object] would typically indicate that the data your are trying to display is complex/tabular rather than a simple text field.

Perhaps double check your data types in the list and also see if the text entries contain sets of braces { } (used to denote the start and end of a record) in case Power Apps is getting confused by their presence.

[Mariette]

Hi

The column clientnumber is are number. and the column interventies is a lookup column.

Can you explain why the column date of birth is only showing the first 7 records?

Do I need to check in the patch formula if there are {}?

This is my code for patch. it is set on OnChange.

Concurrent(
If(
Gereed.Selected.Value = "Gereed";
Patch(
'Wachtlijst HOME team Lijnbaan';
Defaults('Wachtlijst HOME team Lijnbaan');
{
'Stauts aanmelding': Dropdown2.Selected.Value;
Geboortedatum: DateValue(Geboortedatum.Text);
Clientnummer: Clientnummer.Text;
'Datum aanmelding': DateValue(DatumAanmelding.Text);
Datumintake: DateValue(DatumIntake.Text);
'Intake gedaan door': {Value: "Intake"};
'Welk domein is geindiceerd': Domein.Text;
Interventie: Interventie.Text;
'Indien 2de interventie is geindiceerd': {Value: "Interventie2"};
Behandelingmetvoorrangstarten: BehandelingSpoed.Text;
'Umami of DBC': {Value: "UmamiDBC"};
Opmerking: InvoerOpmerking.Text;
'Komt in behandeling bij':BehandelingBij.SelectedText.Value;
Behandelaar: TextInput5.Text;
Regiebehandelaar: TextInput4.Text;Gereed:Gereed.SelectedText.Value
}
)
);
Notify(
"Vergeet niet eerst het secretariaat te mailen, voordat je op oplaan drukt. Na het opslaan wordt pt verwijderd van de wachtlijst";
NotificationType.Warning;
5000
)
)

For the column clientnumber is set to Text: ThisItem.Clientnummer

For the column interventies is set to Text: ThisItem.Interventie

For the date of birth is set to Text: ThisItem.Geboortedatum

What makes it strange is that the gallery displays the first 7 rows in my gallery correct and then is showing in the column date of birth nothing and in the columns clientnumber and interventies [object object].

[Mariette]

I have checked my sharepointlist. And the column is voor clientnumber is a single line text. The column interventies is also a single line text. In my form it is a lookup field. The choices wich the user can select are form a different list.

[timl]

Hi @Mariette 

To diagnose this, I would add the data source for your gallery to a collection.

Here's the formula that you can add to a button:

ClearCollect(
   colData;
   Filter('Aanmelden HOME-team Lijnbaan' ;
          StartsWith(Clientnummer;Zoeken.Text)
   )
)

If you then inspect colData through the File > Collections menu item, does the data look correct?

[Mariette · Accepted solution]

Hi Thanks for your help. Somehow Object object is solved. I don't know how but this morning it was gone and now the app works as it should be.

Gr. Mariette