Forum Discussion
Data set ID from Sharepoint List
I have a sharepoint list dataset that pulls in a user ID but only shows as a number. So i pulled in the data set of users form Sharepoint as well.
I cant for the life of me figure out how to convert my Author ID column to show the name from the userinformation list. I will then need to do this for the other coloumns, including th "List".
Hi, Anonymous
If you want to fectch the name in userinformation list, you can try the following custom column to convert Author ID column to show the name from the userinformation list.
Id Index:
=List.PositionOf(UserInformationLsit[Id],[Authorid])Name:
=UserInformationLsit[Name]{[Id Index]}Result:
Best Regards,
Community Support Team _ Eason
2 Replies
- amitchandak
Super User
Anonymous , Not very clear. You have joined them, Now you can have name from the user table and data from another table in visual
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos. - v-easonf-msft
Community Support
Hi, Anonymous
If you want to fectch the name in userinformation list, you can try the following custom column to convert Author ID column to show the name from the userinformation list.
Id Index:
=List.PositionOf(UserInformationLsit[Id],[Authorid])Name:
=UserInformationLsit[Name]{[Id Index]}Result:
Best Regards,
Community Support Team _ Eason
