Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Using Flows
Suggested answer

Get item by custom column in a Document library

(2) ShareShare
ReportReport
Posted on by 27
Hello,
 
I have two lists with their respective document library in a SharePoint. 
 
List A - Document Library A 
List B - Document Library B 

The document libraries have a custom column called ParentID where is references the ID column in the list. 
 
In my power app, I create a record in List A from using data in List B. But I need to move the files in Document Library B to A. 

I set up a Power Automate.
 
I have tried Move File, Get Item, all SharePoint connectors, but cannot find a connector where I can retrieve the record by "ParentID". 
 
Any ideas on how to move the file, by looking up the ParentID? 
  • Suggested answer
    trice602 Profile Picture
    13,975 Super User 2025 Season 2 on at
    Get item by custom column in a Document library
     
    Please try Get files (properties only) to get your custom field.  Get files (properties only) works on a document library and lets you filter by custom metadata.
     
     

    ------------------------------------------------

     

     

    ⭐ If this was helpful, please like and check the box below "Does this answer your question" to help others find this too!

     

     

    Always glad to help! 💯💯💯💯💯

     

    Tom

     

    Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

     
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 2

Featured topics

Restore a deleted flow