cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Not showing all folders

So I have a flow that thakes the input from a Microsoft Forms form and adds this to an Excel sheet on our Sharepoint.

 

We use the "Add a row into a table (Excel Online (Business))".

 

We can select our Sharepoint Location and Document Library just fine, but when we try to navigate to the file location, we do not get the complete folder tree, only the 100 or so first entries in a folder (it does not load extra files when scrolling down).

 

Is there a way to navigate to these other folders?

7 REPLIES 7
Highlighted
Super User III
Super User III

Re: Not showing all folders

Hi @Denk-IT_Aryan ,

 

Try manually typing the path something like this

 

/folder1/folder2/test.txt

 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up.

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Highlighted
Regular Visitor

Re: Not showing all folders

I have tried this, but it doesn't take it as a valid path.

Highlighted
Super User III
Super User III

Re: Not showing all folders

Hi @Denk-IT_Aryan ,

 

Thank you for your quick reply.

 

Could you post your flow screenshot and the error?

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Highlighted
Regular Visitor

Re: Not showing all folders

If I give in the path manually, it says it could not retreive values from the file.

screenshot-emea.flow.microsoft.com-2019.08.12-16_09_51.png

If I test with another file that I can reach from the build in navigation, it does work.

 

In the screenshot below, you can see that the list with folders only goes up to the letter H, but there are more folders there.

 

screenshot-emea.flow.microsoft.com-2019.08.12-16_14_13.png

 

 

Highlighted
Super User III
Super User III

Re: Not showing all folders

Hi @Denk-IT_Aryan ,

 

Thanks for your flow screenshot. Did you tried entering the custom value in table?

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Highlighted
Regular Visitor

Re: Not showing all folders

Hey abm,

 

I get the error "Failed to fetch : GetTable"

 

Highlighted
Regular Visitor

Re: Not showing all folders

I have run into this same issue, except our team was already using the excel spreadsheet and suddenly the link was severed. I am unsure of the source so I was attempting to set up a new flow from the Form to Teams, but I cannot locate the folder where the excel currently lives. When I try to type it directly, it either erases what I type or tells me that it is invalid. 

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

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

firstImage

New & Improved Power Automate Community Cookbook

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

thirdimage

Power Automate Community User Group Member Badge

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

Top Solution Authors
Top Kudoed Authors
Users online (5,784)