Not showing all folders

(0) Share

Report

Posted on by 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?

Categories:

Building flows

I have the same question (0)

All responses (9)

Answers (0)

abm abm 32,865 Most Valuable Professional on at

Like (2)

Report

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

Was this reply helpful? Yes No
Denk-IT_Aryan 11 on at

Like (1)

Report

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

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @Denk-IT_Aryan ,

Thank you for your quick reply.

Could you post your flow screenshot and the error?

Thanks

Was this reply helpful? Yes No
Denk-IT_Aryan 11 on at

Like (1)

Report

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.

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @Denk-IT_Aryan ,

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

Was this reply helpful? Yes No
Denk-IT_Aryan 11 on at

Like (0)

Report

Hey abm,

I get the error "Failed to fetch : GetTable"

Was this reply helpful? Yes No
utswmiller 4 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
IT-Ninja 2 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
ryb 41 on at

Like (0)

Report

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

Was this reply helpful? Yes No