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 / Gallery is showing ran...
Power Apps
Answered

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

(0) ShareShare
ReportReport
Posted on by 75

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

 

 

Categories:
I have the same question (0)
  • timl Profile Picture
    37,160 Super User 2026 Season 1 on at

    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 Profile Picture
    75 on at

    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

     

     

    patch gallery.PNG
    formule item property gallery.PNG
  • PaulD1 Profile Picture
    2,914 on at

    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 Profile Picture
    75 on at

    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 Profile Picture
    75 on at

    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 Profile Picture
    37,160 Super User 2026 Season 1 on at

    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?

     

  • Verified answer
    Mariette Profile Picture
    75 on at

    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

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 610

#2
Haque Profile Picture

Haque 317

#3
WarrenBelz Profile Picture

WarrenBelz 315 Most Valuable Professional

Last 30 days Overall leaderboard