
Announcements
I am building a reporting tool for a PowerApps app that requires exporting the data from PowerApps on a daily basis. The export process uses PowerApps' built-in 'Export to Data Lake' function, which I have included the primary table and the relevant lookup tables.
I noticed that many fields in the app are choice fields, which seem to be treated by PowerApps as a type of lookup table, but do not seem to have corresponding external tables that can be included in the export. Without them, a field such as 'Status' that displays 'Complete' in Powerapps only gets exported as a numerical value such a '132501'.
How can the tables for the choice fields be included in an export to Azure Data Lake?
In addition, if the app is using a native Common Data Service as it's backend, can that be interfaced with directly? The only methods I have been able to find of viewing PowerApps CDS data are export to Data Lake, Flow, or PowerBI.