Hello,

I’m a beginner on power automaton and I’m facing a case I can’t solve.

The 1st step of my flow is to create an xls file on sharepoint with PBI as data source.
The file is saved in a folder under the name Docusign.xls.
There’s nothing to stop me dropping it each time under a different name, Docusign_date.xls, if necessary to solve my problem.

I can’t use list rows to obtain the columns contained in this excel file. I’ve tried the following method:
1) Send the file always under the same name and move it to a folder once processed because sharepoint prevents the creation of a file with the same name in the same folder.
When I rerun the stream, I lose the path (which is hard-coded) to the file in List rows.
2) Send the file under a different name, but I don’t know how to recover the columns of my new file in list rows.

In short, if the path is not hard-coded, it won’t work. And since it’s a new file every time I run a feed, I don’t know how to do it.

I thought of an office script that would compare the 2 files (id) and write the new lines in file 2. This file 2 would always stay in the same place. But I don’t know if it’s possible

Thanks in advance for your help

Hicham

​Hello,I’m a beginner on power automaton and I’m facing a case I can’t solve.The 1st step of my flow is to create an xls file on sharepoint with PBI as data source.The file is saved in a folder under the name Docusign.xls.There’s nothing to stop me dropping it each time under a different name, Docusign_date.xls, if necessary to solve my problem.I can’t use list rows to obtain the columns contained in this excel file. I’ve tried the following method:1) Send the file always under the same name and move it to a folder once processed because sharepoint prevents the creation of a file with the same name in the same folder.When I rerun the stream, I lose the path (which is hard-coded) to the file in List rows.2) Send the file under a different name, but I don’t know how to recover the columns of my new file in list rows.In short, if the path is not hard-coded, it won’t work. And since it’s a new file every time I run a feed, I don’t know how to do it. I thought of an office script that would compare the 2 files (id) and write the new lines in file 2. This file 2 would always stay in the same place. But I don’t know if it’s possible Thanks in advance for your help   Hicham    Read More

​