Not showing all folders

[Denk-IT_Aryan]

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?

[abm]

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

[Denk-IT_Aryan]

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

[abm]

Hi @Denk-IT_Aryan ,

Thank you for your quick reply.

Could you post your flow screenshot and the error?

Thanks

[Denk-IT_Aryan]

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

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.

[abm]

Hi @Denk-IT_Aryan ,

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

[Denk-IT_Aryan]

Hey abm,

I get the error "Failed to fetch : GetTable"

[jmillerutsw]

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. 

[IT-Ninja]

I had the same problem and overcame it by using "Add dynamic content > Expression" and entering the number 1.  That enables you to type free-text into the File line.  I just entered a space after the one and pasted the path and location to my file.  Then I deleted the number 1 and it worked!  I had to know my table name on the next line ("Table1") because it didn't fetch that but the fields I was looking for from excel became available.

I suspect you could use any of the dynamic content items and don't necessarily have to use and expression but I did not test that.

[ryb]

Thank you, this helped me out of my misery, i don't understand why SharePoint is making things difficult for everyone