PowerApps mainly focuses on lookups and variables that are linked to data sources that reside elsewhere. In fact, it is REALLY GOOD at this. However, what isn't really clearly documented in a single location are the formatting requirements around manual population of the various data sources within PowerApps.
If you're just getting started with static data and are importing it from Excel then read my post on this first and then come back.
