Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I want to be able to access the person name and email for this SharePoint column and usually I can expand the columns, however in this case I keep getting "No Columns Found". Does anyone know why this would be happening? Thanks
UPDATE: This definitely has something to do with the person field able to be multiselected. I changed the column to not allow multiselection and it works. Now I just need to figure out how to get the email(s) from the multiselect person field and delimit by semi-colon
And other "person" fields like Author, Editor are RECORDS, not a Table. Why would there be a difference?'
Solved! Go to Solution.
Hi @guyatisk
Question 1:
After testing, it may affected by the data source connection, did you choose the 'SharePoint list' connection? If you choose this connection, when your emial is the multiselect person, it cannot support, you can change the connection to 'SharePoint online list'
It support the multi choice and can return the related value.
Question 2
The user email you seleced is from another table in the sharepoint list, so it will return the data type, and the Editor column is existed in the current table, so it will return record.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @guyatisk
Question 1:
After testing, it may affected by the data source connection, did you choose the 'SharePoint list' connection? If you choose this connection, when your emial is the multiselect person, it cannot support, you can change the connection to 'SharePoint online list'
It support the multi choice and can return the related value.
Question 2
The user email you seleced is from another table in the sharepoint list, so it will return the data type, and the Editor column is existed in the current table, so it will return record.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |