cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Lopez_0090
Helper II
Helper II

How to retrieve the data in the SPO Document Library (DocLib) folder

The following data is included in the document library.

I am looking for a way to get the value of "name" or "id" in each line of the document library.

* SPO list is rich in actions, and it is easy to get the values in the SPO list, but I don't know about the document library.

test1.png

What we ultimately want to achieve is to update the values in the document library (Folder A) .

I want to compare the "id" in this SPO list with the "id" in the document library as a key, and update the "name" in the document library with the "name" in the SPO list.

154815.jpg

154837.jpg

 

In order to achieve the above, I would first like to get the values ("name" and "id") of the document library, and I was wondering if there is a good way to do this.

I'm really in trouble, can you please help me out?

 

Best regards,

Lopez

1 ACCEPTED SOLUTION

Accepted Solutions
v-LilyW-msft
Community Support
Community Support

Hi @Lopez_0090 

Based on the information you provided, I created a flow.You can take a try with the screenshots below to see if it helps.

This is my test library and list

vLilyWmsft_5-1634546109787.pngvLilyWmsft_6-1634546134937.png

Flow in details:

vLilyWmsft_1-1634545602735.png

vLilyWmsft_8-1634546650552.png

You can find column internal name via List settings -> Click on the column name -> It’s at the end of the URL on the Edit column page, after ‘Field=’.

vLilyWmsft_3-1634545861885.png

vLilyWmsft_4-1634546017869.png

Save and test the flow.

After flow runs, the folder will be update like this:

vLilyWmsft_7-1634546375288.png

Hope the content above may help you.

Best Regards

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

 

View solution in original post

2 REPLIES 2
fchopo
Super User
Super User

Hi @Lopez_0090 

In order to get name and id attributes you can use SharePoint "Get files (properties only)" action: SharePoint - Connectors | Microsoft Docs

Regards,

Ferran 

 

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!
v-LilyW-msft
Community Support
Community Support

Hi @Lopez_0090 

Based on the information you provided, I created a flow.You can take a try with the screenshots below to see if it helps.

This is my test library and list

vLilyWmsft_5-1634546109787.pngvLilyWmsft_6-1634546134937.png

Flow in details:

vLilyWmsft_1-1634545602735.png

vLilyWmsft_8-1634546650552.png

You can find column internal name via List settings -> Click on the column name -> It’s at the end of the URL on the Edit column page, after ‘Field=’.

vLilyWmsft_3-1634545861885.png

vLilyWmsft_4-1634546017869.png

Save and test the flow.

After flow runs, the folder will be update like this:

vLilyWmsft_7-1634546375288.png

Hope the content above may help you.

Best Regards

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

 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Users online (2,735)