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
Solved! Go to 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.
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.
User | Count |
---|---|
121 | |
88 | |
88 | |
75 | |
66 |
User | Count |
---|---|
215 | |
180 | |
138 | |
96 | |
82 |