Multiple SharePoint List Person Fields - Need to Convert All IDs to Names

Hi , Anonymous 

According to your description, you want to get the names by ids.

According to your description, what you link should be a SharePoint List, which may contain an ID column, and you want to get the Names of these IDs. First of all, if you have a Name field in the returned person fields, you can extract the Name by "Add Custom Column".

If there is no Name field in the returned person fields, then you may need to obtain all IDs first, and then associate a "User Information List" to obtain the corresponding Name.

Also, creating a new "User Information List" is a good solution in my opinion if you want to fetch a large number of columns.

Finally, if I don't understand what you mean, you can also describe your problem in detail and give me some screenshots, and give me the final result you want.

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Anonymous