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.