Building collection from dataverse with showcolumns suddenly missing data

(1) Share

Report

Posted on by HansHeintz

704

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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Pstork1 68,923 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
HansHeintz 704 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No