Why?
An issue can occur when you are using Canvas Apps and Data Sources that use related Lookup Data. The issue is that secondary data in the lookup suddenly returns a blank value ⁉
What?
My symptoms were:
- in a Form Control using all default Data Cards,
- one of the Data Cards looking up data from the default Currency entity within Common Data Service
- while playing the Canvas App (not in the Power App Studio) blank data was returning
How?
From all the online info I have found thus far, it seems the issue can be caused by an update on Microsoft side.
It is not only an issue occuring connecting to the Common Data Service, but also in other enterprise worthy data sources like (Azure) SQL.
Just like any other day, Microsoft releases a new Power App Version. You can see this in the Version History of your Power App.
Suddenly out of nowhere Lookup references like:
DataCardValue.Selected.'Currency Code'stop getting data…
The even stranger thing is that in the Power App Studio while building and designing the Canvas App –> everything works fine!
1) Just try to disable the Explicit column selection feature in the Settings of the Canvas App (need to save + restart the Studio) and see if this fixes the issue:
This feature is still in Preview so hopefully Microsoft fixes this ASAP 💪.
