Power Platform Community Forum Thread Details

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

Categories:

Building Power Apps

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.