Unanswered

Help me please! EXCEL from FTP to a Sharepoint List

(0) Share

Report

Posted on by Community Power Pla...

I have created an app in powerapps that will be an interface from my database, What is my plan is to have my website sending to an FTP the tables from my DataBase ( in Excel) and then the flow get this excel and put on my SharePoint and then migrate the data from the excel to SharePoint list.

What I already have:

1. I can take the excel file from FTP to the SharePoint with the flow

2. I can take all the rows from the excel and populate my SharePoint list

What is the problem, every time that I take the excel file from FTP and put in the SharePoint list it cames without table ( and as it is a "new file" when I create a flow routine to create a table it doesn't recognize the file)

Also, all the time that my routine of FTP to SharePoint put a new version of the file, all the other routines don't recognize the file anymore.

Does anyone have any idea to help me?

Thanks a lot,

Daniel

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (0)

v-alzhan-msft on at

Like (0)

Report

Hi @Anonymous ,

Could you please share a screenshot of the configuration of your flow?
Have you created a table to the excel file in the FTP?
Since the FTP connector don't support to get the rows in a table in excel file, I afraid that there is no any way to insert the rows to the sharepoint list derectly with microsoft flow currently.
If you would like this feature to be added in Microsoft Flow, please submit an idea to Flow Ideas Forum:
https://powerusers.microsoft.com/t5/Flow-Ideas/idb-p/FlowIdeas

Best regards,
Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

My first flow, takes the file from the FTP and then create a Excel file in the OneDrive.

URL: imgur.com/a/Y05gDSt

My second Flow, Reades the sharepoint List and delete all the itens on it, Then reads the excel files in the onedrive and populate the sharepoint list with the new itens.

URL: imgur.com/gdYJi99

The are 2 problens on it:

1. Everytime a new file comes from the FTP and substitute the old one the second flow stop to recognize it. ( I think is something with the ID of the File)

2. And everytime a create a excel file in the onedrive it comes without a “table” so I have to create it manually, … I can create a from to create it automatically but then happens the same thing from the other problem, it loses the File patch.

Was this reply helpful? Yes No