PowerApps collection function results in [object Object]

[spartanboy]

My powwerApps screen contains:

• Text input: 'Topic', 'Date'.
• Dropdown input as: 'EmployeeID', 'EmployeeName' these values are from OneDrive, with Items property as `Distinct(employee_table,EmployeeID)` and `Distinct(employee_table,EmployeeName)`

Currently using a generic `Collect` function to collect these 4 fields into a table.

Button, OnSelect property as: Collect(List, {Topic: topic.Text, Date: date.Text, EmployeeID: employeeid, EmployeeName: employeename})

The Collection table results as: Topic and Date as 'Input value'. But, EmployeeID and EmployeeName shows as `[object Object]`

[gabibalaban · Accepted solution]

@spartanboy 

Collect(List, {Topic: topic.Text, Date: date.Text, EmployeeID: employeeid.Selected.Result, EmployeeName: employeename.Selected.Result})

[spartanboy]

@gabibalaban: I have 3 other 'Input text' as Number. how to show them in collection? 
WORKIN_HOURS: hrs.Value - give error

[gabibalaban · Accepted solution]

Value(hrs.Text) if you want to keep them as number, hrs.Text as text.

[spartanboy]

@gabibalaban :

While creating a JSON csv export, using:

Set(varFormattedJSON, JSON(List, JSONFormat.IndentFour));
ExporttoCSV.Run(varFormattedJSON)

get the below error: here 'hrs' is a input text with numbers..

JSON function cannot serialize tables/objects with nested property called 'hrs' of type control. 

[gabibalaban]

@spartanboy ,

i think you used the control name without a property, in this case Text. Use hrs.Text.

[spartanboy]

in collect function as this?

gives an error

[gabibalaban]

Try to change the column name or the control name . The system might be a little bit confused about the name.

[spartanboy]

in collect function - WORKIN_HOURS: hrs.Text,

gives an error in JSON CSV export as well as while collection.

But,  WORKIN_HOURS: hrs, works well with collection and not with JSON CSV export

collection list shows, for any columns that is date or a numerical text input. hence the JSON CSV error - how to fix this?

[naifhanis92]

I use this solution. Putting Selected.Result instead of .Selected but formula got some error. Is the any settings needed for the Combo Box?