I would appreciate if someone can help me with a problem with the collect function.
I have a SP list with a User column. When I create a collect, in this column don't appear the name of the user, only an object.
Also, when I create a tabledata, in this user column just appeared "[objectObject]".
I've tried to set up this column as "job email", but also appear an object in the collect.
Is there any way for the name to appear in the collect, so that I can use it to send mails?
Go to Solution.
Because SharePoint Person column is complexed field and its "value" is object.
For data table control, you need to turn on experimental feature to display Email from person field.
Or when create collection, you can add extra column by AddColumns(datasource name, "email", Person.Email)
*Here I assume Person field name is Person.
View solution in original post
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand