cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
caruso1058
Microsoft
Microsoft

Returning No Values From SP Library Unless Directed at a Single Folder

Hello I am building a flow for our team that evaluates a SharePoint Library.

I initially tested this on a single folder within the Library.  If I direct the Get file (properties only) action to a single folder I get the results I want/expect sent to me in an email.

 

However, when I went to implement this for our team by having the Flow evaluate the entire Library, I get 0 results.

 

The first photo is the action that returns the proper results from a single folder. 

The second photo seems like it would evaluate the entire library however, it returns no results.

 

Is there a way to make the Get files (properties only) evaluate my entire library and return the items from each individual folder in the HTML Table I have set up?

 

 

specific folder.pngSP Library.png

1 ACCEPTED SOLUTION

Accepted Solutions

 

Hi @caruso1058 ,

 

Sorry for my late reply!

 

As far as I know, Filter array action is built-in action, it does not need to configure the connection, so there should be no authentication error.

 

Please try to update the connection of Get items action and check if the issue still exists.

 

Best Regards,

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

View solution in original post

3 REPLIES 3
v-bacao-msft
Community Support
Community Support

 

Hi @caruso1058 ,

 

As far as I know, if we set Limit Entries to Folder to blank, Get files action will return all the folders and files in the whole library that meet the filter criteria.

 

Please check the specific conditions of Filter Query in Flow run history, and then check if there are any items that meet the conditions in Library.

 

In addition, you can try to create a new Flow to see if it can return the expected items.

 

Best Regards,

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

Hello @v-bacao-msft ,

 

Thank you for your reply. After looking at the outputs I am guessing that I do not have the right permissions to access all of the files within the Library.

Would you by chance be able to verify that what I am assuming is correct?

I am receiving the following output from the Filter Array shown below:

 

{"error":{"code":"AuthorizationFailed","message":"The authentication credentials are not valid."}}

 Please see the filter array I am using in the photo below.

Based on that output--is my assumption correct that I do not have the correct permissions or am I doing something else wrong?Annotation 2020-06-04 173259.png

 

Hi @caruso1058 ,

 

Sorry for my late reply!

 

As far as I know, Filter array action is built-in action, it does not need to configure the connection, so there should be no authentication error.

 

Please try to update the connection of Get items action and check if the issue still exists.

 

Best Regards,

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

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

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

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (3,335)