cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted

 

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
Highlighted
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.
Highlighted

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

Highlighted

 

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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (10,350)