[Bug] Using the ClearCollect() Function in PowerApps does not Pull any Lookup Columns from Common Data Service (CDS) Data Source

When I Collect from CDS Data Source into Collection in canvas app designer, the lookup fields are not being populated even though I can see the lookup values when I bind the data source to the data table.
This is the sample formula that I used

 ClearCollect(ContactCollection, ShowColumns(Contacts, "fullname", "createdby"))  

And this is the output collection without any data in the lookup column.

https://powerusers.microsoft.com/t5/Building-PowerApps-Formerly/Common-Data-Service-Returns-no-data-from-a-Lookup-column/td-p/272581
When I looked through how to resolve this issue, I finally found the forum thread above and the workaround solution suggested by one of the users is to use the AddColumns() and DropColumns() function to force the lookup field to be pulled.

You can also see the explanation of the workaround solution in the reply post the user mfco in that forum thread. Basically, what we are trying to achieve is to add a column from the data source of the lookup entity (e.g. User entity in this case for "createdby" column) in order to force the app to pull the lookup field data.

But in my case, adding the "Users" or "First(Users).User" as the column did not resolve the issue. So what I did was just adding the same createdby column of the first Contact record as a new column " First(Contacts).'Created By' "
Dropping a column is optional and you can keep it in the collection if it is not going to confuse the other makers.

This is the final formula after adding workaround solution and once it is added, the collection is populated with the values in the lookup column.

 ClearCollect(ContactCollection,  
   DropColumns(  
     AddColumns(  
       ShowColumns(Contacts, "fullname", "createdby"),  
       "tempColumn",  
       First(Contacts).'Created By'  
     ),  
     "tempColumn"  
   )  
 )  

Hope this helps others who are having the same issue until the issue is fixed.

Update: There is another workaround solution provided in the comment section.

 ClearCollect(clColl,Filter('[dbo].[Collection]', cnt_styles>0 And parent_season <> "" And category_1<>""))  

On the formula above, the Collection table from SQL Server table (through the On-Premises Data Gateway) was added to the collection clCol1 but the parent_season and category_1 columns were not filled. The workaround solution was to add the conditions for each of these columns.

Update 2: Another solution provided in the comment section was to disable the app setting (Settings--> Advanced Settings --> Explicit Column Selection)

When enabled, this parameter causes PowerApps to bring only columns referenced in the App. When that setting is OFF, the Datasource is fully loaded with all column data.

If you have any information about the permanent fix or a better workaround solution, please leave a comment below.