Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Building collection from dataverse with showcolumns suddenly missing data

(1) ShareShare
ReportReport
Posted on by 628
I
 
Since months I am building a collection like  this
 
 ClearCollect(
                        cAanwezigeDieren
                        ,ShowColumns(
                                    AddColumns(
                                                Filter(
                                                        Animals
                                                        ,Stay.Status=0
                                                        //,IsBlank(Stay.'Departure Date')
 
                                                    )
                                                ,AnimalStayId,Stay.Stay
                                                ,AnimalBreedName,Breed.Name
                                                ,AnimalColorName,Color.Name
                                                ,AnimalDossierId,Dossier.Dossier
                                                ,AnimalDossierName,Dossier.Dossiernummer
                                                ,AnimalDossierNumber,Dossier.'RVO-nummer'
                                                ,StayMedADate,Stay.'Date of Inspection Sales Medical (KA)'
                                                ,StayBehADate,Stay.'Date of Inspection Sales Behaviour (KA)'
                                                ,StayInclusionDate,Stay.'Inclusion Date'
                                               
                                                )      
                                    ,'Animal (doa_animalid)'
                                    ,'Animal Name'
                                    ,'Animal Number'
                                    ,'Date of Birth'
                                    ,'Animal Name Extra'
                                    ,'Chip Number'
                                    ,'Animal Species'
                                    ,Deceased
                                    ,'Nutrition (KA)'
                                    ,Sex
                                    ,'Castrated/Sterilized'
                                    ,'Memo Kennel (KA)'
                                    ,AnimalStayId
                                    ,AnimalBreedName
                                    ,AnimalColorName
                                    ,StayInclusionDate
                                    ,AnimalDossierId
                                    ,AnimalDossierName
                                    ,AnimalDossierNumber
                                    ,StayMedADate
                                    ,StayBehADate
                                    )
                        )  
 
Now It seems that for a number of records the value for the fields stated in showcolumns is just left Blank() 
I can understand Powerapps wants to be lean and leave out the unnecessary but if I use showcolumns it is pretty obvious I want those columns I would think.
Categories:
  • HansHeintz Profile Picture
    HansHeintz 628 on at
    Building collection from dataverse with showcolumns suddenly missing data
    What I mean is that data that is definetely there like ‘animal name’ (all animals have a name, it’s the obligatory primary name field for the table) some records in the collection are missing that value. The table is made by a third party and these field have different display names (dutch/English) in different environments so maybe i should stop using display names for fields.
     
  • Pstork1 Profile Picture
    Pstork1 64,767 on at
    Building collection from dataverse with showcolumns suddenly missing data
    Are you saying you aren't seeing values that are in the data source in those columns?
     
    or that its not showing the column if the value is null or blank?  If its the later that is by design.  Even with ShowColumns() the connector only returns columns that contain values.  All data is returned as a Key (column name) and a value pair. So its inefficient to return column names if there is no value.  That's the way its designed to work.
     
    If you are saying there are values in the data source that aren't being returned then that's a different problem.

    ----------------------------------------------------------------------------------
    If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

    Paul Papanek Stork, MVP
    Blog: https://www.dontpapanic.com/blog
     

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,475

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,767

Leaderboard