cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
niklasjegg
Helper I
Helper I

SPList Relationships

Hello.

I have 2 Sharepoint "lists". First List is "Users" and second is a Document Library "Documents".

 

In the Users List there are columns Like Name/Email/Subject Area and "Audit"(Multiple Choices).

In the Documents Library i have Files for Audits. For example word,pdf and so on.

 

I want to be able to assign a user to Multiple Documents in the "Document" List.

 

Is this possible ? Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
v-albai-msft
Community Support
Community Support

Hi @niklasjegg ,

What do you mean about "assign a user to Multiple Documents"? What do you want to do about this assign action?

If you want to add a assigner for each document, I think you can add a Lookup column in your library to achieve this. Something like this(the AssingedTo column is a Lookup column, get data from my list(Title column)):

valbaimsft_0-1623916026741.png

If this is your purpose, you can refer to below articles for more information about Lookup column in SP:

https://support.microsoft.com/en-us/office/create-list-relationships-by-using-unique-and-lookup-colu... 

https://sharepointmaven.com/how-to-create-a-lookup-column-in-sharepoint/

Best regards,

Allen

View solution in original post

2 REPLIES 2
v-albai-msft
Community Support
Community Support

Hi @niklasjegg ,

What do you mean about "assign a user to Multiple Documents"? What do you want to do about this assign action?

If you want to add a assigner for each document, I think you can add a Lookup column in your library to achieve this. Something like this(the AssingedTo column is a Lookup column, get data from my list(Title column)):

valbaimsft_0-1623916026741.png

If this is your purpose, you can refer to below articles for more information about Lookup column in SP:

https://support.microsoft.com/en-us/office/create-list-relationships-by-using-unique-and-lookup-colu... 

https://sharepointmaven.com/how-to-create-a-lookup-column-in-sharepoint/

Best regards,

Allen

View solution in original post

Hi @v-albai-msft 

 

i just figured out that i can add a lookup column and assign my users to this document. Im trying to build an app to see which user has which "Document(e.g.training)" completed. and notify me via a flow if the user needs to redy the training(e.g. safety training etc..). Some "users(workers)" can have more than 1 safety training because they are at many different stations. i Just need my user list to contain information about when they completed the training and when the training needs to be renewed.

 

Thanks and BR!

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,244)