Showing results for 
Search instead for 
Did you mean: 
Advocate I
Advocate I

Is there a way to lookup the value in a document library when an item is created in a list

I'm looking for a way to assign relevant training to a new employee, I have a list of all employees, a document library with training that is required for each department and I want to bring the both together in a Training Matrix list.

I have used “When an item is created or modified” as the trigger on the list and “Get item properties” on the library but the Get item properties wants an item ID of the particular item, where I want to assign training to a user if the SharePoint group they are in matches the group of training documents for that department (Which is a property of the document) and then write that information to the Training Matrix List

Any suggestions?


Community Support
Community Support

Re: Is there a way to lookup the value in a document library when an item is created in a list

Hi @JoeyDig,


I assume that there should be a common column between the list and the library.

Please try to add the action Get files (properties only), then use a Condition to filter out the one that matches the condition. Then add other following actions under If YES branch.

You could also try to use the Filter query in action Get files (properties only) so that this action could only return the specific matched one.

Hope it could be your reference. Please take a try with it on your side.



Best regards,


Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Advocate I
Advocate I

Re: Is there a way to lookup the value in a document library when an item is created in a list

Thank you for your reply to my question but it isn’t the solution to the problem I face

List A – A list of users, their department and their job role

New User: Robert Paulson

Department: Shop floor

Role: Paint Sprayer


New User: Tyler Durden

Department: Shop floor

Role: Machine Operator



Document Library – A library of all training that that user must do with a column with the training role

Training Role            Document name

All users                    Fire evacuation

All Users                   Company Handbook

Paint Sprayer            Spray Chart

Machine Operator    CNC Guide


What I am trying to accomplish is, both users get assigned the All users training to complete, but additionally, Robert Paulson is assigned the Spray Chart and Tyler Durden is assigned the CNC Guide. So each user is assigned the training based solely on their role in the company

Helpful resources


Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!


New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!


Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (6,251)