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?
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
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsI have tried this, but it doesn't take it as a valid path.
Hi @Denk-IT_Aryan ,
Thank you for your quick reply.
Could you post your flow screenshot and the error?
Thanks
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsIf 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.
Hi @Denk-IT_Aryan ,
Thanks for your flow screenshot. Did you tried entering the custom value in table?
If you liked my response, please consider giving it a thumbs up
Proud to be a Flownaut!
Learn more from my blogPower Automate Video TutorialsHey abm,
I get the error "Failed to fetch : GetTable"
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.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!
User | Count |
---|---|
41 | |
40 | |
37 | |
34 | |
30 |
User | Count |
---|---|
46 | |
36 | |
33 | |
25 | |
24 |