Hello everyone,
I need your help to create a flow that allows me to extract a sharepoint list in excel that is inside a sharepoint folder
Before I start, I'll quickly explain how my company's sharepoint looks like.
First of all in the section "Document" (see number 1 on the screenshot) we have several folders (ABCDE --> see number 2 on the screenshot). We also have several columns (see number 3 on the screenshot).
When I click on one of the folders (ABCDE --> see number 4 on the screenshot) I have a sharepoint list that appears with the same columns (see number 5 on the screenshot). In this sharepoint list I have several excel files as well as a lot of data and it is these data that I want to extract on power BI.
in sharepoint I have a button that allows me to extract the data via excel (see number 6 under the screenshot below).
my question is to know if it would be possible to create a flow that would allow me to extract data automatically via power automate?
to make it simple i try to avoid doing a manual manipulation.
I don't know if the fact that my sharepoint list is inside a sharepoint folder will be an issue ?
Can someone help me?
Thanks for you help
