How would I be able to view the names in the AssignedTo field? This is a SharePoint Tasks List.
Go to Solution.
AssignedTo field is a table contains multiple value.
So it can’t be displayed in one column in the data table.
The alternative method is creating a new column using “AddColumn” function and add it into the data table to display the name you want.
If your “AssignedTo” only has one Item you can use “AddColumn” function and “First” function.
If your “AssignedTo” has multiple Items you can use “AddColumn” function and “Concat” function.
If you have any other better solutions please let me know.
Hope this helps.
View solution in original post
Check it out!
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