Issue with Datatable - Author/Editor became [object Object]

[Anonymous]

hello

I have a couple of Datatables in my app which are connected to a SharePoint list. Each have 5 columns, one of which is always Author. Now, after facing the well known bug when all columns on the datatable dissappear and needed to be added back again I discovered that column Author contains on all items the "[object Object]" value instead of falimiar name&surname of a user who has created the item. I've checked and I see the same problem with the Editor field.

If I open older published app everything works fine there - Author columns shows username. However, if I delete column and add it again - II'll get "[object Object]".

Thx in advance for help!

Best,

Nick

[Anonymous · Accepted solution]

Silly to answer to myself, in one hour, but maybe it will save time to someone else 🙂

So, it looks like the issue was in the fact that Items in the datatable had the following.

If(!IsBlank(varCustFltr),
   Search(
      Filter('New Application Form', Status=varCustFltr, Approver=User().FullName),
      varAXAccFltr,
      "AX_x0020_number"),
   Search(
      Filter('New Application Form', Approver=User().FullName),
      varAXAccFltr,
      "AX_x0020_number")
)

In this case Data Source was visible as "Custom" and there was an "Author" field possible to choose to show - and I saw "[object Object]". 

Now, I've cleaned Items property, and set it just to 'New Application Form', without any filters. After that field "Created By" actually appeares and after choosing it I see expected usernames. Then I just return formula from above to the Items property - and everything works back again.