cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HansHeintz
Helper V
Helper V

Explicit column selection arbitrarily and irreversibly truncating record

In code below I can choose one of these lines (by commenting out the other)

;;Set(gAsiel_verblijf;Last(Filter(SortByColumns('[dbo].[asiel_verblijf]';"asiel_verblijf_id";Ascending);dier_id=gDierRecord.dier_id)))
//;;Set(gAsiel_verblijf;LookUp('[dbo].[asiel_verblijf]';dier_id=gDierRecord.dier_id))

 

If I choose the first line like here the record gDierRecord in the code below, which is a record from a completely different table looses all columns but 3 (as seen in when inspecting the record in the interface). All other columns do not produce errors but are just empty. The record cannot be revived by changing the code back and/or by

;;Refresh('[dbo].[dier]')
;;Set(gDierRecord;Blank())
;;Set(gDierRecord;Defaults('[dbo].[dier]'))
;;Set(gDierRecord;LookUp('[dbo].[dier]';identificatie_nummer_asiel=Value(cZoekterm)))

 

This error only presents itself with explicit column selection enabled.

The ditched columns are widely used in the app, I really miss them.

If explicit column selection becomes natural behavior I am .. unhappy.

 

 

 

 

Set(gDierRecord;Defaults('[dbo].[dier]'))
;;Set(gDierExtraRecord;Defaults(DierExtra))
;;Set(DitDierVerblijfStatus;-4)
;;Set(ExplainVerblijfStatus;"onbepaald")
;;If(
ViewMode=1;
Set(gDierRecord;LookUp('[dbo].[dier]';identificatie_nummer_asiel=Value(cZoekterm)))
;;If(!IsBlank(gDierRecord);
Set(gDierExtraRecord;LookUp(DierExtra;DocaNummer=gDierRecord.dier_id))
;;If(IsBlank(gDierExtraRecord);Patch(DierExtra;Defaults(DierExtra);{DocaNummer:gDierRecord.dier_id;Dier:""}))
;;Set(gDierExtraRecord;LookUp(DierExtra;DocaNummer=gDierRecord.dier_id))
)
)
;;Set(gAsiel_verblijf;Last(Filter(SortByColumns('[dbo].[asiel_verblijf]';"asiel_verblijf_id";Ascending);dier_id=gDierRecord.dier_id)))
//;;Set(gAsiel_verblijf;LookUp('[dbo].[asiel_verblijf]';dier_id=gDierRecord.dier_id))
;;If(!IsBlank(gAsiel_verblijf)
;Set(gKennel_asiel;LookUp(CachedKennelAsiel;kennel_asiel_id=gAsiel_verblijf.kennel_asiel_id))
;;If(!IsBlank(gAsiel_verblijf)
;Set(gKennel_groep_asiel;LookUp(CachedKennelGroepAsiel;kennel_groep_asiel_id=gKennel_asiel.kennel_groep_asiel_id))
;;Set(gAsiel_verblijf_extra;LookUp(CachedAsielVerblijfExtra;asiel_verblijf_id=gAsiel_verblijf.asiel_verblijf_id))
)
)
;;Set(RefreshDier;false)
;;UpdateContext({LftString:""})
;;UpdateContext({LftWeken:0})
;;UpdateContext({LftDagen:If(gDierRecord.geboortedatum>0;Today()-gDierRecord.geboortedatum;0)})
;;UpdateContext({LftJaren:RoundDown(LftDagen/365,25;0)})
;;UpdateContext({LftRestDagen:LftDagen-(LftJaren*365,25)})
;;UpdateContext({LftRestMaanden:RoundDown(LftRestDagen/30,5;0)})
;;If(
LftJaren=0
;UpdateContext({LftWeken:RoundDown(LftDagen/7;0)})
;;UpdateContext({LftRestDagen:Round(LftDagen-(LftWeken*7);0)})
;;UpdateContext({LftString:If(
LftWeken<16
;Text(LftWeken) & " wk" & If(LftRestDagen>0;" " & Text(LftRestDagen) & " dg";"")
;Text(LftRestMaanden) & " mnd"
)})
;UpdateContext({LftString:Text(LftJaren) & " jr" & If(LftRestMaanden>0;" " & Text(LftRestMaanden) & " md";"")})
)
;;If(!IsBlank(gAsiel_verblijf)
;If(
gDierRecord.overledendatum > DateValue("01-01-2000")
;Set(DitDierVerblijfStatus;-2)
;Set(DitDierVerblijfStatus;
If(
gAsiel_verblijf.vertrek_datum > DateValue("01-01-2000")
;-1
;gAsiel_verblijf.asiel_verblijf_status_id

)
)
))
;;If(IsBlank(DitDierVerblijfStatus);Set(DitDierVerblijfStatus;-3))
;;Set(
ExplainVerblijfStatus
;Switch(
DitDierVerblijfStatus
;-4;"onbepaald"
;-3;"niet gevonden"
;-2;"overleden"
;-1;"geplaatst"
;4;"Afstandsdier"
;8;"In beslagname"
;Text(DitDierVerblijfStatus)
)
)

 

1 REPLY 1
v-siky-msft
Community Support
Community Support

Hi @HansHeintz ,

 

Currently, It is not supported to allow  "Explicit column selection" and  "Improved data source selection and Common Data Service views " features work together, you have to disabled one. Reference: https://powerapps.microsoft.com/en-us/blog/improved-data-source-selection-and-common-data-service-vi... 

 

Snipaste_2019-12-31_11-36-39.png

Sik

 

Helpful resources

Announcements
User Groups Public Preview

Join us for our User Group Public Preview!

Power Apps User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (53,466)